Query on SET Db2 Command.

ajay_udl · New User Joined: 10 Oct 2006 Posts: 29

Hi All,

I wanted to calculate a date which is 27 months old.
I have introduced the below mentioned code in a cobol program.

EXEC SQL
SET :WS-PURGE-DT = WS-PURGE-DB2 - 27 MONTHS
END-EXEC

The variables are defined as below in WS.

05 WS-PURGE-DT PIC X(10).
05 WS-PURGE-DB2 PIC X(10).

But this is not working for me by giving a sqlcode of -171.
If the above code wont work, can somebody help with the correct statement to get the 27 months old date.

Thanks in advance
Ajay.

ajay_udl · New User Joined: 10 Oct 2006 Posts: 29

Hi All,

A small correction in the above mentioned code.
I have missed the colon for host variable

it will look like:

EXEC SQL
SET :WS-PURGE-DT = :WS-PURGE-DB2 - 27 MONTHS
END-EXEC

regards
Ajay

dbzTHEdinosauer · Posted: Tue Sep 07, 2010 2:40 pm

give you a hint:

db2 knows the data type of a column.
but, db2 has no idea the data type of a host variable.