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
7162 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 to rename a table in DB2 ?

1097

Define db2.

1121

What is the difference between oracle and db2?

1120

What is null indicator in db2?

1122

What is the result of open cursor statement?

1087

What is a bind card?

1228

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2074

define clustering index.

1036

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1189

What is a db2 collection?

1058

what is utility for parm lib

2387

What is the maximum size of a char data type in db2?

1015

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1281

Which are the db2 tools to protect integrity of the database?

1129

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

1093