IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Problem in Stores Procedure


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
ashwinreddy

Active User


Joined: 16 Sep 2004
Posts: 106
Location: Hyderabad

PostPosted: Wed Jan 17, 2007 4:06 pm
Reply with quote

Hi All,

I have some problems with the stored procedure, as I couldn't receive some values passed from the driver program.I think the problem is with the declaration in DDL, I have tried with all the combinations but couldn't found the reason behind.

Please check the following columns declarations in DDL as

IN_MVMT_RSN_CODE DECIMAL(4) IN,
IN_OTHER_LOCATION INTEGER IN,


find the difference in the Driver Spool as

RO-NO : 09202
PROD-CODE : 050064268
COUNT-DATE : 2006-05-11
COUNT-TIME : 11.00.04
QUANTITY : 0001223
REASON CODE: 0350
OTHER LOCAT: 000004560



And the output in stored procedure spool as


JIP14 STORE NUMBER = 09202
JIP00 STORE NUMBER = 09202
PROD-CODE : 050064268
COUNT-DATE : 2006-05-11
COUNT-TIME : 11.00.04
QUANTITY : 0001223
REASON CODE: 0053
OTHER LOCAT: }

PACKAGE SWITCH IS COMPLETE000000000
DUPLICATE INERATION000000000
STORE TIMES SUCESS000000000
ENTERED INTO BOOKSTOCK UPDATE MODULE000000000
SUCCESFUL BOOKSTOCK UPDATE MODULE000000000


Please can any one can help me.

Cheers
Ashwin
Back to top
View user's profile Send private message
ashwinreddy

Active User


Joined: 16 Sep 2004
Posts: 106
Location: Hyderabad

PostPosted: Wed Jan 17, 2007 4:53 pm
Reply with quote

Hi All,

Thanks for Spending some time on the issue.

I got the Problem, as the DB2 Equalent decalration for the cobol COMP variable is SMALLINT which i have made a mistake.

I have changed in the DDL with Smallint now my program is working fine.

Cheers
Ashwin
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Map Vols and Problem Dataset All Other Mainframe Topics 2
No new posts z/vm installation problem All Other Mainframe Topics 0
No new posts Invoke stored procedure via batch JCL. DB2 2
No new posts Job scheduling problem. JCL & VSAM 9
No new posts Problem with IFTHEN=(WHEN=GROUP,BEGIN... DFSORT/ICETOOL 5
Search our Forums:

Back to Top