Special character "$" in database table column.
Article ID: KB0092960
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks | - |
| Not Applicable | - |
Description
Resolution:
When fetching the output schema, BW removes the special character "$" in the output so the column EXITD$ becomes EXTID.
Description
=======
In JDBC Query activity, the SQL statement is:
SELECT DISTINCT EXTID$ FROM table where EXTID$ IS NOT NULL;When fetching the output schema, BW removes the special character "$" in the output so the column EXITD$ becomes EXTID.
Resolution
======
From the Oracle documentation, http://docs.oracle.com/cd/B28359_01/server.111/b28286/sql_elements008.htm#SQLRF51109
"6. Nonquoted identifiers can contain only alphanumeric characters from your database character set and the underscore (_), dollar sign ($), and pound sign (#). Database links can also contain periods (.) and "at" signs (@). Oracle strongly discourages you from using $ and # in nonquoted identifiers."
It is better to avoid using special characters in a column name. You can modify the SQL statement below as workaround:
SELECT DISTINCT EXTID$ as EXTID FROM table where EXTID IS NOT NULL;
Issue/Introduction
Special character "$" in database table column.
Additional Information
http://docs.oracle.com/cd/B28359_01/server.111/b28286/sql_elements008.htm#SQLRF51109
Feedback
Yes
No
Powered by
