Archives of the TeradataForum
Message Posted: Thu, 30 Sep 2004 @ 15:44:49 GMT
| Subj: | | Re: Multiloading different length records |
| |
| From: | | Fred Pluebell |
No, you can't do this without a user-written INMOD or AXSMOD exit.
If you are not using VARTEXT format, MultiLoad requires that all records be at least as long as the largest LAYOUT. (If you are using VARTEXT,
MultiLoad requires that each record contain at least as many fields as the maximum for any LAYOUT.) Unless you set MATCHLEN=on option, you are
allowed to have extra bytes at the end of the records.
The only reason MultiLoad ignored the header record in your example is that all the IMPORTs specified "FROM 2", i.e. ignore the first record
regardless of what it is.
Also note that each IMPORT requires a separate pass of the input data, so even if you pad the records you probably want one LAYOUT with
multiple sets of FIELD definitions and one IMPORT with three APPLY ... WHERE clauses.
| 
