User guide

Creating view models
42 Data Integration with Sybase Avaki Studio
Step 16 For the EMP database operation, which has a parameter, enter a value that Studio can
use when it executes the database operation to generate the schema. (The value might
be the name of an employee in the database.)
Step 17 Click Finish. Studio creates the new database operation. (You must refresh the data
catalog view to see it.)
Repeat this procedure to create the DEPT database operation, which has no parameters.
You can also create database operations using Avaki’s web UI or CLI—see the Sybase
Avaki EII Provisioning and Advanced Data Integration Guide for instructions.
Note If your database operation includes a SQL statement that involves aggre-
gate functions such as SUM, you must use an alias for any column names to
which the function refers. The alias must follow the rules for valid JavaScript
identifiers:
• Every alias must begin with a letter, an underscore (_), or a dollar sign ($).
• Every character after the first character may be a letter, number, underscore (_), or
dollar sign ($).
• All characters should be valid ASCII characters.
• Do not use a JavaScript reserved word as an alias.
For example, in the following SQL statement, dollarsum is an alias for the sum of
the column named DOLLARS.
SELECT sum(DOLLARS) dollarsum, CUSTOMERID FROM sales GROUP
BY CUSTOMERID ORDER BY CUSTOMERID