What is rmode(24)

1199

What is db2 optimizer?

1316

What is ENQ?

1134

Can we give +2 instead of +1 while creating a new gdg file?

1030

Explain how to receive data passed through jcl parm parameter in a natural program? How data definition is defined in the program?

1187

My program has an array defined to have 10 items. Due to a bug, I find that even if the program access the 11th item in this array, the program does not abend. What is wrong with it?

1142

Explain how to differentiate call by context by comparing it to other calls?

1248

Explain host variables?

1050

What information does a psb contain?

1183

What is load replace in db2?

1050

a set statement is used to define commonly used symbolic across job steps or procedures. It initializes the previous values in the symbolic names. It has to be defined before the first use of the symbolic names in the jcl. State whether true or false?

1142

What is a run unit in idms?

919

Tell me can we update with histogram?

1237

What does the following code do? Ap wkur,=p5 where wkur is a label?

1152

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2119