HOW in the HECK can we import comma quote delimted ASCII !!!????
} 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 |
|________________________________________________________________|