SQL Details Dialog Box

5250

To access

You can use this dialog box to customize the SQL statements used on the file being transferred from an AS/400 host to your PC. Under each tab in the dialog box, you can configure options in the following three regions.

Clause

Provides a place for you to build SQL statements. You can insert operators by clicking one of the options in the SQL Operations list. You can also type all operators directly.

SQL Operations

Provides a list of available SQL operations. The contents of the list depend on the tab of the dialog box you click.

Fields

Displays the properties of any field in a database or any column in a table. You can double-click any field or column to insert it into the Select Clause box. The properties include the following:

Field—Shows the name of the field or column.

Type—Shows the type of the field or column.

Length—Shows the length (in bytes) of the field or column.

Digit—Shows the number of digits to the left of the decimal point, if the field or column is zoned.

Decimal—Shows the number of digits to the right of the decimal point, if the field or column is zoned.

Null Capable—Shows whether the field can contain a NULL value.

Related Topics

Transferring Files to and from AS/400