Hi- We are using Datastage 8.1. I am using ODBC connector stage to read data. But am unable to see "Read Select statement from file" option in the stage. Is this option available only in later versions of Datastage but not in 8.1?
I can't check at the moment but it isn't always a discrete option. In some stages you specify "User Defined" and then put "{FILE} <path to sql file>" in where the SQL itself would normally be. Should be documented if that's how it works there.
-craig
"You can never have too many knives" -- Logan Nine Fingers
I have tried specifying the file path in the Select statement box of ODBC connector stage but it didn't work.
The Oracle connector has the specific option to pick the select query from a file. So, if am using ODBC connector is there any other way to pick the query from a file?
Only whatever is documented - did you check? And since I can't tell from your reply, you have to actually include {FILE} at the front of the pathname rather than just the path - did you? Or it might be "{FILE}=", don't recall off the top of my head.
-craig
"You can never have too many knives" -- Logan Nine Fingers
I am passing the source query path during runtime. As I have said this is working in Oracle connector but not in ODBC connector. Plz lemme know if this is correct?
I don't see anything in the documentation that indicates that the ODBC Connector supports reading SQL from a file. Unless someone here knows otherwise, time to involve your official support provider it would seem, see what they say your options are.
-craig
"You can never have too many knives" -- Logan Nine Fingers