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

Question Posted / guest

1 Answers
13560 Views
I also Faced
E-Mail Answers

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

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

0 Answers

What is a synonym? How is it used?

2 Answers

how to fetch first 100 rows in db2

2 Answers IBM,

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

0 Answers

What is db2 bind process?

0 Answers

Mention the definition of cobol in varchar field.

0 Answers

List out the buffer pools in db2

0 Answers

Describe what a storage group(STOGROUP) is?

2 Answers

How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

6 Answers Wipro,

What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?

2 Answers

What is a host variable?

3 Answers

can any one expalin check point with an example?

1 Answers

For more DB2 Interview Questions Click Here