Search found 2 matches
- Thu Apr 04, 2019 8:52 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: SQLExecute Failed
- Replies: 5
- Views: 14779
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 ...
- Thu Apr 04, 2019 1:15 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: SQLExecute Failed
- Replies: 5
- Views: 14779
SQLExecute Failed
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...