Shell Programming and Scripting

Hi,

I have a file in which I have a number of insert statements (number is not fixed, it may have 10 statements or may be 1000....not fixed).

I want to execute these statements using a loop (1 statement per iteration).

For ex:

Input file has following statements:

Insert statement # 1;
Insert statement # 2;
Insert statement # 3;
Insert statement # 4;
Insert statement # 5;
......
......
......
......
......
Insert statement # n;

Instead of directly executing the statements, I want to execute it using a loop....1 statement per iteration. This is because I want some other stuffs after the execution of each statement.


Please post the resolution if anyone has any idea how can I do this....

Code:

while read LINE
do
        echo "$LINE"
        echo "stuff to do after line;"
done < inputfile | sql_interpreter

Thanks for the resolution....
can you please elaborate the steps as I am a newbe and can not make out the steps...

It's a loop, which runs the READ command once per loop, reading lines one at a time into the LINE variable. It has 'inputfile' redirected into it, hence it gets its lines from there.

Inside the loop, it prints the line, then prints whatever SQL statements you'd like to insert after it. It repeats this until the file ends.

Hi.

Excuse me but could you please explain what is "sql_interpreter"?
I am not so clear.

Thanks

Hi.

It's not clear from this thread what database system is being used.

It would appear that "sql_interpret" is intended to mean whatever is appropriate for the database system being used. i.e. for Oracle, that would be sqlplus.

Whatever program you're using that interprets SQL. This isn't rocket science.