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/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] 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" <[email protected]> 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.
