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