Could anyone clearly explain the diference between sub query and correlated sub query?

which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

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.

database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please

WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?

IBM,

what is cursor stability?

IBM,

how do we solve soc 7 and soc4 ?

Tech Mahindra,

Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......

how to check the table is empty or not?

IBM,

what is the difference between where clause and having clause

IBM,

In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?

TCS,

what is utility for parm lib

IBM,

what is parm utility

IBM,

what is load and unload in db2

IBM,

how to copy the host variables from ps file into cobol program other than include statement

Syntel,