IBM Information Server - How to pass parms in a select SQL
Posted: Sat Jul 05, 2008 12:52 pm
Hello,
I am trying to pass a where clause value to a relational/odbc/teradata connector stage.
Exampe: I want to extract data from Address table by passing the state-code and write it to a dataset. I want to pass the state-cd as a job parameter and override every time with a state value (like, MN, IL, NY etc) and run the same job using the passed state code to extract data for that state. Can anyone please help me with how to pass the state-code parameter in the SQL stmt where clause for any database stage? [I am trying this on Teradata connector..]
Thank you.
Chandu.
I am trying to pass a where clause value to a relational/odbc/teradata connector stage.
Exampe: I want to extract data from Address table by passing the state-code and write it to a dataset. I want to pass the state-cd as a job parameter and override every time with a state value (like, MN, IL, NY etc) and run the same job using the passed state code to extract data for that state. Can anyone please help me with how to pass the state-code parameter in the SQL stmt where clause for any database stage? [I am trying this on Teradata connector..]
Thank you.
Chandu.