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
********************************
'#' in Where condition value of Oracle Query
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DataStage notes that "#" is a reserved character. It can (should) be replaced with the special value __035__ (documented here).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.