Re: Importing flat files to database

Posted in 1999

Sujit.Pal@bankofamerica.com — Thu, 30 Dec 1999 09:57:08 -0800 — source: Informix-list mailing list archive (1991-1998)

aginsberg How about the Informix-SQL LOAD and UNLOAD? HTH Sujit aginsberg@safeconnect.net on 12/29/99 07:45:18 PM Please respond to aginsberg@safeconnect.net To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Importing flat files to database I have a flat file that is currently colon delimited (can be changed with regex easily). I need to import this flat file into a table. Is there a utility, or script that will do this for me? I've thought about just using coldfusion server with <cfloop> but that doesn't seem like it would be the best,or most efficient. Also, how would you go about exporting a database to a flat file that is delimited with some character? Any information, or references would be greatly appreciated. Sent via Deja.com http://www.deja.com/ Before you buy.