Creating the SSCAMaster application

The master application displays a list of departments within an organization. The application has two columns for department name, and department manager data.

Defining the SSCAMaster application

Log in to Mobile Web Studio.
Select Applications from the Build menu in the left pane, select New under Application Manager, and click the New button to launch Application Builder.
Click the down arrow to the right of Add, and select Database Element.
In the Database Elements Definition window, enter the JDBC information. The JDBC connection allows the master application to access a database and extract specific database information. This example uses sampledb on port 4747.
1. Select the JDBC URL option.
2. Complete these options:
  - Username – enter dba, which is the ASA database user name.
  - Password – enter SQL, which is the password used to access the ASA database.
  - JDBC Connect URL – enter the URL used by JDBC to connect to the database:
```
jdbc:sybase:Tds:localhost:4747?ServiceName=sampledb
```
  - JDBC driver – enter the JDBC driver used to connect to the database, in this case:
```
com.sybase.jdbc2.jdbc.SybDriver
```
  - SQL Query String – enter the following SQL code to select department heads for each department from sambledb:
```
select d.dept_name as 'Dept Name', 
e.emp_fname + ' ' + e.emp_lname as 'Dept Head' from department d, employee e 
where d.dept_head_id = e.emp_id
```
  - UI XSLT – leave this field empty.
Click Preview. A two-column table showing Dept Name and Dept Head displays in the Preview panel.

Dept Name

Dept Head

R & D

David Scott

Sales

Judy Snow

Finance

Mary Anne Shea

Marketing

Scott Evans

Shipping

Jose Martinez

If you click on the R & D row, the query does not work because of the “&”.
Click Next. The Define window displays.
Use the Define window to identify record 1 as the header row. In the Define Record Layout section, click “Records contain labels,” accept the default, 1, in the “Labels are displayed in Record” option, then click Next.
On the Filter window, click Next.
On the Configure Parameters window, click Next.
In the Window Preview window, in Element Name, enter SSCAMaster. Under Window Preview, notice the grid showing Dept Name and Dept Head.

Click Finish.
On the Application Builder window, click Save.
In the Finish window, accept all the defaults and click Finish to save the application..
Click OK to confirm.
Click Close to exit the Application Builder.
In Mobile Web Studio, approve the application:
- Right-click the SSCAMaster application in the detail pane, and select Approval Status | Approved.
- Click OK to confirm.
Select Approved from the Application Manager Status menu. You see your newly approved SSCAMaster application in the detail pane.

Dept Name	Dept Head
R & D	David Scott
Sales	Judy Snow
Finance	Mary Anne Shea
Marketing	Scott Evans
Shipping	Jose Martinez