Can't this be done with a shell script instead of reading sql files from isql prompt?
I mean pool all the sql statements into a file and execute this consolidated sql file using isql command.That should serve our purpose for the time being.we can dig into this later.

Hi,

I have never seen the requirement of running one sql file from other sql file. We generally wrap up sql file in shell or perl script.
As Kishor suggested , combines all the statement in one file and run using -i option with isql.(-o for outfut fille)

Also try -e option, if you want to debug your sql file. Hope it help you!

Thanks.