Interested to Buy Any Domain ? << Click Here >> for more details...
how to unload different table data into different gdg files/
vsam files.
- 3 Answers
- 9966 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is cursor stability in db2?
How to connect to db2 database from windows command line?
What is copy pending status in db2?
what is the role of the cursor in db2?
List down the types of triggers in the db2 database?
How can you do the explain of a dynamic sql statement?
What is db2 and what is the use of db2 optimizer?
What are catalog tables in db2?
How to rename a table in DB2 ?
Is db2 free?
What is the use of db2?
Explain the function of data manager.
Highlight all the advantages that are attached to a package.
What are db2 tables?
