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.

Related topic

Load-jobs-that-invoke-DSNUTILB

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

 

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