help with awk command

Shell Programming and Scripting
1

hi,

i have a file with few LOAD scripts. I need to execute it against a db, im just trying to execute the script line by line from the file show that i can track the execution if it fails in a particular line

load.sql

LOAD FROM t1.unl INSERT INTO t1;
LOAD FROM t2.unl INSERT INTO t2;
LOAD FROM t3.unl INSERT INTO t3;
....

when i use cat load.sql | dbaccess , i couldn't track the execution table by table.

So i tried it by putting in a loop using below code -

for line in `awk -F";" '{print $0}' load.sql` 
do
  cat $line | dbaccess
  echo "Processing $line"
done

but this doesn't works.

Please advice.

Thanks!

2

What are the messages you receive after executing this?
BTW, the loop can be replaced with:

while read line
do
 echo "Processing $line" 
 dbaccess "$line"
done < load.sql