Answer / shaan

Be sure to include sqlca in working storage section.
Then you can check sqlcode from the copybook variable SQLCODE.

Answer / guru

If you dont include SQLCA, Define SQLCODE and SQLSTATE as
working storage variables and This will suffice

how many bytes timestamp token occupies?

6 Answers   Boss Global, Cap Gemini, TCS,

---

Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?

3 Answers  

---

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

1 Answers   Cap Gemini,

---

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

2 Answers  

---

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---

How do I create a view in db2?

0 Answers  

---

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers   CTS,

---

How do you retrieve the data from a nullable column?

2 Answers  

---

For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?

1 Answers   BNP Paribas,

---

What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 Answers  

---

i want to maintain uniqueness on pdf without make lf??????????

0 Answers  

---

Where besides the DB2 catalog is database object information stored by DB2?

1 Answers  

---