The command looks good except for one thing.  Space after >

Try this command.
select volume_name,state,location from drmedia where state
='COURIERRETRIEVE'> /home/maria/from_vault


Sung Y. Lee
E-mail sunglee AT us.ibm DOT com



                      Maria Ragan
                      <mragan AT YCI DOT COM>         To:       ADSM-L AT 
VM.MARIST DOT EDU
                      Sent by: "ADSM:          cc:
                      Dist Stor                Subject:  SQL redirection
                      Manager"
                      <[email protected]
                      .EDU>


                      05/02/2002 02:33
                      PM
                      Please respond to
                      "ADSM: Dist Stor
                      Manager"





I'm trying to run this sql select statement and redirect the output to a
file:

select volume_name,state,location from drmedia where
state='COURIERRETRIEVE'>/home/maria/from_vault

Separating the query with double quotes produces the same error:

ANR2907E-Unexected SQL operator token - '>'

Thank you,
Maria