date arithematic in db2

i_suman · New User Joined: 01 Mar 2005 Posts: 16

Hi

In db2 i am doing a date arithematic ,

Case 1:-
--------
select date(:ws-hold-da) - 11 months into var1 from sys1.sysdummy

The above querry is working fine,

Case 2:-
----------
select date(:ws-hold-da) - (:ws-hold-month-da) months into var1
from sys1.sysdummy

I moved number of months from the input file to ws-hold-month-da,
instead of number 11 of case 1; i am using host variable in case 2,
here i am getting problem because of host variable ;

Can some one please help me how to do this date arithematic.

Thanks,
Srikanth

dick scherrer · Posted: Thu Oct 09, 2008 8:57 am Post subject:

Hello,

Craq Giegerich · Posted: Thu Oct 09, 2008 5:48 pm Post subject:

What is the definition of ws-hold-month-da?

i_suman · New User Joined: 01 Mar 2005 Posts: 16

ws-hold-month-da is a pic 9(2) value zeroes variable ; which is getting
populated from input file; input file will have number of months in it;
for eg:- 12 months , 22 months etc...

dick scherrer · Posted: Thu Oct 09, 2008 10:05 pm Post subject:

Hello,

When do you think you might mention the problem you are having?

Part of getting help from the forums is following the directions you are given. . .

stodolas · Posted: Sun Oct 12, 2008 7:05 pm Post subject:

It appears that the date math can't take the working storage field when executed with a cursor.

dbzTHEdinosauer · Posted: Mon Oct 13, 2008 12:30 am Post subject:

maybe var1 is the problem.

dick scherrer · Posted: Mon Oct 13, 2008 1:02 am Post subject:

Srikanth,

We'll try yet again. . . .