Strange, the server seems to treat the s different than other characters. Please note the different error messages these two commands generate:
tsm: BASKET>select * from s ANR2906E Unexpected SQL literal token - 'S'. | ..............V select * from s ANS8001I Return code 3. tsm: BASKET>select * from a ANR2939E The reference 'A' is an unknown SQL table name. | ..............V select * from a ANS8001I Return code 28. ANR2939E is the one I would expect, not ANR2906E. My postgres server doesn't display this behaviour. Regards, Alexander ------------------------------------------------------------ Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing & Networking Services > -----Original Message----- > From: ADSM: Dist 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... > 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. >