Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Problem in Stores Procedure

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Problem in Stores Procedure
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    Post subject: Re: Problem in Stores Procedure
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Problem reading GTF trace output danik56 ABENDS & Debugging 7 Thu Mar 16, 2017 1:02 pm
No new posts ROUNDED Problem with COMPUTE statement shalem COBOL Programming 11 Thu Feb 09, 2017 8:16 pm
No new posts Calling procedure with multiple entri... steve-myers PL/I & Assembler 5 Fri Jan 27, 2017 3:33 pm
No new posts SYMNAMES problem jacobdng DFSORT/ICETOOL 7 Thu Dec 22, 2016 7:47 am
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us