DSXchange

Hi,
I'm using an Oracle query where one of columns in Where condition has '#' in value.

The query runs fine in Toad or SQL Developer but is failing in the Oracle Connector. Please help.

Original Query:
*************
SELECT * FROM TABLE_A WHERE COLUMN_A = 'AB CDE #' AND STG_ETL_BATCH_ID = 1


Query in the Director Log after Job run:
********************************
The following SQL statement failed: SELECT * FROM TABLE_A WHERE COLUMN_A = 'AB CDE STG_ETL_BATCH_ID = 1
********************************

DataStage notes that "#" is a reserved character. It can (should) be replaced with the special value __035__ (documented here).

Thank you Ray!