How do you check for a null value in a db2 column?

Question Posted / guest

2 Answers
11873 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How do you check for a null value in a db2 column?..

Answer / guest

You use a null indicator on the colunm and if the null
indicator = -1 then the column has a null value.

Is This Answer Correct ?

32 Yes

0 No

How do you check for a null value in a db2 column?..

Answer / angoca

By querying the catalog
select nulls
from syscat.columns
where tabschema like 'XX%'
and tabname = 'YY'
and colname = 'ZZ'"

Or with the describe command
db2 describe table ZZ.YY

Is This Answer Correct ?

1 Yes

1 No

Post New Answer

More DB2 Interview Questions

How to resolve -504 sql code in DB2?

2 Answers Cap Gemini,

What is buffer pool in the db2 database?

0 Answers

What is the error code -803 ?

3 Answers

Mention some fields that are a part of sqlca.

0 Answers

What information is held in SYSIBM.SYSCOPY?

1 Answers

What is a DBRM, PLAN ?

3 Answers

how to resolve -811 error. give clear explination

4 Answers IBM,

where will u check for sqlcode ?

2 Answers TCS,

This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

1 Answers TCS,

What is the difference between oracle and db2?

0 Answers

What is the reason behind not using select * in embedded sql programs?

0 Answers

For more DB2 Interview Questions Click Here