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.

Removing all data from a table space


The following example illustrates how to use 

BMC AMI Load

 remove all data from a table space.

Specifying REPLACE with an input data set of DD DUMMY empties the table space and loads no data.

Important

For the assumptions made in this example, see Assumptions made in the syntax examples.

//SYSREC    DD DUMMY
//SYSIN     DD *
  LOAD DATA REPLACE INDDN SYSREC
  INTO TABLE NGT.TABLE1
    (fieldSpecification)



 

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