Eric, Maybe the wildcard % is not valid for the datatype of TYPE which is ENUMERATED(OBJECT_TYPE). Have you tried * ?
Rick On Tue, Mar 12, 2013 at 10:49 AM, Loon, EJ van - SPLXM < [email protected]> wrote: > 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 > ******************************************************** >
