Default language.

Limited supportBMC 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.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Load for Db2 13.1.

INTO TABLE options

Use the INTO TABLE clause to tell 

BMC AMI Load

 where to load data and which data to load.

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

Related topics

Basic-options

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


 

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