Re: HOW in the HECK can we import comma quote delimited ASCII !!!????

The version of SQLCMD which should be available in the c.d.i archives has load/unload modes which accommodate this 'world standard' format. I would suggest that the comma/quote delimited format is highly operating system specific -- namely for DOS and DOS-derivative systems. This is not the same as 'world standard', despite various people's assumption that it is, and desptie the undoubted popularity and wide-spread use of these O/S. To the best of my knowledge (flaky), ISO has not created any world standard for unload formats -- if it has, please quote the standard number. Most mainframe unload formats, for example, do not have any delimiters between fields (and sometimes not between the records either!), and often have implied decimal points. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >From: root@TeamInfinity.com (root) >Date: 14 Apr 1995 08:05:44 -0400 >X-Informix-List-Id: <news.13037> > >I cannot find out how to import comma quote delimited text into Informix >if my life depended on it. We looked at dbload and got it to work ONLY >after converting our comma quote delimited ascii text file to single >character limited ascii text with much labor. comma quote delimited >ascii is very much a standard data format. There MUST be a way to import >comma quote delimited text into informix, but I sure could not find it ! >See we are trying to import dbaseIII and paradox files into informix by >first converting them to the WORLD STANDARD of comma quote delimited ascii >text, but informix's dbload seems to only allow importation of ascii text >that is delimited with a SINGLE character. Please tell us this is NOT so.