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 LOADPLUS for DB2 13.1.

INTO TABLE statement for a DSNUTILB load

With the exception of the options described in this topic, LOADPLUS passes your INTO TABLE statement as is to DSNUTILB.

Any other options that are invalid for the IBM Db2 LOAD utility will cause a DSNUTILB error and might cause your load job to fail. With the exception of TRIM, your INTO statement’s syntax must be valid for both Db2 LOAD and LOADPLUS.

The following table describes INTO table exceptions for a DSNUTILB load:

INTO TABLE option

LOADPLUS response if you include this option

tableName REPLACE

Terminates

POS (instead of POSITION) on the field specification

Terminates

TRIM on the field specification

Translates to the Db2 STRIP specification as follows:

  • For CHAR or VARCHAR fields, passes as STRIP TRAILING ' '
  • For BINARY or VARBINARY fields, passes as STRIP

Related topic

Load-jobs-that-invoke-DSNUTILB

 

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