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