Answer / harsha

Use DSNTIAUL utility

Answer / raghu

by using DSNUTLIB utility .
in dsnutlib of unload utility we first unload table data into file ,from that file we can load data into gdg/vsam files by idcams .

Answer / anilkumar

do you need to unload more than 2 tables in a single unload step
Then need to specify sysrec01,syrec02 in jcl step
and in sysin
specify like this
select * from tab1 with ur; ---- data extrcat into sysrec01
select *from tab2 with ur; ----- data extract into sysrec02

this sort of jcl's we used in our project
but the same thing is not work for if you used union and
union all in the queries.

How do I optimize a query in db2?

0 Answers  

---

explain about index with examples

2 Answers   Syntel,

---

What is difference between rollback and commit?

0 Answers  

---

What is the physical storage length of timestamp data type?

0 Answers  

---

What is db2 connect?

0 Answers  

---

How would the varchar column remarks defined?

0 Answers  

---

Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,

---

For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?

1 Answers   BNP Paribas,

---

What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

4 Answers   Accenture,

---

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

0 Answers  

---

i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?

8 Answers   Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,

---

What is null value in db2?

0 Answers  

---