Re: ISQL Command-line Syntax.

In-Reply-To: <9795@emory.mathcs.emory.edu> maint72@saad-emh1.ARMY.MIL (Michael Gordon) In <9795@emory.mathcs.emory.edu> Michael Gordon [Stuff deleted] > In the Bourne Shell: > > Create the filename: test.query, make the file executable by > modifying it to RWXR_X___, that is Read-Write-Execute for you the > owner, Read-_-Execute for your group, and None for all other > users. > > Open the file with the VI Editor or some other ASCII text editor > and enter the following script. > > isql -s database_name -fq form_name <return> > > The "-s" is the silent option which strips out the informix > headers in the screen. > > The "-f" calls the perform options from the normal perform menu, > in this case the "query" option. > > The form_name is the name of the perform file you wish to run. > > When the query is finished and the form is exited the terminal > will be returned to the previous task prior to running the shell > program. [More stuff deleted] I'm not sure what version Michael's using but I don't believe this will work. You can't call the query option from the command line. The closest you *can* get is isql -s <dbname> -fr <form>. The -s and -f are as Michael said. The -r just *runs* the form. Hope this helps -------------------------------------------------------------- | Who cares whos opinions these are?! | | Send me mail and I'll love you forever (Maybe) | |------------------------------------------------------------| | Stuart Hemming | shemminga@cix.compulink.co.uk | | Tudor Labels Ltd | uunet!cix.compulink.co.uk!shemminga | | Roman Bank Bourne | Tel : (+44) 778 426444 | | Lincs PE10 9LQ. UK. | Fax : (+44) 778 421862 | -------------------------------------------------------------- Stuart |8-)