RE: SQL Command-line.

IN REPLY TO: |------------------------------------------------------------| | 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 | -------------------------------------------------------------- In-Reply-To: <9795@emory.mathcs.emory.edu> maint72@saad-emh1.ARM- Y.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 Stuart, On page J-5 of the SQL manual the "Accessing FORM Menu Options" describes the command line syntax I suggested for the Unix Bourne Shell, as I stated it may not work with the Korn Shell. You are correct that the "-fr" will run the form as a whole, the "-fr" is "form-run" from the menu, however, if we substitute "-fr" for "-fq" we get "form-query" from the menu selection list and executed. By the way Stuart, I'm using ISQL v. 2.10.06E, on an Intel 310AP, with Xenix 3.0 (Intel version). Am I all wet, or are we maybe reading two different books with the same cover? Michael S. Gordon Foreman, Gyroscope Section Avionics Division * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Michael Gordon Sacramento Army Depot * * Foreman, Gyroscope Section Directorate For Maintenance * * E-Mail: maint72@saad-emh1.army.mil Attn: SDSSA-MAV-320 * * DSN: 839-2367 Michael S. Gordon * * Comm.: (916) 388-2367 Sacramento, CA 96813-5036 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *