Home » RDBMS Server » Networking and Gateways » HS ODBC connection to UNIData SQL translation (Oracle xe 10g)
HS ODBC connection to UNIData SQL translation [message #356752] Sun, 02 November 2008 01:22 Go to next message
ravijey
Messages: 2
Registered: November 2008
Junior Member
Experts please help.
I successfully created a db link to Unidata using HS ODBC. When I execute SQL for example "SELECT NAME FROM CUSTOMER@UNIDATA", Oracle translates the SQL as "SELECT NAME AS C000 FROM CUSTOMER@UNIDATA".
The issue is, Unidata ODBC does not recoginize "as" keyword. So I am getting a syntax error. Is there a way or a parameter I can set to disable the "as" keyword during the SQL translation ?

Re: HS ODBC connection to UNIData SQL translation [message #356753 is a reply to message #356752] Sun, 02 November 2008 01:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Try to give yourself an alias in your query:
SELECT NAME "C001" FROM CUSTOMER@UNIDATA

Regards
Michel
Re: HS ODBC connection to UNIData SQL translation [message #356835 is a reply to message #356753] Sun, 02 November 2008 14:30 Go to previous message
ravijey
Messages: 2
Registered: November 2008
Junior Member
Thanks for the response.
Still does'nt work. It is translating the SQL as

select name as c0000 from customer@unidata.

Previous Topic: how can i create more listener and do LOAD BALANCE?
Next Topic: TNS:Address already in use Urgent please help!!!
Goto Forum:
  


Current Time: Fri Mar 29 01:12:17 CDT 2024