User guide

Creating view models
40 Data Integration with Sybase Avaki Studio
Step 6 In the Database Connector field, select a database connector, then click Next.
Step 7 In the Name field, enter a name for the database operation you’re creating.
Step 8 (Optional) In the Description field, enter a description of the database operation.
Step 9 In the SQL Statement field, enter the query that this database operation will execute:
• For getAllDepts, enter select * from dept
• For getEmpGivenName, enter select * from emp where ENAME = ?
Step 10 In the Modifies Database field, leave the No button checked. (Click the Yes button
when you create a database operation that performs an update.)
Step 11 In the Caching field, choose the caching behavior for the results of this database oper-
ation. (It’s ok to keep the default, “Don’t cache.”)
Step 12 (Optional) In the Run as field, specify the user account under which this database
operation will run.