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

Question Posted / guest

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

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

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

0 Answers IBM,

What is subquery ?

6 Answers

What is an alias and how does it differ from a synonym?

3 Answers

What is load utility in db2?

0 Answers

where will u check for sqlcode ?

2 Answers TCS,

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

1 Answers CTS,

Which isolation level provides maximum concurrency?