<No Subject Supplied>

} From: root@TeamInfinity.com (root) } Subject: HOW in the HECK can we import comma quote delimted ASCII !!!???? } } 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. } } > Thanks in advance, } } root@TeamInfinity.com (Eric Sean Webber) >The Informix Guide to SQL Reference (9/92), pg 4-8 tells of the DBDELIMITER >env variable for use with dbload. I don't know if you can make it a >multi-character string, but it is worth a try. >If that doesn't work, then abandon the "WORLD STANDARD" and use the >"Informix Standard". :) > __________________________________________________________________ > | Clem Akins Standard Disclaimers Apply | > |Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" | > | Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com | > |________________________________________________________________| If you check further you will find that DBDELIMITER may be set to any SINGLE CHARACTER except the following: - Hexadecimal numbers (0 through 9, a through f, and A through F) - NEWLINE or Control-J - The Backslash symbal (/) DBLOAD can load delimited or non-delimiter text by defining the field or column offsets. This does require fixed length records or rows in the text file. Chuck Francis Is any "STANDARD" really standard?