Skip to Content
Information
Space announcement: BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.

SQL Entry Panel

The SQL Entry Panel appears when you specify S in the Criteria Display Format field on the Table Copy Selection screen.

This screen prompts you for a dataset name in which you have previously saved a SELECT statement.

SQL Entry Panel

image2021-3-10_16-51-39.png

Specify Input Dataset Name Area

Criteria Dataset Name

Name of the data set in which the SQL query resides or will reside. Prefilled with the Copy Criteria dataset name.

Member

Specify the desired member.

Specify Processing Options Area

Maximum Rows to Select

Maximum number of rows to be returned for the SELECT. (An asterisk in this field indicates that all rows should be returned. Only the first SELECT command in a data set is executed.

Edit SQL

Specify whether you want to edit the SQL before it is executed.

If the value of the Edit SQL field is YES, pressing Enter displays the Edit SQL Selection screen. If the value of the Edit SQL field is NO, pressing Enter executes the SQL statement and displays the Edit mode screen.

Related topics

Table-Copy-Selection

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC Compuware File-AID for Db2 21.01