keyword SS ?

Analytics
Enthusiast

keyword SS ?

Hi
I came across this problem while trying to give alias name to a table.

" select * from bp_aagg.circle SS "

I recieve the error as follows
Code = 3706.
Syntax error: expected something between the word 'circle' and the 'SS' keyword.

Would somebody help me understand what is the SS keyword & what is it used for ??
3 REPLIES
Senior Apprentice

Re: keyword SS ?

Hi Roopesh,
ss is a shortcut for Set Session.

Lots of two char combinations are reserved words, e.g.
ct -> Create Table
eq -> EQual
uc -> UpperCase

Dieter
Enthusiast

Re: keyword SS ?

thanks a lot dnoeth...
Enthusiast

Re: keyword SS ?

It's short for "SET SESSION", which is an SQL command, which is why I'm guessing it's a reserved word.