how we will do null data selection in cobol-db2 program

Question Posted / guest

Answers were Sorted based on User's Feedback

how we will do null data selection in cobol-db2 program..

Answer / adarshag

SELECT Name
FROM S-Tabl
WHERE Status IS NULL;

Is This Answer Correct ?

3 Yes

0 No

how we will do null data selection in cobol-db2 program..

Answer / shobha

by using null indicator

Is This Answer Correct ?

2 Yes

0 No

More DB2 Interview Questions

What are the four lockable units for DB2?

max number of columns in a db2 table?

What are the advantages of using a PACKAGE?

What is the use of reorg in db2?

Where are plans stored?

Differentiate between cs and rr isolation levels? Where do you specify them?

When do you use the IMAGECOPY?

Can you access the DB2 Directory table using SQL?

Which component is responsible for processing sql statements and selecting access paths?

How many Buffer pools are there in DB2 and what are they?

What does the REORG Utility do?

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

For more DB2 Interview Questions Click Here