DSXchange

Aphrodite,

one possibility is to write the value to a hash file (possibly within a sperate job). The hash then can be read using UtilityHashLookup.

Within your controlling job (if you have one) you can read that value and pass it as a parameter to the job that queries the oracle table.

I guess, another approach would be to read the whole oracle table and to exclude the records not needed in a transformer constraint, where again you would use UtilityHashLookup to compare the dates.

Or just read the entire oracle table, do a lookup on the hash described with a surrogate key matching for every record, and again exclude the records not needed by a constraint.

More details and other ideas can be found here:
http://www.tools4datastage.com/forum/to ... C_ID=84730

Kind Regards

Stephan

In your controlling job, execute a SQL script to query your DB2 table and retrieve the date in question. Capture the result, parse for it, and feed it as a job parameter to your DS jobs that need it.


Kenneth Bland

To expand briefly on Ken's suggestion, the mechanism would be to call the DSExecute subroutine to run the script, using its third argument to recover the result.
Shell = "UNIX"
Command = "./MySQLscript.sh"
Output = ""
Code = 0 ; * exit status of script after call
Call DSExecute(Shell, Command, Output, Code)

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518