Re: OUTPUT and UNLOAD Statements

Posted in 2000

Sujit.Pal@bankofamerica.com — Tue, 22 Aug 2000 10:25:49 -0700 — source: Informix-list mailing list archive (1991-1998)

Jorge You cant use OUTPUT in a stored procedure because its not SQL, its a dbaccess extension. HTH Sujit "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: Subject: OUTPUT and UNLOAD Statements 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?