Re: Non-compiled SQL Scripts?

Joshua Here's how I do something similar to what you describe: name=`isql - - 2>/dev/null <<!; database namebase; select login from uprofile where login="$LOGNAME";!` Of course, I'm running this from within a shell script and not using a text file but those changes should be easy to make. HTH Mark Stannard Ameritech Indianapolis, IN 46204 On Thu, 17 Apr 1997, Joshua D. Molaver wrote: > I have just begun working with Informix Online v.5 under SCO, and am > seeking some advice. > > I have been investigating the 4GL and ESQL/C packages. I want to send a > series of SQL statements (inserts, updates, and deletes) to a server and > have them executed as a transaction. I also need to be able to detect and > respond to an error condition. > > 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? > > Thanks... >