Using QMF

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

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


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]