ADSM-L

Re: [ADSM-L] SQL error

2013-03-12 06:16:25
Subject: Re: [ADSM-L] SQL error
From: Rick Harderwijk <rick.harderwijk AT GMAIL DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 12 Mar 2013 11:14:28 +0100
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 <
Eric-van.Loon AT klm DOT com> 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
> ********************************************************
>

<Prev in Thread] Current Thread [Next in Thread>