>I am using DB2 Connect to access DB2 and have had great performance. I use SQLCONNECT() and then SQLEXEC() with standard parameters.
>
>Now I have a stored procedure on DB2 and I cannot figure out how to fire it off. Can someone please give me a clue? The procedure has two input variables and two output variables.
With the Client Access connector I use the syntax:
gh=sqlconn(AS4_dsn, AS4_uid, AS4_password)
=sqlexec(gh,[CALL YourStoredProcedureName 'Parm1Value ','Parm2')],'cursorname')
Results are returned into a cursor.
I don't know if this will work with the DB2 driver.
Michael McLain