Global variables associated with the Table Editor

DSQCP global variables are associated with the operations of the Table Editor. All of these global variables can be modified by the SET GLOBAL command.

The following table shows global variables that are associated with the operations of the Table Editor. All of these global variables can be modified by the SET GLOBAL command.

If the CONFIRM option of the EDIT TABLE command is NO, the Table Editor suppresses the display of all confirmation panels. If the CONFIRM option is YES, the Table Editor determines which categories of confirmation are enabled by checking the values of the global variables that are shown in this table.

The Table Editor defaults depend on the SAVE keyword from the EDIT TABLE command:

  • When SAVE=IMMEDIATE, the default for each category is to enable.
  • When SAVE=END, the default for the DELETE, MODIFY, and END/CANCEL categories is to enable; the default for the ADD and CHANGE categories is to disable.
Table 1. Global variables associated with the Table Editor
Callable interface variable name Command interface variable name Length Description
DSQCP_RMV_BLANKS None 01 Retains or removes trailing blanks of VARCHAR columns. This variable affects only the Table Editor in Change mode. Values can be:
0
Trailing blanks of VARCHAR columns are not removed.
1
Trailing blanks of VARCHAR columns are removed. This value is the default.
DSQCP_TEADD None 01 Displays a confirmation panel after an ADD subcommand; values can be:
0
Panel is disabled.
1
Panel is enabled.
2
Panel is enabled or disabled depending on the Table Editor defaults. This value is the default.
DSQCP_TECHG None 01 Displays a confirmation panel after a CHANGE subcommand; values can be:
0
Panel is disabled.
1
Panel is enabled.
2
Panel is enabled or disabled depending on the Table Editor defaults. This value is the default.
DSQCP_TEDEL None 01 Displays a confirmation panel after a DELETE subcommand; values can be:
0
Panel is disabled.
1
Panel is enabled.
2
Panel is enabled or disabled depending on the Table Editor defaults. This value is the default.
DSQCP_TEDFLT None 01 The reserved character used to indicate the default value for a column in the Table Editor; initially set to a plus sign (+) character.
DSQCP_TEDFLT_DBCS None 04 The reserved DBCS character used to indicate the default value for a graphic string column in the Table Editor.

The value must be a 4-byte mixed string, composed of one DBCS character, preceded by the shift-out character, and followed by the shift-in character. It is initially set to a DBCS plus sign (+) character. This global variable is used only in a DBCS environment.
DSQCP_TEEND None 01 Displays a confirmation panel when you issue an END subcommand or a CANCEL subcommand to terminate a Table Editor subsession.
The panel can be displayed in several variations:
  • If END or CANCEL is issued
  • If modifications are made to the database
  • If the screen contains modified data when END or CANCEL is issued
Values can be:
0
Panel is disabled.
1
Panel is enabled.
2
Panel is enabled or disabled depending on the Table Editor defaults. This value is the default.
DSQCP_TEMOD None 01 Displays a confirmation panel when displayed data is modified and a PREVIOUS, CLEAR, SHOW CHANGE, SHOW SEARCH, REFRESH, or NEXT subcommand is issued. The resulting panel includes the name of the subcommand as part of the panel text. Values can be:
0
Panel is disabled.
1
Panel is enabled.
2
Panel is enabled or disabled depending on the Table Editor defaults.
DSQCP_TENULL None 01 The reserved character used to indicate the null value for a column in the Table Editor; initially set to a hyphen (-) character.
DSQCP_TENULL_DBCS None 04 The reserved DBCS character used to indicate the null value for a graphic-string column in the Table Editor. The character is also used to indicate ignore in the context of search criteria.

The value must be a 4-byte mixed string composed of one DBCS character, preceded by the shift-out character, and followed by the shift-in character. It is initially set to a DBCS hyphen (-) character. This global variable is used only in a DBCS environment.