UNLD SELECT

Use the SELECT option to tell BMC AMI Unload which columns to unload. You can specify only one SELECT option on your UNLD command.

Related topics

Option descriptions—UNLD syntax
UNLD-syntax-diagrams 

SELECT_syntax.png

For MODE(DB2SQL) and MODE(AUTO), the following requirements apply to SELECT:

  • You must specify a SELECT clause (the clause that includes SELECT, FROM, WHERE, and ORDER BY) and it must be at the end of your UNLD command.
  • You must specify the SELECT keyword and it must be the first keyword in the clause.

Use one of the following methods to specify the columns to unload:

* (asterisk)

Specifying * tells BMC AMI Unload to unload all columns from the specified table except the following columns:

  • Hidden columns
  • ROWID columns

This value is the default.

columnName

Specifying one or more column names tells BMC AMI Unload to unload the indicated columns from the specified table.

expression

Specifying an expression tells BMC AMI Unload to unload a subset of the columns from the specified table, or to unload the columns in an order that differs from original order of the specified table.

You can use expressions to refer to an operation on one or more columns.

For more information about using expressions in BMC AMI Utilities, see BMC-AMI-Utilities-SQL-language.

 

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