M2M AD301 Guia do Utilizador descarregar pdf (Página 52)

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.

1 2 ... 47 48 49 50 51 52 53 54 55 56 57 ... 229 230

Sem comentários

M2M AD301 Guia do Utilizador Página 52