Its depend how the Stored Procedure is written on DB2, is this an RPG/Cobol Stored Procedure...

If its written property... all you need to do is...

<cfquery name="".....>
call library.procedureName(param1, param2, param3);
</cfquery>

Joe Eugene
  ----- Original Message -----
  From: [EMAIL PROTECTED] [EMAIL PROTECTED]
  To: CF-Talk
  Sent: Wednesday, October 15, 2003 4:08 PM
  Subject: DB2 and Stored Procedures

  Does anyone have any samples of a stored procedure call to DB2 on the AS400 with parameters?  I seem to be getting the procedure to run, however, I'm not getting any results, therefore I think it's not taking my parameters.  We can get the procedure to work using the same parameters inside of an RPG program.

  Thanks for any help,
  Daron Smith
  PSEA


[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to