small script - get sql output & write into txt

happyv · #1 (**permalink**) 01-25-2007

Hi,

how can I write a small script to run the following statement and output the result into check_result.txt

select /*+RULE*/ tapname from typetbl where tapname like 'AA%' and rejectcode=9;

Normally, I just type sql and get into SQL>

srikanthus2002 · #2 (**permalink**) 01-27-2007

am using infomix database in unix system
just copy the your sql command to a file then run "isql tspos" as shown

Code:

echo "select /*+RULE*/ tapname from typetbl where tapname like 'AA%' and rejectcode=9" > test.sql

isql tspos test.sql

happyv · #3 (**permalink**) 02-02-2007

Quote:

Originally Posted by srikanthus2002

am using infomix database in unix system
just copy the your sql command to a file then run "isql tspos" as shown

Code:

echo "select /*+RULE*/ tapname from typetbl where tapname like 'AA%' and rejectcode=9" > test.sql

isql tspos test.sql

is not working...

any other suggestion?

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
small script help	ali560045	Shell Programming and Scripting	9	01-18-2008 10:18 AM
Very small Shell Script Help...	marconi	Shell Programming and Scripting	2	12-11-2007 05:44 AM
small script	everurs789	Shell Programming and Scripting	3	11-06-2007 05:08 PM
small script help	rkl1	Shell Programming and Scripting	1	12-06-2005 11:26 PM
Need help in a small script	super_duper_guy	Shell Programming and Scripting	2	10-24-2005 10:06 AM

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