Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Backtick Backquote in JDBC Driver SQL
Backtick Backquote in JDBC Driver SQL [message #57227] Fri, 10 July 2009 20:47 Go to next message
Rob C. is currently offline Rob C.Friend
Messages: 2
Registered: July 2009
Junior Member
The SQL builder adds backticks (backquotes) to database and table names.
Teradata (which I'm accessing through a JDBC driver) can't interpret the
backquotes. Is there an way to make them optional, or replace them with
another delimiter? (Teradata uses double quotes (") or nothing instead of
the backquote (`).

Report message to a moderator

Re: Backtick Backquote in JDBC Driver SQL [message #436370 is a reply to message #57227] Thu, 30 July 2009 23:12 Go to previous message
Brian Payton is currently offline Brian PaytonFriend
Messages: 154
Registered: July 2009
Senior Member
The SQL Query Builder component uses double-quotes, so I'm surprised
that you are seeing back-quotes. Plus, it only quotes when necessary.
(That is when the identifier contains spaces or other unusual
characters.) Can you give a more detailed usage scenario?

Rob C. wrote:
> The SQL builder adds backticks (backquotes) to database and table names.
> Teradata (which I'm accessing through a JDBC driver) can't interpret the
> backquotes. Is there an way to make them optional, or replace them with
> another delimiter? (Teradata uses double quotes (") or nothing instead
> of the backquote (`).
>
>

Report message to a moderator

Re: Backtick Backquote in JDBC Driver SQL [message #596171 is a reply to message #57227] Thu, 30 July 2009 23:12 Go to previous message
Brian Payton is currently offline Brian PaytonFriend
Messages: 154
Registered: July 2009
Senior Member
The SQL Query Builder component uses double-quotes, so I'm surprised
that you are seeing back-quotes. Plus, it only quotes when necessary.
(That is when the identifier contains spaces or other unusual
characters.) Can you give a more detailed usage scenario?

Rob C. wrote:
> The SQL builder adds backticks (backquotes) to database and table names.
> Teradata (which I'm accessing through a JDBC driver) can't interpret the
> backquotes. Is there an way to make them optional, or replace them with
> another delimiter? (Teradata uses double quotes (") or nothing instead
> of the backquote (`).
>
>

Report message to a moderator

Previous Topic:Access Web Services using DTP
Next Topic:"Edit in SQL Query Builder..." does nothing
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 04 08:21:44 GMT 2024

Powered by FUDForum. Page generated in 0.06774 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly