What does it mean if the null indicator has -1,

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

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

(Continued on next question...)

Other Job Interview Questions

• What is the significance of DB2 free space and what parameters control it?
• When will you chose to run RUNSTATS?
• What is an alias and how does it differ from a synonym?
• What is Declaration Generator ( DCLGEN )?
• When one binds a PACKAGE of a plan what package information is stored and where it is stored?
• What is the difference between TYPE 1 index and TYPE 2 index?
• What is the difference between join and union ?
• What is the function of the Data Manager?
• What is DCLGEN?
• When can you be sure that a quary will return onlyl one row ?
• More...