Re: uploading flag files

David So writes: >Informix has export/import/load/unload facilities. > >However, does it have any utility to upload an external flat file >such as a data file with comma as a delimiter; and also >provide us control of loading? > >thanks/david >-- >David Y. So >Mitel Corporation Phone: 613-592-2122 x3018 >350 Legget Drive, Kanata Fax : 613-592-4784 >Ontario, Canada K2K 1X3 Email: david.so@Software.Mitel.COM There are several metodes to upload from an external flat file. The most flexible is proberly to use the "dbload" utility (which comes with the db-engine). RTM However if your flat file has comma as delimiter and has a fixed number of fields per line it's more easy to use the ISQL command "load". You just set the environment varible DBDELIMITER="," or use the delimiter clause in your load-statement - fx. LOAD FROM "foo.txt" DELIMITER "," INSERT INTO fooHowever make sure that your input file hasn't "\\" "," (your delimiter) or newline (as a part of your date) in it. If is has - precede them with "\\". Hope that the above is a lead, but if you has more questions please state which Informix tools you have. -- ----\\ Pro Informatic Aps. Niels Berner <berner@proinf.dk> | O | Jagtvej 111A, DK-2200 Copenhagen N. Denmark +-|-/ Phone: +45 35 82 36 36 Fax: +45 35 82 36 37 | | #include <disclaimer.h>