FROM [TABLE]

Use the FROM option to specify the table from which BMC AMI Unload should unload data records.


Related topics

Option descriptions—UNLD syntax
UNLD-syntax-diagrams
INTO 

FROM_syntax.png

You can specify a table name, view name, synonym, or alias.

The TABLE keyword is optional. You cannot specify the TABLE keyword when you specify MODE(DB2SQL).

AS [TABLE]

You can optionally specify the AS keyword with the FROM option to specify a table name to be used in the INTO clause of the generated LOAD statement. If you do not specify AS, BMC AMI Unload uses the table that you specified with the FROM option. You can specify only a table name with AS, and the keyword TABLE is optional.

Example

FROM oldTableName AS newTableName results in the following INTO clause of the generated LOAD statement:

INTO newTableName

However, FROM oldTableName results in the following INTO clause of the generated LOAD statement:

INTO oldTableName


 

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