Run a sql from unix

depakjan · #1 (**permalink**) 05-19-11, 06:00

i have file Summary.txt

contents looks like this

Code:

./log_CS-185.lst:Error detected, rollbacking
./log_CS-13603.lst:Error detected, rollbacking
./log_CS-1002.lst:Error detected, rollbacking

now i have to parse this file to get
CS-185
CS-13603
CS-1002

and insert these values into a table... how do i do this using unix script ?..

n_i · #2 (**permalink**) 05-19-11, 09:21

Code:

$ awk "
> BEGIN {print \"connect to mydb\"}
> {match(\$0,/\/[^.]*\./);f=substr(\$0,RSTART+1,RLENGTH-2); printf \"insert into mytable values ('%s') \n\", f ;}
> END {print \"commit\"; print \"connect reset\"}
> " Summary.txt | db2

Internet Services

Web Development

Digital Marketing

Consumer Tech