load data into a table
Posted in 1999
Topics: Migration, Import/Export & Data Conversion
Roger Charles Coles — — source: Informix-list mailing list archive (1991-1998)
I prepared data in text format. How can I load these data into a table? I am using informix 5. How to unload the data from a table? Thanks Kenneth
↪ replying to Roger Charles Coles
John-Thomas Richards — — source: Informix-list mailing list archive (1991-1998)
Roger Charles Coles wrote in message
<7b5h6a$q6r$1@imsp009a.netvigator.com>...
>I prepared data in text format. How can I load these data into a table?
>I am using informix 5.
>
This is straight from the dbaccess help screen:
LOAD FROM "pathname" [DELIMITER "char"] INSERT INTO table-name
>How to unload the data from a table?
Again, from the dbaccess help screen:
UNLOAD TO "pathname" [DELIMITER "char"] SELECT-statement>
>
>Thanks
>
>Kenneth
>