Stored Procedure Returning Incorrect value

GuyC · Posted: Wed Nov 03, 2010 5:45 pm

I don't do cobol anymore.
I'll try to get a cobol test pgm when I have the time.

At least now you/I know it's not your SP.

raj1984 · New User Joined: 28 Oct 2010 Posts: 16 Location: India

Thanks Guyc for your support.

GuyC · Posted: Wed Nov 03, 2010 6:09 pm

extract :

raj1984 · New User Joined: 28 Oct 2010 Posts: 16 Location: India

Thanks GuyC..

It does not run it my shop.. Did you bind WLM (store procedure environment) while registering the SP ?

GuyC · Posted: Mon Nov 15, 2010 2:14 pm

bind wlm ?
The stored procedure is native, so no extra binding steps are necessary.
I precompiled/compiled/linked/bound the calling program just like any other DB2 program.

raj1984 · New User Joined: 28 Oct 2010 Posts: 16 Location: India

Thanks GuyC,

Infact i did the same. It is not working in my system. Instead of cobol , we tried to hit the SP from Java , it is working fine.

Seems that it is issue with COBOL program.

Thoughts?

GuyC · Posted: Tue Nov 16, 2010 3:03 pm

not if your sqlcode is still 000.
Could be something with (descending plausiblility):
- parameter style : GENERAL WITH NULLS vs PARAMETER STYLE GENERAL
- different versions of the same SP.
- APF-authorized WLM Environments

raj1984 · New User Joined: 28 Oct 2010 Posts: 16 Location: India

Thanks GuyC and Others.

Finally it is working now.

Thanks
Rajesh

GuyC · Posted: Thu Nov 18, 2010 12:52 pm

thx for letting us know.
What was the final problem?

raj1984 · New User Joined: 28 Oct 2010 Posts: 16 Location: India

Solution suggested by our DBA was to change the variable name.
I declared V_ACT_ID in SP and declared same variable in program as well.
But he wanted to change the name of variable . Basically same variable (name ) should not be used in both SP and COBOL pgm.

Seems to be strange but it is working .

Thanks
Rajesh