MVSFORUMS.com

[sant_1028]

We have written a cobol db2 stored proc program with Generate with Nulls option. We are calling this stored proc from db2 command center.
From the stored proc we are getting one amount field (decimal) and date field as null values. How to handle this null values in the cobol program. Our stored proc abends whenever we get null values. We do insert and update in this program. In the databse those fields are delcared as nullable.

Declared this in Linkage section
01 IND-PARM.
05 IN-AMT-IND PIC S9(4) COMP.
05 IN-DT-IND PIC x(26).

01 INPUT-VAR.
05 IN-AMT PIC S9(4) COMP.
05 IN-DT PIC x(26).

PROCEDURE DIVISION USING IN-AMT,
IN-DT.

EXEC SQL
INSERT
INTO X
(amt, dt) values :IN-AMT
IN-AMTAST-IND
, IN-DT
IN-DT-IND
END-EXEC

Do we need to give IND-PARM in procedure devison using variabl?
Do we need todo anything? Please advise.

Thanks in advance.

[kolusu]

sant_1028,

Check this topic which discusses a similar issue

http://www.mvsforums.com/helpboards/viewtopic.php?t=2565&highlight=stored+procedure

Also check out this redbook which explains in detail about SP's

http://www.redbooks.ibm.com/abstracts/sg247083.html?Open

Hope this helps...

Cheers

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