What is the syntax for FETCH in DB2 ?

7

Which command is used to connect to a database in DB2 ? Give the Syntax.

5

Mention the location where the output received from explain statement is stored.

2

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

7469

What is the difference between dbm cfg and db cfg file in db2 ?

11

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1039

How to resolve deadlock issue

10933

Define sqlca.

5

Is it possible to create an Instance in DB2 using DB2 Control Center ?

12

can we view the access paths created by dbrm ? how ? thx

4795

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

1262

Explain the function of data manager.

6

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

1556

Explain about cursor stability?

4

What r the comman abends in db2, jcl and cobol???????

1192