Oninit cdi / Archive
Talk to an expert →

Re: How to create a output file from stored proced

Posted in 2007

Topics: Stored Procedures & SPL, Java & JDBC Development, Versions, Editions & End-of-Life

ART KAGEL, — — source: IIUG Forums & Mailing Lists

Not using SPL or pure SQL. IFF you have IDS 9.xx or later you could write a set of UDRs (aka a Bladelet) in C or Java to create a file, open it for output and write to it. If you do so consider posting the Bladelet code to the IIUG Software Repository for others to use. Art S. Kagel ----- Original Message ----- From: Xu Naizhong <ids@iiug.org> At: 4/12 0:15:26 Hi, can this be done in informix and make the filename variable? Thanks! ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to ART KAGEL,
Guy . — — source: IIUG Forums & Mailing Lists

Or use a Stored Procedure SYSTEM command - either pass the filename to an external program which creates it or directly use the ">" ">>" shell redirectors to output to the named file. e.g. LET filename = 'myfile'; ... SYSTEM 'echo ' ||var1 || ' > ' || filename; ... Guy ----- Original Message ---- From: "ART KAGEL, BLOOMBERG/ 731 LEXIN" <kagel@bloomberg.net> To: ids@iiug.org Sent: Thursday, April 12, 2007 6:05:52 AM Subject: Re: How to create a output file from stored pr.... [8853] Not using SPL or pure SQL. IFF you have IDS 9.xx or later you could write a set of UDRs (aka a Bladelet) in C or Java to create a file, open it for output and write to it. If you do so consider posting the Bladelet code to the IIUG Software Repository for others to use. Art S. Kagel ----- Original Message ----- From: Xu Naizhong <ids@iiug.org> At: 4/12 0:15:26 Hi, can this be done in informix and make the filename variable? Thanks! ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ________________________________________________________________________________ ____ We won't tell. Get more on shows you hate to love (and love to hate): Yahoo! TV's Guilty Pleasures list. http://tv.yahoo.com/collections/265

Glossary