hi,

I compiled DB2 stored procedure in PL/I 3.7 but I'ts abended on sql code which says that the SP is not proper.
The DB2 version is 8.

Do you know which parameters I need to add specially to PL/I compile job like NCAL?

Thanks in advance,
Jhon

Could you please share the error info here to see what went wrong?

Hi,

the error message that shown on log:
"DB2MSTR DSNX906I @ DSNX9CAC PROCEDURE OR FUNCTION
DB2MSTR X.Y TERMINATED ABNORMALLY. THE PROCEDURE OR FUNCTION HAS BEEN STOPPED, ASID = 014A WLM_ENV=Z"

I have the feeling that the compile's parameters is not good..

Ya. That's is right. Did you compile and link edit the program using DSNRLI?

No but with DSNHLI...

If you execute the procedure in WLM environment you need to link edit to DSNRLI. BTW, how your procedure is defined?

Hi,

Whats the meaning of how is the procedure defined?

Procedue definition can be viewed from catalog tables like SYSIBM.SYSROUTINES. Check this table and see how the procedure is defined.

It help.. Thanks a lot!

but now there is a different abend :

SQLCODE: -805
SQLERRM:
X.Y.Z.SP.18F069F3023DF4423.OTHER_PROGRAM_WHICH_RIS E_THE_SP.02
SQLERRD(3): 0.

maybe it's the sp's bind package of sp's package? ot the OTHER_PROGRAM_WHICH_RISE_THE_SP plan?
I understand that I don't need plan for sp.

If the stored procedure contains SQL statements, you must process them like they are in any other SQL application program through the DB2 pre-compiler or the SQL statement co-processor, and you must bind the resulting DBRM into a package. It does not require a plan since it runs under the thread for the calling application.

I did bind package to the SP dbrm but the Call program don't have the SP's package in the plan and it still abend on -805