Default language.

GLOBAL Operands


This control statement defines the global defaults for the DPSUMLD program.

One GLOBAL control statement is required as the first statement. Below table describes the operands for the GLOBAL control statement.

Operand

Description

INVFIELD=IGNORE|ABORT

Defines if processing should continue if an invalid field in the Db2 table is encountered

The default is ABORT, which indicates that the processing for the request should abort.

LOG=YES|NO

Defines the default logging control for all load requests that follow

The default is NO. This statement can occur multiple times. It resets the default value for all statements that follow.

NOCOPYPEND=YES|NO

Indicates whether NOCOPYPEND is specified for all subsequent LOAD requests, if LOG=NO is specified or is in effect from a prior GLOBAL statement

The default is NO, which means that the NOCOPYPEND keyword will not be added to the generated statement if LOG=NO is in effect. This statement can occur multiple times. It resets the value for all statements that follow.

PLAN=name of the plan

Name of the plan for the load interface routine

This operand is provided in the case where you want to change the default name of the plan. If not provided, the default plan as defined in the installation instructions is used.

SSID=ssid of target Db2 system

Subsystem name of the Db2 system which owns the tables to be loaded, summarized or purged

This statement can occur multiple times. It resets the default value for all statements that follow. This required field has no default.

SHRLEVEL=NONE|CHANGE

Defines the SHRLEVEL parameter for all of the load requests that follow

The default is NONE. This statement can be specified multiple times. It resets the default value for all statements that follow.

 

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