"dbload" utility with comma-quote delimited input

Posted in 1999

Richard Auslander — Wed, 13 Oct 1999 19:36:41 -0700 — source: Informix-list mailing list archive (1991-1998)

Has anyone ever gotten this to work? It almost appears that dbload cannot handle a comma-quote delimited input file. Rich -- Richard C. Auslander Database Manager AirFlash, Inc. 1733 Woodside Rd., Suite #110 Redwood City, CA 94061 (650) 556-7928 www.airflash.com

↪ replying to Richard Auslander

Art S. Kagel — Thu, 14 Oct 1999 13:04:26 -0400 — source: Informix-list mailing list archive (1991-1998)

It doesn't. I believe that Jonathan Leffler's sqlcmd can load from such files. Alternatively you could write an awk or perl script to convert the file to basic single delimiter format (by stripping the quotes) which dbload DOES understand. Art S. Kagel Richard Auslander wrote: > > Has anyone ever gotten this to work? It almost appears that dbload > cannot handle a comma-quote delimited input file. > > Rich > -- > Richard C. Auslander > Database Manager > > AirFlash, Inc. > 1733 Woodside Rd., Suite #110 > Redwood City, CA 94061 > (650) 556-7928 > > www.airflash.com