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
7118 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

What's The Percentage Free Space ?

1219

Explain about cursor stability?

1040

Explain about rct.

1083

How do I optimize a query in db2?

1093

How to create db2 table in mainframe?

1148

What is database reorganization?

1114

How can you count the number of rows from a table tab?

1083

How many types of page locks can be held in db2?

1033

Why select is not preferred in embedded sql programs?

1290

Define buffer pool.

1041

How does coalesce work?

1008

What are union and union all?

976

What is the physical storage length of the data types date, time, and timestamp?

1082

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2228

Mention the downsides of page level lock.

1159