how to create load card for a table. there should some JCL I used it long back. But for got that one can any one help me by posting that JCL ?

I need to load table which has many columns it is difficult to create a load card manualy.

Any help is greatly appriciated...

Sree

You can use the UNLOAD utility to generate the load cards for your table in question. In the UNLOAD utility provide a data set name for SYSPUNCH and in the sql for table unload provide a where clause which should not return any data, e.g.

select * from employee where 1=2


Refer to the this link:

http://www-3.ibm.com/software/data/d...0/v7books.html

and look into the book titled: Utility Guide and Reference for more information.


dollar