INTO TABLE options

Use the INTO TABLE clause to tell BMC AMI Load where to load data and which data to load.

Related topics

Basic-options

Using-IGNOREFIELDS-with-the-VALUE-option-to-convert-data

image2023-1-19_12-13-12.png

BMC AMI Load enables you to load multiple tables in the same table space by using a single load statement that supplies multiple INTO TABLE clauses. Each INTO TABLE clause can reference a different column specification clause and a different WHERE clause

Follow INTO TABLE with the name of the table to load. Optionally, you can fully qualify the table name with the creator ID. BMC AMI Load updates all indexes defined on the table.

Use the following additional options with your INTO TABLE clause:

field selection syntax

field_selection.png

 

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