MVSFORUMS.com

arshadh · Beginner Joined: 10 Jan 2007 Posts: 33 Topics: 12

My DBA has defined a stored procedure with NULL-Indicator as SMALLINT.
In the Underlying COBOL-SQL Stored procedure we have defined that as S9(04) COMP. It will be invoked by the JAVA front end.
The Problem is Eventhough we move some numeric values (say -1,5 etc.) in the NULL indicaor fields it gives only ZERO in the output(front end).

So for debugging purpose we added Display statements to Display the value of the NULL indicators after moving -1 into the same We got (in the Corressponding DB2 job Spool)

kolusu · Posted: Tue May 22, 2007 9:00 am Post subject:

arshadh,

0000J is indeed -1. Cobol converts the display with sign overpunch on the last byte.

check this link which explains about the sign

http://www.mvsforums.com/helpboards/viewtopic.php?t=2906&highlight=overpunch

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

arshadh · Beginner Joined: 10 Jan 2007 Posts: 33 Topics: 12

But the front end Java program shows the NULL inicator value as zero '0'. I think it considers only the first four bytes... Help me to resolve the issue

kolusu · Posted: Tue May 22, 2007 9:48 pm Post subject:

arshadh,
Move the null ind defined as S9(04) COMP to a variable defined as -9(3) and read this variable in java.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

arshadh · Beginner Joined: 10 Jan 2007 Posts: 33 Topics: 12

Dear All,

The Problem was with myself. I declared all the linkage section variables under one 01 level. But my seniors told me to decalre them as indivdual 01 level variables.. Then the problem was solved and the right values to and fro the Stored procedure.

Thanks a lot kolusu..