Re: [ADSM-L] select statement to display readonly and filling tapes
2010-11-15 09:20:44
According to Timothy Hughes:
> 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.
>
select VOLUME_NAME,ACCESS from volumes where status in ('FILLING','FULL')
Heinz
----------------------------------------------------------
Karlsruher Institut fuer Technologie (KIT)
Steinbuch Centre for Computing (SCC)
D-76131 Karlsruhe
----------------------------------------------------------
|
|
|