Script, Designer

In the Script view of the IBM^® Script Designer, you can specify any of the following scripts:

The DDL script for an IBM database table or views
The SQL statements for an SQL procedure or function
The SQL and SPL statements for an SPL procedure or function

: You can review the SQL or SPL statements for an SQL or SPL procedure or function, or view the DDL script for an IBM database table or view.
You can also specify and run any combination of SQL and SPL statements and DDL scripts in this view. For example you can specify SQL statements for an SQL procedure, then specify a SELECT statement, and then specify a DDL script to create a table. Use the statement separator (@ or ;) to separate multiple scripts and statements.

In addition to SQL statements, you can also specify XQuery and SQLXML scripts.

You can then run the single or multiple statements and scripts. If any of the statements contains a result set, the results are shown in the Result Data section.

Script

In this section, you specify the script, or review the contents of the script and update the script as needed.

For more information on scripts, refer to your DB2^® documentation. You can also find the information in DB2 SQL documentation that is available through The SQL Reference for Cross-Platform Development Web page on developerWorks.

To use the Visual Studio Query Builder to create the script, right-click in this editor, and then select Query Builder on the shortcut menu. When you close the Query Builder, the SQL code in the Query Builder is automatically pasted in this editor at the insertion point.

Result Data

This section shows the results of running a script that produces a result set.

See Also