SQL Command line 2nd time.

TO: Cheryl Gross and Jack Parker the second time around. It seems that when I downloaded your respective message files into WordPerfect, added my coments, converted the WP document into ASCII text, and uploaded the file into the DDN system some very important characters were left out. I don't know exactly what happened, but it must have been a "stupid keystroke" on my part because we all know computers don't make mistakes! So, here we go a second time, however, because I don't trust this dumb machine I'm sending a Carbon Copy to my own mailbox to test the quality of this system. Sorry. Sorry. Sorry for the missed message. TO: Cheryl Gross and Jack Parker } Received: from rmy.emory.edu by saad-emh1.ARMY.MIL id aa26631; } 22 Oct 92 14:23 EDT } Received: by } rmy.rmy.emory.edu (5.65/Emory_rmy.3.3.20) via MAILPROG } id AA17394 ; Thu, 22 Oct 92 13:23:14 -0400 } Return-Path: ilist@rmy.emory.edu } Message-Id: <9210221651.AA14600@rmy.rmy.emory.edu> } Date: Thu, 22 Oct 92 11:10:13 CDT }From: Cheryl Gross <cheryl@redriverad-emh1.army.mil> }To: informix-list@RMY.EMORY.EDU }Cc: cheryl@redriverad-emh1 }Subject: isql to run a form }X-From: cheryl@redriverad-emh1.army.mil }Reply-To: cheryl@redriverad-emh1.army.mil }X-Office: ASQNC-DR-I }Dsn: 829-3518 }Sender: informix-list-owner@rmy.emory.edu }X-Informix-List-Id: <list.1541> } }ATTN: Michael Gordon } }We have 2 versions of Informix on our systems: 2.10.00B and 4.10.UC1 } }both will put you into the: } }FORM: Run Modify Generate New.... Exit screen when you type: } }isql -s databasename -fq formname } }isql -s databasename -fr formname { will run the form } } }isql -s databasename -frq formname { will run the form } } }but it will put you into the screen itself but will only be setting on Query }because it is the first option on the screen, all other options are available. Cheryl, You are correct by using the "-frq" switch, this will open the named form and place the user on the query menu. The user then has the full query command options including query statements. My fault for leaving out the "frq", thanks for catching the error and posting. } }I'm sure your version on the Intel is different and it would be nice if }our version would do what you state that yours does.. } } }Cheryl Gross }> }> }>Received: from rmy.emory.edu by saad-emh1.ARMY.MIL id aa05743; }> 22 Oct 92 14:45 EDT }>Received: by }> rmy.rmy.emory.edu (5.65/Emory_rmy.3.3.20) via MAILPROG }> id AA24778 ; Thu, 22 Oct 92 14:43:24 -0400 }>Return-Path: ilist@rmy.emory.edu }>From: Jack Parker <jparker@hpbs2776.boi.hp.com> }>Message-Id: <9210221812.AA01681@hpbs2776.boi.hp.com> }>Subject: Re: Isql to run a form }>To: informix-list@rmy.emory.edu }>Date: Thu, 22 Oct 92 12:12:19 MDT }>Sender: informix-list-owner@rmy.emory.edu }>Reply-To: Jack Parker <jparker@hpbs2776.boi.hp.com> }>X-Informix-List-Im }>isql from hte command line? Why don't y'all just try, }> }> sperform form_name ??? }> }>Is there something I'm missing here? }> }> j. }> }>_____________________________________________________________________________ }>Jack Parker - Contractor | }>Hewlett Packard, BSMC Boise, Idaho, USA| These don't look like opinions. }>jparker@hpbs2651.boi.hp.com | Are you sure they're mine? }>(208) 323-5388 (W) (208) 384-1623 (H) | }>_____________________________________________________________________________ Jack, The original question on the net from Al Parker was as follows: I want to be able to run a query and process the results from inside a ksh shell script by running the isql as a co-process through pipes. Your command line script will open the named form and leave the user at the first PERFORM MENU, but not at the QUERY MENU. Are there undocumented switches for "sperform"? 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 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *