>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.