The NULLS and NONULLS Commands

Describes the NULLS and NONULLS commands.
The NULLS command governs whether indicator variables appear next to their associated host main variables on the display. Indicator variables allow NULL values to be displayed, inserted or updated. The following panel illustrates the display which results from issuing the NULLS ON command. Each SQL query result column which can assume a value of NULL appears paired with its corresponding indicator dialog variable (IDV).
SQL Query Result 'DATATYPE' ------------------------------------- ROW 1 OF 14 Command ===> Scroll ===> HALF INTEGER IDV001 SMALLINT IDV002 DEC55 IDV003 CHAR5 1(I) 1(S) 2(S) 2(S) 3(P) 3(S) 4(C) 57 0 57 0 0.57000 0 C57 58 0 58 0 0.58000 0 C58 59 0 59 0 0.59000 0 C59 63 0 63 0 0.63000 0 C63 78 0 78 0 0.78000 0 C78 82 0 82 0 0.82000 0 C82 82 0 82 0 0.82000 0 C82 82 0 82 0 0.82000 0 C82 82 0 82 0 0.82000 0 C82 87 0 87 0 0.87000 0 C87 93 0 93 0 0.93000 0 C93 93 0 93 0 0.93000 0 C93 100 0 100 0 0.10000 0 C100 100 0 100 0 0.10000 0 C100
The next panel illustrates the display after issuing a NULLS OFF command.
SQL Query Result 'DATATYPE' --------------------------------------- ROW 1 OF 14 Command ===> Scroll ===> HALF INTEGER SMALLINT DEC55 CHAR5 MDV005 DATE TIME 1(I) 2(S) 3(P) 4(C) 5(V) 6(DATE) 7(TIME) 57 57 0.57000 C57 VC57 2003-01-21 16.42.23 58 58 0.58000 C58 VC58 2003-01-21 16.42.23 59 59 0.59000 C59 VC59 2003-01-21 16.42.23 63 63 0.63000 C63 VC63 2003-01-21 16.42.23 78 78 0.78000 C78 VC78 2003-01-21 16.42.23 82 82 0.82000 C82 VC82 2003-01-21 16.42.23 82 82 0.82000 C82 VC82 2003-11-23 13.24.23 82 82 0.82000 C82 VC82 2003-01-21 16.42.23 82 82 0.82000 C82 VC82 2003-11-23 13.24.23 87 87 0.87000 C87 VC87 2003-01-21 16.42.23 93 93 0.93000 C93 VC93 2003-01-21 16.42.23 93 93 0.93000 C93 VC93 2003-10-18 11.16.45 100 100 0.10000 C100 VC100 2003-10-18 11.16.45 100 100 0.10000 C100 - 2003-10-18 11.16.45