Export Query not Working in Shell

GEBRAUN · #1 (**permalink**) 07-20-2006

I am exporting data using a shell program. I am getting all of the records instead of getting a subset based on my query. The export_problem.par lists all of my tables. I tried the query with the ' and without it. How do I get the export to use the query?

Thanks!

COMPRESSED_FILE=$DATADIR/perprod_hd_problem.dmp.Z
PARFILE=$DATADIR/export_problem.par
query="'where add_months(close_time, 15) < sysdate'"
DIRECT=
ERROR="In step export HD problem data step 1 of 3"
echo "Export HD problem data"
exported data but

jim mcnamara · #2 (**permalink**) 07-20-2006

\' and \"

"escaping" a metacharacter forces the shell to interpretet certain characters literally. You can also use \047 (octal) for these characters as well.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
C Shell Script query	bpupdown	Shell Programming and Scripting	1	05-13-2008 07:38 PM
executing a SQL query in shell script	lijju.mathew	Shell Programming and Scripting	1	05-17-2007 11:29 AM
help for writing shell script to export table data	sankarg	Shell Programming and Scripting	3	10-18-2006 06:01 AM
Executing Sql Query Using Shell Script	ragha81	Shell Programming and Scripting	14	07-31-2006 02:15 PM
Perl: export variable to shell	oldtrash	Shell Programming and Scripting	2	09-11-2003 10:23 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by