| View previous topic :: View next topic |
| Author |
Message |
guru
Beginner
Joined: 26 Jul 2004
Posts: 6
Topics: 4
|
 Posted: Mon Jul 26, 2004 9:00 am Post subject: SQL code of -44M in Stored Procedure |
 |
|
hI,
We are trying to create a Stored Procedure(SP) in Cobol and call it from another Cobol Program. Is it possible to get a small sample program and the steps to be followed for creating and binding the SP ? We have followed the steps from DB2 Appllication Programming Guide and are getting the following error : 44M
SYSIBM.SYSROUTINES contains the Stored Procedure we defined. But the error thrown shows External Load module not found. Could you please help ?
Guru |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
|
| Back to top |
|
|
SureshKumar
Intermediate
Joined: 23 Jan 2003
Posts: 211
Topics: 21
|
| Posted: Mon Jul 26, 2004 11:33 am Post subject: |
|
|
Guru,
You have provided very minimal information to suggest any solution. look at how the program has been compiled. Give importence to the Linklib - typically SP's are complied with different LE interfaces like DSNRLI, DSNELI, DSNCLI etc. typically SP's are executed under RRS and not thru TSOTMP. The load lib and the LE (for RRS) need to be in the WLM default libraries.
Lok for
1. How the program is compiled
2. Are you using RRS or TSO
3. What is the order of Concetanation of the Loadlibs in WLM
this should give a fairly good idea about why the Load is not being identified
thanks |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
