create function to unload data
nasiha zailan asked whether a function could loop to unload data. Andreas Legner and Art Kagel explained UNLOAD is a dbaccess command, not server SQL, so it cannot be used in a stored procedure. They suggested external tables, with the procedure doing SELECT ... INSERT INTO an external table. Davorin Kremenjas and Doug Lawry added links to non-blocking export and unload FAQ pages.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi, anyone here knows if i can create function that can loop to unload data? since as far as i know, stored-procedure cannot do the looping for unload data. Thanks ------------------------------ nasiha zailan ------------------------------
In case you're talking UNLOAD statement, that's not going to fly since UNLOAD is pure dbaccess syntax, i.e. only dbaccess understands and handles it, not the server.
I think you could use "external tables" for your purpose, though.
------------------------------
Andreas Legner
------------------------------
https://docs.deistercloud.com/content/Databases.30/IBM%20Informix.2/Tips/Non%20blocking%20DBExport.xml?embedded=true ------------------------------ Davorin Kremenjas ------------------------------
Yes. You can unload data using a stored procedure. You just cannot use the UNLOAD verb since that is not an SQL command but a dbaccess built-in command.
You can create an external table and have the proc copy data to that with a simple
SELECT ... FROM source_table
INSERT INTO external_table;------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
------------------------------
https://www.oninitgroup.com/faq-items/load-and-unload-functions This e-mail (and any files or other attachments transmitted with it) is intended solely for the attention of the addressee(s). Unauthorised use, disclosure, storage, copying or distribution of any part of this e-mail is not permitted. If you are not the intended recipient please destroy the e-mail, remove any copies from your system and inform the sender immediately by return. Oninit Consulting Ltd does not accept any liability or responsibility for any damage caused by any malware transmitted by this e-mail or for changes made to this e-mail after it was sent. All communications to or from Oninit Consulting Ltd may be automatically logged, monitored and/or recorded in order to secure the effective operation of the system and for other lawful purposes. The views or opinions contained within this e-mail may not necessarily reflect those of Oninit Consulting Ltd.