DSXchange

Thanks for the replies and apologies for lack of detail, I'm new to datastage. This is a server job, it takes data from an ODBC source, goes through a transformer and outputs to a file and to an oracle database via ODBC. The ODBC Stage Inputs tab give the database name and table, with update action ...

We have a job failing as double quotes (") are being used to populate the SQL statement. Testing the statement via sqlplus returns an ora-00984 error. Changing the double quotes to single in sqlplus solves the error. How can I change it in datastage? Datastage error: ExtTASAudit_Test..Transform...