Parameter question

[JPalatianos]

Hi,
I have a UDB table that users will be updating regularly and I need to extract a single date from. This date will end up being used in the where clause of a Mainframe DB2 query(90 million rows total). Look-up doesn't seem practical since my result set will only be ~100k rows.
Is there any way to grab the date via an ODBC stage, store it as a parameter and use it in the subsequent ODBC stages where clause?
Thanks - - John

[kris007]

Sure you can. Search for UtilityHashLookUp and how to use it to pass date as a parameter to subsequent jobs. I don't have enought time to put it in detail. So give you a start, you will have to create a seperate job to extract the date from 90 million rows table and store it in a hashed file. Then you can use the routine mentioned above in a JobSequence where in you will pass the date as a parameter to your Job. All you willneed in your job is to create a parameter say LastDate and use it in your Sql query in the ODBC stage. Now in your Job Activity stage in the job sequence, you will use UtilityHashLookUp routine to get the date and pass it to this job(into your quer).

HTH

P.S. It works in 7.5. Which version are you on?

[JPalatianos]

Thanks Kris!!!
I am running 7.5 and the UtilityHashLookUp utility worked perfectly.