Answer / kiran

by giving save command in commandline option

Where is the output of EXPLAIN stored?

2 Answers  

---

The only place of VSAM KSDS in DB2 is?

2 Answers   IBM,

---

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

0 Answers  

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,

---

How to get the ddl of a table in db2?

0 Answers  

---

---

How can you split a table in to exactly half?

7 Answers   HSBC,

---

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 we drop column from a table

7 Answers   INDUS,

---

What is DB2 (IBM Database 2)?

3 Answers  

---

What techniques are used to retrieve data from more than one table in a single SQL statement?

2 Answers  

---

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

2 Answers   iGate,

---

What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 Answers  

---