DSNXRDTF

DSNXRDTF is part of the relational data systems component of DB2 and is involved in date-time arithmetic processing.

Hints

Consider alternative methods of coding the statement to avoid embedding date/time arithmetic. Perform the arithmetic in the host coding language.

For example, the statement

 

SELECT CUST_NO FROM CUSTOMER_TABLE

WHERE PROCESS-DATE > DATE(:PROCESS-DATE +90 DAYS)

can be recoded as

SELECT CUST_NO FROM CUSTOMER_TABLE

WHERE PROCESS-DATE > :PROCESS-DATE-PLUS90.