[SOLVED] How to Execute Multiple Sql Files using Scripting

[rockssk]

Dear Folks,

My query is


i have a.sql , b.sql , c.sql files which needs to be executed using "$ db2 -tvf a.sql"; "$ db2 -tvf b.sql"; "$db2 -tvf c.sql" , can some one suggest me a script with which i can execute all these sql files in a single shot.

[Kloschüssel]

for i in *.sql; do db2 -tvf $i; done

[a.ti]

Hi!

in a shell you can try:

find . -name *.sql -exec db2 -tvf {} \;

[rockssk]

thanks guys it worked out

[Kloschüssel]

you're welcome. please mark it as [SOLVED].