Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2012
    Posts
    5

    Unanswered: Sample JCL that runs the DDL statements in bat

    Hi, Does anyone have a sample JCL that runs the DDL statements in batch?
    I am specifically interested in creating a schema in batch mode using JCL. Are there any specific DB2 plan names that I have to use to do so?

    Thanks for your help.

    Sbsai

  2. #2
    Join Date
    Apr 2007
    Location
    Chicago
    Posts
    68
    Read about the DSNTEP2 sample program in the fine IBM manuals.
    IBM Information Management Software for z/OS Solutions Information Center

    DB2 Version 9.1 for z/OS > Programming for DB2 > Application programming and SQL > DB2 sample applications and data > DB2 sample applications > DSNTEP2 and DSNTEP4

  3. #3
    Join Date
    Nov 2012
    Posts
    5
    Thanks so much for the help.

    Regards,

    sbsai

  4. #4
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    Once you are familiar with the "generic" information in the manuals, you will need to work with your database or system support people to learn the specifics for your system.

    The manuals will provide the rules, but not anything that is site-specific (and there usually is much).

Posting Permissions

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