76) How do you retrieve the data from a nullable column? –
Use null indicators. Syntax ... INTO :HOSTVAR:NULLIND
77) What is the picture clause of the null indicator variable? –
S9(4) COMP.
78) What does it mean if the null indicator has -1, 0, -2? –
-1 : the field is null
0 : the field is not null
-2 : the field value is truncated
79) How do you insert a record with a nullable column?
To insert a NULL, move -1 to the null indicator
To insert a valid value, move 0 to the null indicator
80) What is RUNSTATS? –
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.
|