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



What does it mean if the null indicator has -1, 0, -2?..

Answer / islam

-1 indicates that the field contain a NULL value
0 indicates that the field contain valid value
-2 indicates that the field the field contain junk value
due to data conversion error

Is This Answer Correct ?    19 Yes 3 No

Post New Answer

More DB2 Interview Questions

Can we declare DB2 HOST variable in COBOL COPY book?

2 Answers  


What is access path in db2?

0 Answers  


What is a collection in db2?

0 Answers  


What is the syntax of SELECT statement when embedded in a COBOL program?

2 Answers  


What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?

2 Answers  






Can you access the DB2 Directory table using SQL?

3 Answers  


What is a buffer in memory?

0 Answers  


assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,


before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

0 Answers   IBM,


what is Runstats? Whem will u choose to runatats?

1 Answers   Danske,


What are leaf pages?

3 Answers  


Plan has the optimized access path in it. But is that optimized access path is attained or known

1 Answers   IBM,


Categories