Ok Thanks every one, as i told this is a DB2 SQL query . We have found a solution to read the unload table query from the PDS and will be replacing the where clause current date with the date from the cycle file.
Thanks Ron T ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN