how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none

8 Answers   Amdocs, HeadStrong,

---

How to check last update on table in db2?

0 Answers  

---

What is difference between alias and synonym in db2?

0 Answers  

---

what is the input to PLAN? what is the input to DBRM?

4 Answers  

---

What is the max length of sqlca?

0 Answers  

---

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,

---

Can we install 2 different versions of Db2 on same mainframe?

3 Answers  

---

What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers   Infosys,

---

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  

---

Explain the function of data manager.

0 Answers  

---

What is null indicator in cobol db2?

0 Answers  

---

how to resolve -805 . how to see dbrm and package not found

2 Answers   IBM,

---