ashwinreddy
Active User
Joined: 16 Sep 2004 Posts: 106 Location: Hyderabad
|
|
|
|
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 |
|
ashwinreddy
Active User
Joined: 16 Sep 2004 Posts: 106 Location: Hyderabad
|
|
|
|
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 |
|