Parameter question
Posted: Fri Sep 01, 2006 12:07 pm
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
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