Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2014

    Unanswered: batch file in a Db2 stored procedure


    I have a batch file on windows, which need to executed in a db2 stored procedure. Can some one plz let me know the way.

    Db2 10.5 on windows

  2. #2
    Join Date
    Apr 2012
    Provided Answers: 27
    If you write your sproc in c or java then you can use features of the c-library or java to shell out and run what you like.

    SQL PL does not let you do this natively.

    If your batch file will run db2 commands, this kind of design is usually the worst design choice, the least elegant, the least maintainable and the most likely to cause run time issues that are expensive to resolve.

    Choose the right tool for the job, having first verified that the requirements are *sane*.

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