Andy, Thanks :-) the 50 character limit is a good addition indeed.
Not sure which one yields a better performance, though, might be something worth looking into. Cheers, Rick On Tue, Mar 12, 2013 at 12:20 PM, Andrew Raibeck <[email protected]> wrote: > I actually like this solution even more than the one I gave a moment ago! > One comment: I suggest "cast(type as char(50))" instead of just "cast(type > as char)", do avoid a truncation warning. > > Andy Raibeck > IBM Software Group > Tivoli Storage Manager Client Product Development > Level 3 Team Lead > Internal Notes e-mail: Andrew Raibeck/Hartford/IBM@IBMUS > Internet e-mail: [email protected] > > IBM Tivoli Storage Manager support pages: > > http://www.ibm.com/support/entry/portal/Overview/Software/Tivoli/Tivoli_Storage_Manager > > http://www.ibm.com/developerworks/wikis/display/tivolidoccentral/Tivoli > +Storage+Manager > https://www.ibm.com/developerworks/mydeveloperworks/wikis/home/wiki/Tivoli > +Storage+Manager/page/Home > > "ADSM: Dist Stor Manager" <[email protected]> wrote on 2013-03-12 > 07:12:43: > > > From: Rick Harderwijk <[email protected]> > > To: [email protected], > > Date: 2013-03-12 07:13 > > Subject: Re: Antwort: [ADSM-L] SQL error > > Sent by: "ADSM: Dist Stor Manager" <[email protected]> > > > > Eric, > > > > How about > > > > select * from backups where node_name='KL127EAC' and cast(type as char) > > like 'IMAGE%' > > > > Cheers, > > > > Rick > > > > On Tue, Mar 12, 2013 at 11:57 AM, Loon, EJ van - SPLXM < > > [email protected]> wrote: > > > > > Hi Ulli! > > > Unfortunately the same error: > > > > > > ANR2921E The SQL data type of expression 'BACKUPS.TYPE' is > > > ENUMERATED(OBJECT_TYPE); expecting a character string expression. > > > > > > Kind regards, > > > Eric van Loon > > > AF/KLM Storage Engineering > > > > > > > > > -----Original Message----- > > > From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf > Of > > > Ullrich Mänz > > > Sent: dinsdag 12 maart 2013 11:11 > > > To: [email protected] > > > Subject: Antwort: [ADSM-L] SQL error > > > > > > Hi Eric, > > > > > > try to add the table name as follows: > > > > > > select * from backups where backups.node_name='KL127EAC' and > backups.type > > > like 'IMAGE%' > > > > > > good luck > > > > > > regards > > > Ulli > > > > > > > > > > > > Ullrich Mänz > > > Data Center Services > > > > > > FRITZ & MACZIOL Software und Computervertrieb GmbH Ludwig Str. 180D, > 63067 > > > Offenbach, Germany > > > > > > Mobil +49 170 7678 434 > > > Fax: +49 69 3801 3500 10 > > > Web: http://www.fum.de > > > > > > Amtsgericht Ulm, Handelsregister-Nummer: HRB 1936 > > > Geschäftsführer: Heribert Fritz > > > Inhaber: Imtech N.V., Gouda, Niederlande > > > > > > > > > > > > > > > Von: "Loon, EJ van - SPLXM" <[email protected]> > > > An: [email protected], > > > Datum: 12.03.2013 10:50 > > > Betreff: [ADSM-L] SQL error > > > Gesendet von: "ADSM: Dist Stor Manager" <[email protected]> > > > > > > > > > > > > Hi TSM-ers! > > > > > > I'm trying to retrieve all image backups for a specific node. I'm > issuing > > > the following query: > > > > > > > > > > > > select * from backups where node_name='KL127EAC' and type like 'IMAGE%' > > > > > > > > > > > > This returns the following error: > > > > > > > > > > > > ANR2921E The SQL data type of expression 'TYPE' is > > > ENUMERATED(OBJECT_TYPE); expecting a character string expression. > > > > > > > > > > > > This query works fine: > > > > > > > > > > > > select * from backups where node_name='KL127EAC'and type='IMAGE' works > > > fine... > > > > > > > > > > > > That's where where my limited SQL knowledge stops. > > > > > > Thank you very much for any help! > > > > > > Kind regards, > > > > > > Eric van Loon > > > > > > AF/KLM Storage Engineering > > > > > > ******************************************************** > > > For information, services and offers, please visit our web site: > > > http://www.klm.com. This e-mail and any attachment may contain > > > confidential and privileged material intended for the addressee only. > If > > > you are not the addressee, you are notified that no part of the e-mail > or > > > any attachment may be disclosed, copied or distributed, and that any > other > > > action related to this e-mail or attachment is strictly prohibited, and > may > > > be unlawful. If you have received this e-mail by error, please notify > the > > > sender immediately by return e-mail, and delete this message. > > > > > > Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or > its > > > employees shall not be liable for the incorrect or incomplete > transmission > > > of this e-mail or any attachments, nor responsible for any delay in > receipt. > > > Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch > > > Airlines) is registered in Amstelveen, The Netherlands, with registered > > > number 33014286 > > > ******************************************************** > > > ******************************************************** > > > For information, services and offers, please visit our web site: > > > http://www.klm.com. This e-mail and any attachment may contain > > > confidential and privileged material intended for the addressee only. > If > > > you are not the addressee, you are notified that no part of the e-mail > or > > > any attachment may be disclosed, copied or distributed, and that any > other > > > action related to this e-mail or attachment is strictly prohibited, and > may > > > be unlawful. If you have received this e-mail by error, please notify > the > > > sender immediately by return e-mail, and delete this message. > > > > > > Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or > its > > > employees shall not be liable for the incorrect or incomplete > transmission > > > of this e-mail or any attachments, nor responsible for any delay in > receipt. > > > Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch > > > Airlines) is registered in Amstelveen, The Netherlands, with registered > > > number 33014286 > > > ******************************************************** > > > > > > > > >
