|
|
Archives of the TeradataForum
Message Posted: Thu, 17 Feb 2005 @ 16:37:16 GMT
Subj: | | Re: MultiLoad With VARTEXT/Delimited Input File |
|
From: | | Dieter Noeth |
Jackson Price wrote:
| Does anyone have a readily available example MultiLoad script that uses VARTEXT format to load a delimited flat file (e.g., pipes or
commas). | |
| (I have always used FORMAT TEXT to load fixed-width, non-delimited ASCII text). | |
It's simple:
- replace "FORMAT TEXT" with "FORMAT VARTEXT 'delimiter'"
- every FIELD/FILLER is a VARCHAR(x) instead of CHAR(x) :-)
Dieter
| |