Re: Non-compiled SQL Scripts?

Billy Wheeler wrote: > > It appears that 4GL and ESQL/C are both compiled languages. I need to able > > to send the SQL statements as text files and have them executed (via > > something like dbaccess or isql, from the command line) without any > > compilation procedures. Is this possible? > > Yep. Place your SQL commands in a text file, say do_it.sql. Then, > from the command line run: > > dbaccess yourdbname do_it Or better yet, just pipe your commands in (if you don't want to prepare them ahead of time into a text file): $ echo "select blah, blah, blah from blah" | isql yourdbname -- ----------------------------------------------------------------------- Daniel James - Database Administrator djames@statsci.com DAPD Div of MathSoft (formerly StatSci) (206) 283-8802 x284