Redefining the column default and null indicators

You can change the column default and null indicators by changing the DSQCP_TEDFLT and DSQCP_TENULL global variables.

Procedure

You can redefine the column default and null indicators from the command line by using the SET GLOBAL command. For example, to change the column default indicator to ? and the null indicator to #, enter the following at the command line:

SET GLOBAL (DSQCP_TEDFLT=?, DSQCP_TENULL=#)

Once you have issued this command, the Table Editor session illustrated in the following figure would reflect values similar to those shown in the following figure:

Figure 1. The Table Editor ADD panel with new values for the column default and null indicators

 ADD                  USERID.PERS
 
                                                                   1 to 7 of 7
 ACCTNO. . . . . . . . (_#______)
 COMPANY . . . . . . . (_?_________________________)
 STREET. . . . . . . . (_#____________________)
 CITY. . . . . . . . . (_#____________________)
 STATE . . . . . . . . (_#__)
 ZIP . . . . . . . . . (_#______)
 DATE  . . . . . . . . (_?______)
 NOTES . . . . . . . . (_?_________________________________________________>