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
Wahlstedt
> Sent: zondag 11 juni 2006 20:35
> To: ADSM-L@VM.MARIST.EDU
> Subject: Select and SQL literal token - 'S', 2:nd try...
>
>
> Hi,
>
> ADSM-L returned my message even tough Alexander have answered it...
> And it isnt on the web so I resend
Hi,
ADSM-L returned my message even tough Alexander have answered it...
And it isnt on the web so I resend it if some of you have any clue.
//Henrik
-Original Message-
From: Henrik Wahlstedt
Sent: 9. juni 2006 10:52
To: ADSM: Dist Stor Manager
Subject: Select and SQL literal token
ist Stor Manager [mailto:[EMAIL PROTECTED]
> On Behalf Of Henrik Wahlstedt
> Sent: vrijdag 9 juni 2006 10:52
> To: ADSM-L@VM.MARIST.EDU
> Subject: Select and SQL literal token - 'S'
>
> Hi,
>
>
> If I use this select which I thought was OK before I tested it...
&
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'.
|