Re: SQL redirection

[Sung Y Lee]

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 [EMAIL PROTECTED]



                      Maria Ragan
                      <[EMAIL PROTECTED]>         To:       [EMAIL PROTECTED]
                      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