We created a new job today with an ODBC stage for a Sybase table. The ODBC connection works fine. We imported a table definition. We had to put 000 in the "ODBC quote character" field for the "View Data" to work successfully. Can someone enlighten me as to the significance of 000 in this field?
I have searched the this forum, the DataDirect forums and the internet with no success.
Sybase ODBC quote character 000
Moderators: chulett, rschirm, roy
Sybase ODBC quote character 000
Leroy Gharis
Dallas, TX
Dallas, TX
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
A three-digit number in this field is interpreted as the decimal ASCII value of the quote character. The same technique can be used in the delimiter character and quote character fields in Sequential File stages.
If you have NLS enabled you can also use a four-digit hexadecimal number which is the Unicode code point for the quote/delimiter character.
If you have NLS enabled you can also use a four-digit hexadecimal number which is the Unicode code point for the quote/delimiter character.
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.