Answer / lu

Oh man, you have to check SQLCODE for each SQL
stament...SQLCODE = 0 it's good.... SQLCODE not = 0 it's
bad.
OR you look in SQLCA... verify this SQLERRD

i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.

0 Answers  

---

How to fetch the uncommited data from table ?

1 Answers   JPMorgan Chase,

---

what is load and unload in db2

1 Answers   IBM,

---

What is a Foreign Key?

0 Answers   Tavant Technologies, Zensar,

---

Is the primary key a clustered index?

0 Answers  

---

---

What is clone table?

0 Answers  

---

can any one give the list of some important sql abend codes which r frequently asked in interviews?

2 Answers  

---

how will you retrieve first record in table

1 Answers   UST,

---

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

0 Answers  

---

could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..

5 Answers  

---

I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.

5 Answers  

---

What is -904 sql code? How to resolve it?

3 Answers  

---