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 does the sqlcode of -818 pertain to? –
• What is CHECK PENDING ?
• Name some fields from SQLCA.
• What is a synonym? How is it used?
• What is sqlcode -811?
• How do we unload the DB2 tables using JCL?
• Give some example of statistics collected during RUNSTATS?
• What is index cardinality? –
• What is 'LIKE' used for in WHERE clause? What are the wildcard characters? –
• How do you leave the cursor open after issuing a COMMIT? ( for DB2 2.3 or above only )
• More...