Re: command line instead of isql

Jason P. Williams wrote: > > Hello. I am new to Informix, and have somewhat limited experience using > databases in general. The work I have done has been using Oracle's sql > plus, but I have recently been asked to do some work in Informix. So far, > I have only been able to use the interactive sql editor. It has some > nice features, but I need to get some things done rather quickly and > would much rather use a command line right now. Is this possible? You don't say which OS, but if your talking Informix on UNIX, then anything's possible! ;-) You can edit a file with the '.sql' suffix and execute it as follows: dbaccess database script OR isql database script if you have Informix-SQL In fact the file need not have the '.sql' suffix: dbaccess database <script Or you can make use of UNIX and try: dbaccess database <<-! your sql commands ! Remember, syntax checking only occurs when you type the '!'. Hope this helps, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+