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