sqlcode -471 when executing stored proc from CICS

[Maxine G.]

I've never worked with stored procedures in DB2 before, and apparently they've
never been used with CICS in the shop I'm working in, so I have no examples
to turn to.

I've written stored procedure in COBOL II, to be called by a COBOL II CICS
program. I am able to successfully call the procedure from a batch program.
When I call it from a CICS program, I get sqlcode -471, reason code 00E79001,
which basically says that the procedure is "stopped". That doesn't seem right
to me since I was able to call the procedure in batch, but I guess I don't
really understand what stopped means.

The DB2 version is 5.1.1.

Thanks in advance for any advice on how to resolve this.

-Maxine

mg at pcg dot net

[Maxine G.]

I'm replying to my own post because I discovered that I was wrong when I said
the procedure rant successfully when called from batch. It got the same
sqlcode as in CICS. So, I guess all I may need to do is a start procedure.

Thanks anyway.

-Maxine

In article <3y3W3.2070$Cx6....@typhoon-sf.snfc21.pbi.net>,