Re: Suppressing output from ISQL statements and LOAD in ESQL

In article <4qcepl$aq8@walrus1.walrus.com>, our once-again-working newsfeed reveals that Kate Juliff <kcj@walrus1.walrus.com> wrote: >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 tablename>I 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. Really? That's odd. Make sure you are redirecting stderr as well as stdout. >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 LOAD is not an SQL statement; it's a tool utility with SQL-like syntax. It can be used only from the tools products (ISQL, the 4GL products) and dbaccess. >Thanks in advance, >Kate -- (c) 1996 Alan Denney aland@informix.com July 1995: French President Jacques Chirac awards the Grand Officer of the Legion of Honor, France's second-highest military order, to Major General Jean-Claude Lesquer for commanding the troops that sank the Greenpeace ship "Rainbow Warrior" in Auckland, New Zealand in 1985.