Re: How to "load" a table without getting screen messages

At 01:34 PM 6/21/96 -0400, Kate Juliff wrote: >I've posted to this group trying to find out how to suppress results of >ISQL "queries" going to the screen. I have received a number of helpful >answers re. redirecting to stderr and stdout. Unfortunately this cannot >work. Puzzled as to why it didn't I called INFORMIX tech support. They >confirmed that it cannot be done. Also that I cannot "LOAD" a table from >a file using "LOAD" in ESQL as it is not supported. > >All I need to do is load a table from a file and to suppress any screen >messages. Is there anyway of doing this, bearing in mind the messages >cannot be redirected using UNIX redirect and that ESQL does not support >the "LOAD" statement. If you have a shell script (say "loadfoo.sh") which says something like: isql dbname <<! LOAD FROM "/u/fred/foo" INSERT INTO bar;! You should be able to catch the output by doing something like: nohup loadfoo.sh & This should write *all* output to a file called "nohup.out" in the local directory. Make sure everybody who needs to has write permission on the file. So, once again elegance and class lose out to my brute ignorance! :-) >PS The tech support person at INFORMIX said to call them if I find a >workaround. Bloody cheek! :-) Hasta la vista! -- Billy Wheeler -- Director, The West Solutions Group (E) billy@west.co.za (W) +27 11 803 2151 (F) +27 11 803 2189 (C) +27 83 250 2324 (H) Forget it, my wife will kill me! :-) "...but apart from that, Mrs Kennedy, how was the parade?"