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

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

Post New Answer

More DB2 Interview Questions

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 Answers  


What is a host variable?

3 Answers  


Mention the various locks that are available in db2.

0 Answers  


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?

0 Answers   TATA,


what is a corelated subquerry?

0 Answers   IBM,






Is it possible using max on a char column?

0 Answers  


What is the role of schema in the db2 database?

0 Answers  


What are the levels of isolation available with DB2V4

2 Answers   IBM,


What is the latest version of ibm db2?

0 Answers  


cursor with hold explain ?

1 Answers   Verizon,


What is isolation level in db2?

0 Answers  


What's The Percentage Free Space ?

0 Answers   IBM,


Categories