Interesting... the TSM server's SQL parser is apparently not accepting
enumerated types as valid table correlation (alias) names. APAR IC49749
has been opened to address this.

Use "select values from enumtypes" to identify those strings that you
should not use as table alias names.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

IBM Tivoli Storage Manager support web page:
http://www-306.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 06/09/2006
01:51:38:

> Hi,
>
>
> If I use this select which I thought was OK before I tested it...
> tsm:>select s.schedule_name, s.STARTTIME, a.node_name from
> CLIENT_SCHEDULES s, ASSOCIATIONS a where s.schedule_name=a.schedule_name
> ANR2906E Unexpected SQL literal token - 'S'.
>
>                                         |
>          ...............................V...............................
>          ode_name from CLIENT_SCHEDULES s, ASSOCIATIONS a where s.schedu
>
> ANS8001I Return code 3.
>
>
> Instead of using S i use SS, and it works..
> select ss.schedule_name, ss.STARTTIME, a.node_name from CLIENT_SCHEDULES
> ss, ASSOCIATIONS a where ss.schedule_name=a.schedule_name
>
>
> What magic lies behind "SQL literal token - 'S'."
> Are there more tokens that I should be aware of?
> Etc?
>
>
>
> Thanks
> Henrik
>
>
> -------------------------------------------------------------------
> The information contained in this message may be CONFIDENTIAL and is
> intended for the addressee only. Any unauthorised use, dissemination of
the
> information or copying of this message is prohibited. If you are not the
> addressee, please notify the sender immediately by return e-mail and
delete
> this message.
> Thank you.