Stored proc passing Null values

[bjohnson22]

Hi,

Does anyone have a sample of an SP called from COBOL that uses indicator variables to pass nullable parameters?

For example if some calls the SP uisng something like:

EXEC SQL CALL PROC1 INOUT1 :INOUT1IND, :INOUT2)

END-EXEC

wHAT WOULD THE SP CODE HAVE?

THANKS IN ADVANCE

 

[Truusvlugindewind]

The same syntax as used in "create table":
INOUT1 char (3)
INOUT2 char (3) NOT NULL

So every paramteter which is nullable should be called with the indicator variable. No difference with tables.