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

is it possible to get -811 error when you use cursors. why?

2 Answers   IBM,

---

Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers   HSBC,

---

What is lock escalation in db2?

0 Answers  

---

I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..

5 Answers   CTS,

---

What are some characteristics of columns that benefit from indexes?

1 Answers  

---

What is the maximum size of varchar data type in db2?

0 Answers  

---

how can u understand the end of the table ?

1 Answers   TCS,

---

Explain the function of data manager.

0 Answers  

---

What is the role of data manager in the db2 database?

0 Answers  

---

Why do we use cursor?

0 Answers  

---

What is the error code -803 ?

3 Answers  

---

what is difference between random and sequence file access

1 Answers   Syntel,

---