User Profile

Collapse

Profile Sidebar

Collapse
da123
da123
Last Activity: Oct 11 '07, 05:46 PM
Joined: Oct 5 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • da123
    replied to DOS Batch file to run a Stored Procedure
    in DB2
    The environment is DB2 UDB 8.2 and a client is installed on the local m/c
    See more | Go to post

      Leave a comment:

    • da123
      started a topic DOS Batch file to run a Stored Procedure
      in DB2

      DOS Batch file to run a Stored Procedure

      I have a clean up proceudre that needs to be scheduled on weekly basis. My company owns a schedular that can kick off MS DOS Batch file for me.

      If only I can execute the stored procedure from a .BAT file my work will be done.

      I tried I created a simple batch file which uses DB2 CLP to execute the stored procedure, but I'm getting this error "SQL1024N A database connection does not exist. SQLSTATE=08003"...
      See more | Go to post
      No activity results to display
      Show More
      Working...