Hi All,

UDB v8 on AIX

I have a c++ application that calls an external stored procedure, the problem is that the stored procedure is causing the work I'm doing (before the stored procedure call) to commit, the stored procedures are db2dari procedures and defined as:

extern "C" SQL_API_RC SQL_API_FN MqEqStatus( void *reserved1, void *reserved2, struct sqlda *wml_sqlda, struct sqlca *wml_ca )

I checked the prep and bind but nothing look like it will help, i checked in the procedures themselves and there aren't any commit statements, so there must be an automatic commit when the procedure returns.

any ideas would be appreciated!!

thanks....bob