how to unload different table data into different gdg files/
vsam files.
Answers were Sorted based on User's Feedback
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 .
Is This Answer Correct ? | 1 Yes | 0 No |
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.
Is This Answer Correct ? | 0 Yes | 1 No |
how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example
What is a db2 package?
How to execute stored procedure in db2 command editor?
How would you find out the total number of rows in a db2 table?
Why do we use cursor?
What are the four lockable units for DB2?
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
What is db2 look?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is collection in db2 bind?
i have a db2 variable how do u declare tht into working storage section ?
What is database reorganization?