our DBA is using castdate function
SELECT SUBSTR(APPLID,1,8)
,CAST('1969-12-31' AS DATE) + PDATE DAYS
,RIGHT((' ' || STRIP(DIGITS(COUNT(*)),LEADING,'0')),9)
,PDATE
,DNAME
,DNAME_WHOLE
,B.NAME
FROM SROLSHE.DIRECTORY , ARSSERVR.ARSNODE B
WHERE (SUBSTR(APPLID,1,8) = 'LEBLL01P'
OR SUBSTR(APPLID,1,8) = 'LECHK01P')
AND (CAST('1969-12-31' AS DATE) + PDATE DAYS) > '1997-12-31'
AND (CAST('1969-12-31' AS DATE) + PDATE DAYS) < '2006-02-12'
AND NID = PRI_NID
GROUP BY
APPLID
,PDATE
,DNAME
,DNAME_WHOLE
,B.NAME
WITH UR;