Infoirmix- appending output to an existing file

[Krista A]

I'm trying to send output to an existing file in an Informix program using a cursor and a report... I know how to create a new file each time the program runs, but not to output to an already existing one... How would I do that?

[Peter Godron]

Welcome to the ITRC Forums,
may I suggest:
http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.dba.doc/dba74.htm
http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.dba.doc/dba72.htm

[Krista A]

Thanks, Peter,
But what I'm actually trying to do is in the code itself:

start report report3 to "output.out"
foreach datacurs into rpt_rec1.*
output to report report3(rpt_rec1.*)
end foreach
finish report report3

where rept_rec1 is defined in the actual report. I want the program to append to "output.out" each time it runs, instead of overwriting it with the new output each time it runs.

[Peter Godron · Accepted solution]

Sorry Krista,
misunderstood.

Could you please try:

START REPORT report3 TO PIPE "cat >> output.out"

If you are happy with the answer:
http://forums1.itrc.hp.com/service/forums/helptips.do?#28

[Krista A]

Thank you, Peter. Very helpful!