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 <[email protected]>: > 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<[email protected]> >> Sent by: "ADSM: Dist Stor Manager"<[email protected]> >> 15/11/2010 13:39 >> Please respond to >> "ADSM: Dist Stor Manager"<[email protected]> >> >> >> To >> [email protected] >> 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 >
