Re: uploading flag files

->From: davids@Software.Mitel.COM (David So) ->Subject: uploading flag files ->Date: 22 Jul 93 20:34:07 GMT ->Reply-To: davids@Software.Mitel.COM (David So) ->Organization: Mitel. Kanata (Ontario). Canada. -> ->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 Sounds like you need to look more closely at DBLOAD. DBLOAD gives you a great deal of control over the processing of your input, which can be in fixed or variable format. You can specify how frequently to commit inserts, the number of bad data records to process before aborting, whether or not to lock tables during loading, etc. The DBLOAD utility allows you to specify your delimiter character. You can also use the DBDELIMITER environment variable, which is referenced by all Informix program products, so far as I know. If you data is "quote and comma delimited", instead of just comma delimited, then you will need to preprocess it. Unlike dBASE and various spreadsheet programs, Informix will consider the quotes to be part of the data, rather than part of the delimiter. Regards, Alan ___________________________ ______________________| R. Alan Popiel |__________________________ \\ Internet: | Martin Marietta, Tech Ops | / \\ alan@den.mmc.com | P.O. Box 179, M/S 5422 | Std disclaimers apply. / )Voice: | Denver, CO 80201-0179 USA | ( / 303-977-9998 |___________________________| (But you knew that!) \\ /________________________) (____________________________\\