DB2 Timestamp or current date 1

[deacon1945]

I need to calculate a date in DB2 and I know I can do it like this:
EXEC SQL
SET :HOLD-TIMESTAMP =
CURRENT TIMESTAMP - 18 MONTHS
END-EXEC.
or
EXEC SQL
SET :HOLD-TIMESTAMP =
CURRENT TIMESTAMP - 20 DAYS
END-EXEC.
What I would like to do is have a variable to hole the numbers; this would add to the versatility and eliminate the need to change it when a client wanted a different date.

Thanks in advance for the help.

 

[gregsimpson]

deacon1945,

you simply need to do as follows

EXEC SQL
SET :HOLD-TIMESTAMP =
CURRENT TIMESTAMP - :wc-number DAYS
END-EXEC.

Where wc-number is a host variable. If in Cobol the definition I would use for wc-number would be s9(15) comp-3.

Cheers
Greg