Re: OUTPUT and UNLOAD Statements

Posted in 2000

mark.baumgartner@cardhealth.com — Tue, 22 Aug 2000 10:05:25 -0700 — source: Informix-list mailing list archive (1991-1998)

Jorge, You can run any SQL statement inside a stored procedure BUT for unload, load, and output statements you need to make a system call and run it through dbaccess (see SYSTEM command in SPL). Good Luck. "Jorge Arturo Gomez Baez (APM-ERP-Consultores)" <jagomez@apm.com.mx> on 08/22/2000 09:35:30 AM To: "'informix-list@iiug.org'" <informix-list@iiug.org> cc: (bcc: Mark Baumgartner/FOL/CDI/CHI/US) Subject: OUTPUT and UNLOAD Statements Fax to: How can I use the <OUTPUT TO file> or <UNLOAD TO file> Statements in a Store Procedure on IDS2000. CREATE PROCEDURE ProcRepo() Output to '/informix/TextFile.txt' Select field1 From tblTable1; END PROCEDURE; Displays "201: A Sintax Error has occurred". And Directly on DBACCESS: Output to '/informix/TextFile.txt' Select field1 From tblTable1; runs perfect. Someone knows what must I do?