There is certainly a sense in which Lizette Koehler's response to the OP---Ask
your question in the appropriate DB2 forum---is the right one.
On the other hand, the CONVTOD macro converts date-and-time data into the
equivalent STCK[E] value, in this case that of a date-and-time value for two
years ago.
The SQL statements required to compare two timestamps as such are then
presumably within the ken of the OP.
The canonical description of CONVTOD is in the z/OS MVS Assembler Services
Manual, volume 2 (IARR2V-XCTLX), SA22-7607.
Posts of this sort of are of interest in another context too. They suggest
that mainframe skills may indeed be in short supply.
John Gilmore Ashland, MA 01721-1817 USA
_________________________________________________________________
Hotmail: Trusted email with Microsoft’s powerful SPAM protection.
http://clk.atdmt.com/GBL/go/196390706/direct/01/
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
