Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 LMINIT problem - not finding DDNAME Danielle.Filteau CLIST & REXX 7 Tue Sep 19, 2017 9:57 pm
No new posts Create procedure issues -628 when add... chandraBE DB2 1 Mon Sep 18, 2017 12:16 pm
No new posts Problem commiting to DB2 from IMS MPP Ole Soerensen IMS DB/DC 2 Wed Jul 26, 2017 5:19 pm
No new posts Strings with double quotes having pro... raja Arumugam All Other Mainframe Topics 11 Thu Mar 30, 2017 10:34 am
No new posts Problem reading GTF trace output danik56 ABENDS & Debugging 7 Thu Mar 16, 2017 1:02 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us