Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009

    Unanswered: call load utility from zos stored procedure

    I'm running DB2 9.1.5 for ZOS (soon to be upgraded to v10) and I need to be able to run the LOAD utility from a stored procedure. I really haven't foundanything on how I can do this. Most items reference LUW and the ADMIN_CMD; which is not available for the Z.

    I have also seen a reference to DSNUTILU and a sample C program, but I have not found any examples using standard SQL PL and Stored Procedures.

    Does anyone have any idea if I do what I need to do on the Z? Can you point me to sample code?

    Thank you.


  2. #2
    Join Date
    Jun 2002
    Here is a link to dsnutils stored procedure which enables the use SQL CALL statement to execute DB2 utilities from a DB2 application:

    IBM Information Management Software for z/OS Solutions Information Center

Tags for this Thread

Posting Permissions

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