Page 1 of 1

Help on DB2 UNLOAD

PostPosted: Sun Aug 16, 2009 12:39 pm
by rajas.abcdefg
Hi,

Will it be possible to unload more than one table using jCL and the output to separate files respectively.

Thanks
Raj

Re: Help on DB2 UNLOAD

PostPosted: Mon Sep 21, 2009 11:17 am
by momi sabag
sure it is possible
you have 2 options:
using the sample program dsntiaul which you can provide with either table names or sql statements seperated by ;
these statements will be executed and data will be unloaded to ddnames SYSREC00, SYSREC01 etc...

you can also use the unload utility with the template statement