Chapter 8 Building Web Services
This tab displays the SQL statement for the web service. You can use the following tools to type the SQL statement:
| Tool | Name | Description |
|---|---|---|
|
Operators | Provides logical operators |
|
Functions | Provides group, number, string, date, conversion and other functions |
|
Macros | Provides macros to accelerate the creation of a SQL statement |
|
Variables | Provides variables for use with operators and functions |
|
Edit with SQL Editor | Opens the SQL Editor dialog box. Provides object types and available objects to insert in the SQL statement |
|
SQL/XML Wizard | Opens the SQL/XML Wizard to build a SQL/XML query from a table or a view, and insert it in the SQL statement |
|
Insert SQL/XML Macro | Opens a dialog box to select a global element in an XML model open in the workspace with the SQL/XML extended model definition. Inserts a SQLXML macro referencing the selected element in the SQL statement |
For example:
| Copyright (C) 2007. Sybase Inc. All rights reserved. |
| |