TRANSLATION

[Rami Ojares <ra...@pdf-comics.com>]

Hi,

TRANSLATION is a reserved word in Derby but I could not find it in docs.
Could someone point me to a resource documenting it's use.

- rami

Re: TRANSLATION

[Bryan Pendleton <bp...@gmail.com>]

> TRANSLATION is a reserved word in Derby but I could not find it in docs.
> Could someone point me to a resource documenting it's use.

I don't see any other references to it in sqlgrammar.jj other than in the keyword list itself.

So perhaps it doesn't need to be a reserved word.

I can't recall ever using it or seeing it used.

thanks,

bryan

Re: TRANSLATION

[Rick Hillegas <Ri...@Sun.COM>]

Hi Rami,

You can get a free copy of a late draft of the 2008 version of the 
Standard here: http://www.wiscorp.com/SQLStandards.html The most 
important document is Part 2: Foundation. That document describes the 
core language of the Standard.

Hope this helps,
-Rick

Rami Ojares wrote:
> Thank you Rick, Bryan and Kristian!
> Rarely does one get 3 good answers so promptly :-)
> Could someone point me to a good sql reference on the web?
>
> I found the meaning of TRANSLATION and TRANSLATE eventually through 
> google but it would be nice to have a good standard sql reference.
> These commands seem to be tools for mapping one character set into 
> another (a rather useless endeavour now that we could be using unicode).
> It just hit me once when I was trying to create a table named 
> TRANSLATION.
>
> - rami

Re: TRANSLATION

[Rami Ojares <ra...@pdf-comics.com>]

Thank you Rick, Bryan and Kristian!
Rarely does one get 3 good answers so promptly :-)
Could someone point me to a good sql reference on the web?

I found the meaning of TRANSLATION and TRANSLATE eventually through 
google but it would be nice to have a good standard sql reference.
These commands seem to be tools for mapping one character set into 
another (a rather useless endeavour now that we could be using unicode).
It just hit me once when I was trying to create a table named TRANSLATION.

- rami

Re: TRANSLATION

[Kristian Waagan <Kr...@Sun.COM>]

On 18.03.10 13:46, Rami Ojares wrote:
> Hi,
>
> TRANSLATION is a reserved word in Derby but I could not find it in docs.
> Could someone point me to a resource documenting it's use.

Hi Rami,

Derby doesn't support this feature, see F695 on 
http://wiki.apache.org/db-derby/SQLvsDerbyFeatures . The keyword is 
listed under "SQL reserved words" in the Derby reference manual.
I have never used this feature myself (i.e. defining a character 
transliteration), but you can find some more information on it in the 
SQL specification.

Example syntax: "CREATE TRANSLATION", "DROP TRANSLATION".
The keyword is also used when granting / revoking privileges on 
transliterations.


Hope this helps,
-- 
Kristian

>
> - rami

Re: TRANSLATION

[Rick Hillegas <Ri...@Sun.COM>]

Rami Ojares wrote:
> Hi,
>
> TRANSLATION is a reserved word in Derby but I could not find it in docs.
> Could someone point me to a resource documenting it's use.
>
> - rami
Hi Rami,

TRANSLATION is a reserved keyword in the SQL Standard and it is 
documented as a reserved Derby keyword here: 
http://db.apache.org/derby/docs/10.5/ref/ref-single.html#rrefkeywords29722 
Although Derby grammar doesn't currently use the word, TRANSLATION is 
reserved in Derby for future use so that we will not have backward 
compatibility issues if someone implements Standard grammar involving 
this keyword.

Hope this helps,
-Rick