Use null indicators. Syntax ... INTO :HOSTVAR:NULLIND
-1 : the field is null
0 : the field is not null
-2 : the field value is truncated
To insert a NULL, move -1 to the null indicator
To insert a valid value, move 0 to the null indicator.
A DB2 utility used to collect statistics about the data values in tables which can be used by the optimizer to decide the access path. It also collects statistics used for space management. These statistics are stored in DB2 catalog tables.
After a load, or after mass updates, inserts, deletes, or after REORG.