How do you retrieve the data from a nullable col

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

(Continued from previous question...)

How do you retrieve the data from a nullable column? –

Use null indicators. Syntax ... INTO :HOSTVAR:NULLIND

(Continued on next question...)

Other Job Interview Questions

• What is ACQUIRE/RELEASE in BIND?
• When do you use the IMAGECOPY? – –
• What is sqlcode -811?
• What does it mean if the null indicator has -1, 0, -2? –
• What is sqlcode -811?
• What is COPY PENDING status?
• What are the 4 environments which can access DB2 ?
• How do I create a table MANAGER ( EMP#, MANAGER) where MANAGER is a foreign key which references to EMP# in the same table? Give the exact DDL.
• What is the picture clause of the null indicator variable? –
• What is dynamic SQL? ––
• More...