Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    US
    Posts
    1

    Unanswered: how to create load card for a table.

    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

  2. #2
    Join Date
    Sep 2002
    Posts
    456

    Re: how to create load card for a table.

    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


    Originally posted by daggumatis
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •