Re: Suppressing output from ISQL statements and LOAD in ESQL

Have you try this in your script: isql database sqlfile > screendump 2>&1 Susik ______________________________ Reply Separator _________________________________ >Subject: Suppressing output from ISQL statements and LOAD in ESQL >Author: INTERNET:kcj@alice.walrus.com at CSERVE >Date: 6/21/96 8:06 AM > > >Sender: informix-list-owner@rmy.emory.edu >Received: from rmy.rmy.emory.edu (rmy.rmy.emory.edu [170.140.97.4]) by >arl-img-7.compuserve.com (8.6.10/5.950515) > id JAA19381; Fri, 21 Jun 1996 09:04:29 -0400 >Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id >JAA05602 for susik_lee@united#u#group.ccmail.compuserve.com; Fri, 21 Jun 1996 >09:04:51 -0400 (EDT) >From: kcj@alice.walrus.com (Kate Juliff) >Message-Id: <4qcepl$aq8@walrus1.walrus.com> >Subject: Suppressing output from ISQL statements and LOAD in ESQL >Date: 20 Jun 1996 17:11:17 -0400 >Reply-To: kcj@walrus1.walrus.com >Organization: Intellitech Inc >Sender: informix-list-owner@rmy.emory.edu >To: informix-list@rmy.emory.edu >X-Informix-List-To: susik_lee@united#u#group.ccmail.compuserve.com >X-Informix-List-Id: <news.25234> I'm using ISQL vers 6.0 running under SCO UNIX 3.4. I have a UNIX script that calls an ISQL script that contains the statement LOAD FROM filename INSERT INTO tablenameI get the output "x rows loaded" which I want to suppress. So... I tried the -s option, and I still get the screen output. Then I tried redirecting the output from the UNIX script. Nogo. So I though I'd give up on this and write a short ESQL program to do the load. Unfortunately, "$load from filename insert into tablename works as expected in an ISQL script but brings up a systax error in ESQL As all I need to do is suppress output, can someone advise? Thanks in advance, Kate