UNIX for Dummies Questions & Answers

hmmm.....
Are you asking how you can query the DB one row at a time? It depends on your DB. Just put your query 'tool' [sqlplus for Oracle] in the loop from the original posting:

Code:

#!/bin/ksh
while read c1 c2
do
   echo "column1->[${c1}] column2->[${c2}]"

   sqlplus oracleUser/oraclePasswd@oracleSID <<EOF
       select ${c1} from table where something = ${cl2}
EOF
done < myTableFile

you'll have to work out the details - searching the FAQ archieves might help.

hi,
i am not fetching it from db

i have all these ine falt file....its exactly liek this

field1 field2
name1 name2
oops1 oop2

THESE ARE ALL STORED IN FLAT FILE NOT DB

i need to get 1 row at a time.......

how can i do this?

THANKS
vivek.s

this?

Code:

#!/bin/ksh
while read c1 c2
do
   #echo "column1->[${c1}] column2->[${c2}]"
   echo "select ${c1} from table where something = ${cl2}"
done < myTableFile

Your requirement isn't really clear and you examples are maybe misleading. Perhaps you are trying to simulate a database "select" against a UNIX flat file.

Does this describe your requirement? Read from a flat file using syntax similar to "select column1 from table where something = column2"

If this is the case, you aren't going to get what you want. The scripting constructs do not lend themselves to SQL like commands. If you are wanting to use SQL like constructs then you still need some kind of DBMS query tool (like sqlplus) that lets you read from flat files rather than a database.

Thomas

yes.........maybe i ahve confused everyone !sorry!

well this is my requirement!please forget all about databses.......i have no database now........i have a flat file which has two columns....how can read 1st row from the file......then 2nd row from the file and so on till end is reached?

hope this is bit more clear


USING THIS WILL I BE ABLE TO DO IT?


while read c1 c2
do
#echo "column1->[${c1}] column2->[${c2}]"
echo "select ${c1} from table where something = ${cl2}"
done < myTableFile


how will unix recognize c1 and c2?



THANKS A LOT FOR UR HELP GUYS!

Regards
vivek.s

YES

Shell [ != unix] will read each record//line from file myTableFile and "split" it into 2 variables [c1 and c2] based on the value of the IFS variable [set by default to " " - this value can be reset to whatever field separator your data file uses].

The values of the read columns can be used with in the "while" loop referenced by ${c1} and ${c2}.

Is that clearER?

I suggest you read the 'man' pages for whatever shell you're using and/or browse through some this site's FAQ pages.

THANKS A LOT

Regards
vivek.s