Heey Timothy

Seems you accidently copied 2 lines, in stead of the command in 1
line.  status='FILLING' has been processed as an other command, so
both lines gave errors.

Try again the same command, but be sure it's in 1 line.
Or use a - at the end of each line to continue, but best is to just use 1 line.

Regards,
Maurice



2010/11/15 Timothy Hughes <Timothy.Hughes AT oit.state.nj DOT us>:
> thanks steve!
>
> I tried that command failed, and also I want to select the "readonly"
> tapes that say "filling" also.  So I replaced the "or" with "and". this
> command failed also
>
> tsm: >select VOLUME_NAME,ACCESS from volumes where access='READONLY' or
> status='FILLING'
>
> ANR0162W Supplemental database diagnostic information:  -1:42601:-104
> ([IBM][CLI Driver][DB2/AIX64] SQL0104N  An unexpected token
> "END-OF-STATEMENT"
> was found following "cess = 'READONLY' or".  Expected tokens may include:
> "<boolean_term>".  SQLSTATE=42601
> ).
> ANR0516E SQL processing for statement select VOLUME_NAME , ACCESS from
> volumes
> where access = 'READONLY' or  failed.
> ANS8001I Return code 3.
>
> tsm: status='FILLING'
> ANS8001I Return code 3.
>
> tsm: TSMCORE>
>
> tsm: TSMCORE>
>
>
> On 11/15/2010 8:48 AM, Steven Langdale wrote:
>>
>> How about:
>>
>> select VOLUME_NAME,ACCESS from volumes where access='READONLY' or
>> status='FILLING'
>>
>> Steven
>>
>>
>>
>>
>> Timothy Hughes<Timothy.Hughes AT OIT.STATE.NJ DOT US>
>> Sent by: "ADSM: Dist Stor Manager"<ADSM-L AT VM.MARIST DOT EDU>
>> 15/11/2010 13:39
>> Please respond to
>> "ADSM: Dist Stor Manager"<ADSM-L AT VM.MARIST DOT EDU>
>>
>>
>> To
>> ADSM-L AT VM.MARIST DOT EDU
>> cc
>>
>> Subject
>> [ADSM-L] select statement to display readonly and filling tapes
>>
>>
>>
>>
>> Caterpillar: Confidential Green Retain Until: 15/12/2010
>>
>>
>>
>> Hi
>>
>> I am trying to add "filling" tapes to this select statement and I am
>> having no luck does anyone have a select statement that shows this?
>>
>>
>>
>> I already have most of the statement below i just need to add "filling"
>> to the statement
>>
>> select VOLUME_NAME,ACCESS from volumes where access ='READONLY'
>>
>>
>> thanks for any help
>