-----Timothy Hughes wrote: -----

>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. 

The error messages suggest that you tried to split a command into
two lines without using the appropriate continuation character
at the end of the first line (a hyphen for a TSM macro or an
interactive dsmadmc session, a backslash for the more commonly
used Unix shells, or a caret for the Windows command line
environment).