Re: START REPORT X TO PIPE Y ?

The report is not processed in memory, so that's not a problem. If the report consistently can be sent to a file there should also not be a problem with temporary space (in the dbms or in the file system) for sorting (if you use order by, not order external by or no ordering). It may still be that you have this temporary space problem only sometimes. You should however get some kind of a runtime error message in this case. I haven't had it for so long that I don't remember that part for sure. You may however have a problem with enough space in your spool directory. The runtime system doesn't handle this very well, so it may look like the report is finished normally, but the spooler have crashed. You should however get an os error from this. Something about some device beeing full. Even if not it should be easy enough to check this while the report is running. On Wed, 25 Feb 1998 17:55:45 PST, "SH Lim" <sweehock@hotmail.com> wrote: > >Yup. There is a finish report later in the code. I've managed to >completed the report to a output file first and it's over 20 MB in size. >Would there be an intermediate file in my OS or is temdbs used or the >report is processed in memory ? >Can anyone help pls. > >>From jleffler@visa.com Tue Feb 24 08:14:39 1998 >>Subject: RE: START REPORT X TO PIPE Y ? >>Date: Tue, 24 Feb 1998 08:15:05 -0800 > >> >>Did you do 'FINISH REPORT X' too? >>If not, then you wouldn't necessarily get any output... >> >>Yours, >>Jonathan Leffler (jleffler@visa.com) #include <bother.ms-exchange.h> >> >> >>---------- >>From: SH Lim[SMTP:sweehock@hotmail.com] >>Sent: Monday, February 23, 1998 10:47 PM >>To: informix-list@iiug.org >>Subject: START REPORT X TO PIPE Y ? >> >>Hi ! >> I've a problem. My backgroud report process identified with : >>ps -ef | grep myreport.exe >>completed (as the process ends) but my report does not come out. This >>report has been successfuly printed many times. >> >> I figure it could be a problem with my storage. I'm just not sure >>where to look when I do a TO PIPE (file system (?), temdbs or ?) : >>Please feel free to comment. >> >>LET pr_path= "lp -d ", queuename CLIPPED, " > /dev/null" >>... >>. >>START REPORT print_report TO PIPE pr_path >> >>Thanks. >>SH >> >>______________________________________________________ >>Get Your Private, Free Email at http://www.hotmail.com >> > > >______________________________________________________ >Get Your Private, Free Email at http://www.hotmail.com Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com