Query the table and return values to shell script and search result values from another files.


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Query the table and return values to shell script and search result values from another files.
# 1  
Old 05-08-2013
Query the table and return values to shell script and search result values from another files.

Hi,

I need a shell script, which would search the result values from another files.

1)execute " select column1 from table_name" query on the table.
2)Based on the result, need to be grep from .wft files.

could please explain about this.Below is the way i am using.

Code:
#!/bin/sh
export db_connection_url=apps/apps@VIS
ls -l ${XXHEX_TOP}/*.wft | awk '{ if ($1 !~ /^d/) {print $9;} }' > wft_file_list.txt
while read LINE
do
names=`sqlplus -s $db_connection_url <<EOF
set pagesize 0 feedback off verify off echo off serveroutput on time off timing off 
select distinct name
from error_log;
exit
EOF
`
FILENAME=`basename $LINE`
if [ $(echo ${FILENAME} | egrep -r "$name") -eq 1 ]; then
echo "file present"
else
echo "file not present"
fi
done <wft_file_list.txt

Thank you.
# 2  
Old 05-08-2013
To start with you are storing the sqlplus result under names variable but using $name in egrep
This User Gave Thanks to vidyadhar85 For This Post:
# 3  
Old 05-08-2013
yes, it is $names in egrep.
now, i am getting the below error.
Code:
./listnames.sh: line 16: [: -eq: unary operator expected
file not present
./listnames.sh: line 16: [: -eq: unary operator expected
file not present

# 4  
Old 05-08-2013
try below if
Code:
 
 
if [ `egrep -c "$names" ${FILENAME}`  -eq 0 ]; then
echo "file not present"
else
echo "file present"
fi

This User Gave Thanks to vidyadhar85 For This Post:
# 5  
Old 05-08-2013
Thanks a lot for all your replies... it is working fine.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Putting query result dynamically to one cell of table from shell

I have to send a data in mail table format.only one cell need to get dynamically from query. my code is like (echo '<table boarder="1"> echo '<tr><td>stock</td><td>/path</td><td>.........</td></tr>' echo '</table> )sendmail.. in ......... I am trying to get query result.By putting query... (2 Replies)
Discussion started by: meera_123
2 Replies

2. Shell Programming and Scripting

awk file to read values from Db2 table replacing hard coded values

Hi, I want to replace a chain of if-else statement in an old AWK file with values from Db2 table or CSV file. The part of code is below... if (start_new_rec=="true"){ exclude_user="false"; user=toupper($6); match(user, "XXXXX."); if (RSTART ==2 ) { ... (9 Replies)
Discussion started by: asandy1234
9 Replies

3. Shell Programming and Scripting

How to add values of two files and result in third file

Hi, I am new to shellscripting, I have two files as below File1: Abcdefg110111xyza000000600000000024.020000060000000000024.020000004660000000003.41000000000010000000100.000000000123 File 2:... (3 Replies)
Discussion started by: rajendrabujji
3 Replies

4. Shell Programming and Scripting

Shell script to catch PL/SQL return values

I tried searching the forum for similar posts but its closed now. Would appreciate any help on this. I am trying to capture return value from a select query into a variable. DB is Oracle I am able to spool it to a file but I donot intend to use it. Here is my script that does not work ;) I... (27 Replies)
Discussion started by: monie2717
27 Replies

5. Shell Programming and Scripting

how to store the return values of stored procedure in unix shell script.

hi i am calling a oracle stored procedure(in the database) from unix shell scripting (a.sh). the called stored procedure returns some values through OUT variables i want to assign the return values of stored procedure in to unix shell script variable. can you provide me the code. ... (1 Reply)
Discussion started by: barani75
1 Replies

6. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies

7. Shell Programming and Scripting

AWK: read values from file1; search for values in file2

I have read another post about this issue and am wondering how to adapt it to my own, much simpler, issue. I have a file of user IDs like so: 333333 321321 546465 ...etc I need to take each number and use it to print records wherein the 5th field matches the user ID pulled from the... (2 Replies)
Discussion started by: Bubnoff
2 Replies

8. Shell Programming and Scripting

Shell script to catch PL/SQL return values

Hello, I need some help from the experts on PL/SQL and Shell scripting. I need a shell script that runs a PL/SQL procedure and gets the values returned from the PL/SQL procedure into the shell variables. The PL/SQL procedure returns multiple values. I was able to assign a single return value... (1 Reply)
Discussion started by: Veera_Raghav
1 Replies

9. Shell Programming and Scripting

How to pass pl/sql table values to shell script

Hello, i am using '#!/bin/bash', i want to make a loop in pl/sql, this loop takes values from a table according to some conditions, each time the loop choose 3 different variables. What i am not able to do is that during the loop i want my shell script to read this 3 variables and run a shell... (1 Reply)
Discussion started by: rosalinda
1 Replies

10. Shell Programming and Scripting

Korn Shell Script - Read File & Search On Values

I am attempting to itterate through a file that has multiple lines and for each one read the entire line and use the value then to search in other files. The problem is that instead of an entire line I am getting each word in the file set as the value I am searching for. For example in File 1... (2 Replies)
Discussion started by: run_unx_novice
2 Replies
Login or Register to Ask a Question