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 < eric-van.l...@klm.com> 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:ADSM-L@VM.MARIST.EDU] On Behalf Of > Ullrich Mänz > Sent: dinsdag 12 maart 2013 11:11 > To: ADSM-L@VM.MARIST.EDU > 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" <eric-van.l...@klm.com> > An: ADSM-L@VM.MARIST.EDU, > Datum: 12.03.2013 10:50 > Betreff: [ADSM-L] SQL error > Gesendet von: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> > > > > 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 > ******************************************************** > >
