I want to unload some data from a table into a file.
Lets say a table has some 100000 records and i want to unload from
some 10000th record. Is there any JCL for this.....
There is any option in DB2 to take extract...but if there are many records in the table we cannot take extract from the option FILE-AID , 3.7.
I want the JCL for this unload.
Thanks for ur suggestions and valuable time.
the parm system is for your db2 dsn.
uid is for the report. _ can be anything
sysrec contains the db2 data
syspunch contains the generated load parm after you have performed an unload. modifiy this to load a different table
sysin contains the 'WHEN' clause. you will need to know the tablespace name for your table.