Re: 4GL Question
Posted in 1997
Topics: Stored Procedures & SPL, Connectivity: ESQL/C, 4GL & Embedded SQL, Migration, Import/Export & Data Conversion
aa@triad.com wrote in message <882228581.1224081414@dejanews.com>... >I'm writing a 4GL program in which I need to write the output to a text >file. What is the best way to do this. I need to be able to write the >output to a specific file name ( specified within the program). I cannot >use an SQL unload statement due to program constraints. > >I am currently using the display statement and then piping the output to >a file. > >Please also respond via email > >Thanks. > >Arun hi , try using the report routines Hope that helps Cheers from the sunny Australia Ralf Peters {Leadership is action not position } MAIN DEFINE x RECORD f1 ... f2 .... f3 .... END RECORD START REPORT rep1 TO /usr/informix/rep1.txt ..... .....{ populate record x } ..... OUTPUT TO REPORT rep1(x.*) FINISH REPORT rep1 REPORT rep1(y.*) DEFINE y RECORD f1 ... f2 .... f3 .... END RECORD ON EVERY ROW PRINT y.f1,",",y.f2,",",y.f3........... END REPORT > >-------------------==== Posted via Deja News ====----------------------- > http://www.dejanews.com/ Search, Read, Post to Usenet