Re: UNLOAD

> Subject: UNLOAD > Date: Mon, 7 Nov 1994 11:51:00 +0000 > Reply-To: alexmc@biccdc.co.uk > > My Informix manuals refer to the Informix SQL command UNLOAD > but tell me nothing about how to use it or its syntax. > (I need it for the format to dbimport). > > Can anybody help? > > Thanks > -- > Alex McLintock [also alexmc@biccdc.co.uk] > Editor for the Project Galactic Guide (alt.galactic-guide) Number 6 Syntax is: unload into <filename> select ... ; where the select can have any features of the not-unloaded select statement. The converse operation is: load from <filename> insert into <tablename> [ ( col, ... ) ]; Note that the insert does not have a "values" clause. The optional column list is needed if the load file does not contain a data value for each column in the table, or if the data columns are in a different order from the table definition. Unnamed columns must accept NULLs. This syntax should be described in your SQL reference manual. Very early versions of Informix SQL did not support this functionality. Are you using really old software? Regards, Alan ___________________________ ______________________| R. Alan Popiel |__________________________ \\ Internet: | Martin Marietta, SLS | / \\ alan@den.mmc.com | P.O. Box 179, M/S 3810 | Std disclaimers apply. / )Voice: | Denver, CO 80201-0179 USA | ( / 303-977-9998 |___________________________| (But you knew that!) \\ /________________________) (____________________________\\