Hi,

I am trying to execute a DB2 Stored Procedure from MRE and here is the code

SET SQLENGINE=DB2
ENGINE DB2 SET DEFAULT_CONNECTION DBNAME

SQL DB2
EX SCHEMANAME.PROCNAME 2007,A,-1,-1,10101,10102,0,0,0,0,0;

TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS TEMP_DATA FORMAT ALPHA
END

TABLE FILE TEMP_DATA
PRINT *
END

But it is giving an error

Error occurred.
ERROR: ERROR_MR_FEX_NOT_FOUND Can't create item object based on provided item key SCHEMANAME.PROCNAME.

This is running fine on Data Server but giving error in MRE. Do we need to connect to DB2 using some other statements??

Thanks
CD

Hey CD,
If it works in Data Server then try using MRNOEDIT in the MRE.

-MRNOEDIT BEGIN
SET SQLENGINE=DB2
ENGINE DB2 SET DEFAULT_CONNECTION DBNAME

SQL DB2
EX SCHEMANAME.PROCNAME 2007,A,-1,-1,10101,10102,0,0,0,0,0;
-MRNOEDIT END

MRE is clearly treating the EX as a need to run a .fex, whereas when its a server proc the request is interpreted correctly to pop off a db2 stored procedure.

My only suggestion is to fiddle with the syntax, trying stuff such as

ENGINE DB2 EX SCHEMANAME.PROCNAME 2007,A,-1,-1,10101,10102,0,0,0,0,0;
END

or similar until you hit on the lucky combo that works on mre and edaserve.

Happy hunting!