On Tue, 5 Aug 2014 08:47:31 -0500, Ron Thomas wrote: >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. > I'm slightly surprised that current-date is evaluated for each row inspected rather than once at the start of the query. Or does the problem arise because depending on workload it's unpredictable on which date the query is issued?
Anyway, sounds like a proper solution. -- gil ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
