This page allows you to specify the information required to construct a SQL Expression script. This SQL expression is the same as is used in download_cursor scripts. It is partly generated for you. For an example of how to use this option, see the example below.
This page has the following components:
Tables to add to the download cursor's FROM clause Type the table name(s) if your download_cursor requires a join to other tables. If the join requires multiple tables, separate them with commas. See Writing download_cursor scripts.
SQL expression to use in the download cursor's WHERE clause Type a SQL expression to be used in the download cursor WHERE clause. You do not have to write a complete download_cursor. You only need to add extra information to identify the join and other restrictions on the download subset. See Writing download_cursor scripts.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|