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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between bind and rebind in db2?

858


What is host variable in db2 cobol?

608


What is dbrm? What it contains?

682


What is the difference between nvl and coalesce?

604


Describe major components of db2?

642






What is meant by explain?

662


What is coalesce in db2?

682


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

716


i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2049


Explain in brief how does db2 determine what lock-size to use?

599


What is the maximum number of columns in a db2 table?

727


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

646


Can one database have multiple instances?

583


How do I import data from excel to db2?

617


Explain various types of locks in db2?

693