Answer / srikant

yes

Answer / kingmanish

Yes ofcourse

Use any of the unload utilities

Answer / azharuddinsyed

Yes,

That is how we are unloading data from table to dataset.

Answer / mr. cooooool

Hi...............

Use the Following jcl to retrived the Db2 table data.

//SYSREC00 DD DSN=COOL.UNLOAD.SYSREC02,
// UNIT=SYSDA,SPACE=(32760,(1000,500)),DISP=(MOD,CATLG)
//SYSPUNCH DD DSN=COOL.UNLOAD.SYSPUNC1,
// UNIT=SYSDA,SPACE=(800,(15,15)),DISP=(MOD,CATLG)
//SYSIN DD *
SELECT * FROM SYSIBM.SYSTABLES WHERE OWNER = 'COOL123';
/*
//


THANKS

What is a data page?

1 Answers  

---

Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?

1 Answers  

---

When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?

3 Answers  

---

What is the FREE command?

1 Answers  

---

Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2  how will we do this.  We can create a single program and a single load for this program. 

2 Answers   RBS,

---

What is schema in db2?

0 Answers  

---

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

0 Answers  

---

what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx

2 Answers   IBM,

---

Is there any advantage to denormalizing DB2 tables?

1 Answers  

---

what is a collection?

2 Answers  

---

What is Call attach facility? How does it work?

1 Answers   Syntel,

---

what is datacom db?

2 Answers   CSC,

---