MVSFORUMS.com

The stored procedure is defined with parameter style as DB2SQL(can pass NULLS).
1. When I send NULL values from Java, I receive NULL indicators only for integers i.e S9(09) COMP. For other data type ...

Is it possible to send NULL values in an out parameter to a calling program when my stored proc is written in COBOL?
I tried this:
LINKAGE SECTION
10 LS-TEXT PIC X(10).
10 LS-TEXT-NI PIC S ...

I think suresh kumar's code will work. Just one point here - It is generally not advisable to apply scalar functions on the left hand side like
WHERE CHAR(col_no) = col2_no because all rows for col_ ...

Kolusu,
My understanding was that order_no will be found in table 1 but the order_name for the order_no could be NULL. I think psriddhar wants to insert 'PPP' if ordername for the corresponding order ...

I think you should try

UPDATE T2
SET T2.OrderType = (
SELECT COALESCE(T1.OrderType,'XXX')
FROM T1
WHERE T1.OrderNo = T2.OrderNo ) ;

or

UPDATE T2
SET T2.OrderType = ...

I am using DB2 Version 7.1 on mainframe. I am writing Stored Procedures in COBOL. If an error occurs after SQL processing, then I catch the error in the COBOL code and write a message to sysout and te ...

Thanks, I corrected the syntax error in the control card. What I meant by my output file had all spaces was that I did not see the data I expected. Instead it had spaces on each and every record.

I am trying to concatenate a dataset of LRECL 80 with a TEMP dataset of LRECL 160 which I finally use to write to a FLAT FILE. The output file however contains NULLS i.e. X'00' after position 80. I ha ...