SELECT Name FROM S-Tabl WHERE Status IS NULL;

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

Question Posted / adarshag

2 Answers
7219 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / adarshag

SELECT Name
FROM S-Tabl
WHERE Status IS NULL;

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I import a csv file into db2?

1037

What are host variables in db2?

1120

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

1160

What is a db2 tablespace?

1115

How does cobol compile db2 program?

1124

What is a dbrm in db2?

1075

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2380

Define db2.

1164

What is ibm db2 connect?

1049

How and when does the db2 enforces the unique key?

1139

What does reorg do in db2?

1072

define clustering index.

1065

How can deadlocks be resolved?

985

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1211

Explain about rct.

1128