DB2 graphic  QMF Version 8

Redefining the column default and null indicators

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 Figure 173 would look like this:

Figure 175. 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 . . . . . . . . (_?_________________________________________________>


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004