REUSE
If you specify REUSE and REDEFINE YES, LOADPLUS uses the last keyword that it finds in the command string. If you specify REUSE, LOADPLUS functions differently depending on the type of load job that you are running:
- When invoking DSNUTILB:
- For an SQLAPPLY load, LOADPLUS ignores this option.
- Otherwise, LOADPLUS passes this option to the Db2 LOAD utility for processing.
- For all other load jobs, LOADPLUS functions as if you specified REDEFINE NO.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*