MVSFORUMS.com

Vreddy · Beginner Joined: 03 Feb 2003 Posts: 12 Topics: 5

I am getting -927 when a stored procedure calls a cobol program having SQL's
I saw the meaning of -927 it says language interface. I link edited cobol program with DSNELI and Stored procedure as DSNRLI. Is there any problem with that. Please let me know the right way of link editing or compiling.

Thanks
Vreddy
_________________
Thanks
Vreddy

SureshKumar · Intermediate Joined: 23 Jan 2003 Posts: 211 Topics: 21

Vreddy,
Where is the SP being invoked from ? DDF or MVS

kolusu · Posted: Fri Apr 23, 2004 10:28 am Post subject:

Vreddy,

Try to be consitent and link-edit all your modules using DSNELI

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Vreddy · Beginner Joined: 03 Feb 2003 Posts: 12 Topics: 5

Kosulu,

do we need to link edit stored procedure also as DSNELI. Our shop is using standard JCL for stored procedures and it it is link editing to DSNRLI.

I am link editing db2-cobol as DSNELI and Stored procedure as DSNRLI.

question.

Can a stored procedure call a db2-cobol program. if so how to link edit and make it work.

Thanks
Vreddy
_________________
Thanks
Vreddy

Manas Biswal · Posted: Mon Apr 26, 2004 1:28 pm Post subject:

I have never really called an external program from a stored procedure but the manual says that it can be done. If you have linkedited you SP with DSNRLI, then that means you are using WLM managed address space for your SP. You can try link editing your called COBOL program also with DSNRLI and see if that works. I think the load library of your called COBOL program needs to be concatenated to the STEPLIB of the job running the WLM established Stored procedure address space.
And finally check whether the package of your called COBOL program is in the same collection as the package for your SP. If it is not so, then you probably have to invoke a SET CURRENT PACKAGESET before calling the COBOL program.

Regards,
Manas