Answer / azharuddinsyed

ALTER TABLENAME
ADD COLUMN <COLUMN NAME> <DATATYPE>(<SIZE>)

what is the difference between declaring the cursor in WS section and Procedure division?

1 Answers   HCL,

---

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

0 Answers   Infosys,

---

What should be specified along with a cursor in order to continue updating process after commit?

1 Answers   IBM,

---

While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

4 Answers   CTS, IBM,

---

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

1 Answers   TCS,

---

What is a DB2 plan?

8 Answers  

---

How to create backup table in db2?

0 Answers  

---

how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?

1 Answers   Hewitt,

---

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers  

---

Can i insert bulk records into a db2 table using qmf of spufi only............!!!

2 Answers  

---

Is it possible to precompile if db2 goes down?

4 Answers   Target,

---

What is isolation level in db2?

0 Answers  

---