07-01-2009
Try this...
for i in `cat textfile`
do
sh <dbscript-name> "$line"
done
coding for dbscript:
--------------------
sqlplus -s '<user-name>/<password>' > /dev/null << EOF
exec <your own DB process command>('$1');
commit;
EOF
Last edited by jayan_jay; 07-01-2009 at 07:11 AM..
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi
I want to get the a field from a SQL query into unix shell script variable. the whole situation is like this.
1. Opened a cursor to a table in DB2 databse.
2. Fetching individual rows with the help of cursor.
3. Each row has 4 fields.
I want each of the field in individual shell... (1 Reply)
Discussion started by: skyineyes
1 Replies
2. UNIX for Dummies Questions & Answers
This is basically what I want to do:
I have a file that contains single lines of IDs.
I want to query the oracle database using these IDs
to get a count of which ones match a certain condition.
the basic idea is:
cat myfile |
while read id
do
$id in select count(PC.ptcpnt_id)
from... (4 Replies)
Discussion started by: whoknows
4 Replies
3. Shell Programming and Scripting
Hi ,
I used the below script to get the sql data into csv file using unix scripting.
I m getting the output into an output file but the output file is not displayed in a separe columns .
#!/bin/ksh
export FILE_PATH=/maav/home/xyz/abc/
rm $FILE_PATH/sample.csv
sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies
4. Shell Programming and Scripting
I need to run sql script from shell script which takes the input from a file and contents of file will be like :
12345
34567
78657
and query will be like :
select seq_nbr from bus_event where event_nbr='12345';
select seq_nbr from bus_event where event_nbr='34567';
select seq_nbr... (1 Reply)
Discussion started by: rkrish
1 Replies
5. Shell Programming and Scripting
Hi,
I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database.
For instance:
USER CITY
--------- ----------
A CITY_A
B CITY_B
C ... (2 Replies)
Discussion started by: DevendraG
2 Replies
6. Shell Programming and Scripting
Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies
7. Shell Programming and Scripting
I have written a shell script that calls below sql file. It is not sending the query data in table in the body of email.
spool table_update.html;
SELECT * FROM PROCESS_LOG_STATS where process = 'ActivateSubscription';
spool off;
exit;
Please use code tags next time for your code and data.... (9 Replies)
Discussion started by: Sharanakumar
9 Replies
8. Shell Programming and Scripting
Hi All,
Seeking for your assistance to read each line $1 and $2 of input file and used it to query.
Ex. file1.txt(number range)
9064500000 9064599999
9064600000 9064699999
9064700000 9064799999
Database name: ranges_log
a_no message
9064500001 test
9064700000 ... (7 Replies)
Discussion started by: znesotomayor
7 Replies
9. UNIX for Dummies Questions & Answers
Dear experts,
I am new to linux programming. I have a shell script which i should run it on all my samples.
I only define input and out put for this script. The inputs are 3 numbers(coordination numbers) which are available in a series of text file.
Since i have a lots of samples, it takes a... (5 Replies)
Discussion started by: mohamadreza
5 Replies
10. Shell Programming and Scripting
I want to run sql query in shell script and output data save as delimited text (delimited text would be comma)
Code:
SPOOL_FILE=/pgedw/dan.txt
SQL=/pgedw/dan.sql
sqlplus -s username/password@myhost:port/servicename <<EOF
set head on
set COLSEP ,
set linesize 32767
SET TRIMSPOOL ON
SET... (8 Replies)
Discussion started by: Jaganjag
8 Replies
VI(1) General Commands Manual VI(1)
NAME
vi, ki, xi - instruction simulators
SYNOPSIS
vi [ textfile ]
vi pid
ki [ textfile ]
ki pid
xi [ textfile ]
xi pid
DESCRIPTION
Vi simulates the execution of a MIPS binary in a Plan 9 environment. It has two main uses: as a debugger and as a statistics gatherer.
Programs running under vi execute about two hundred times slower than normal--but faster than single stepping under db. Ki and xi are sim-
ilar to vi but interpret SPARC and ATT3210 binaries. The following discussion refers to vi but applies to the others as well.
Vi will simulate the execution of a named textfile. It will also make a copy of an existing process with process id pid and simulate its
continuation.
As a debugger vi offers more complete information than db(1). Tracing can be performed at the level of instructions, system calls, or
function calls. Vi allows breakpoints to be triggered when specified addresses in memory are accessed. A report of instruction counts,
load delay fills and distribution is produced for each run. Vi simulates the CPU's caches and MMU to assist the optimization of compilers
and programs.
The command interface mirrors the interface to db; see db(1) for a detailed description. Data formats and addressing are compatible with
db except for disassembly: vi offers only MIPS (db -mmipsco) mnemonics for machine instructions. Ki offers both Plan 9 and Sun SPARC for-
mats.
Several extra commands allow extended tracing and printing of statistics:
$t[0ics]
The t command controls tracing. Zero cancels all tracing options.
i Enable instruction tracing
c Enable call tracing
s Enable system call tracing
$i[itsp]
The i command prints statistics accumulated by all code run in this session.
i Print instruction counts and frequency.
p Print cycle profile.
t (Vi only) Print TLB and cache statistics.
s Print memory reference, working set and size statistics.
:b[arwe]
Vi allows breakpoints to be set on any memory location. These breakpoints monitor when a location is accessed, read, written, or
equals a certain value. For equality the compared value is the count (see db(1)) supplied to the command.
SOURCE
/sys/src/cmd/vi etc.
SEE ALSO
nm(1), db(1)
BUGS
The code generated by the compilers is well supported, but some unusual instructions are unimplemented. Some Plan 9 system calls such as
rfork cause simulated traps. The floating point simulation makes assumptions about the interpreting machine's floating point support. The
floating point conversions performed by vi may cause a loss of precision.
VI(1)