Interested to Buy Any Domain ? << Click Here >> for more details...
how to unload different table data into different gdg files/
vsam files.
- 3 Answers
- 10198 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
What is the difference between using bind () and rebind () methods of naming class?
What's The Error Code For Unique Index Voilation?
How can deadlocks be resolved?
Why do chiropractors use drop table?
What is dbrm? What it contains?
What is table space in db2?
What is the difference between nvl and coalesce?
Can one database have multiple instances?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What are the benefits of using the db2 database?
Why db2 is called db2?
What type of database is db2?
How can we retrieve the total number of records in RPG & CLLE?
What is commit in db2?
What is the connection string to connect to the DB2 Database ?
