Archives of the TeradataForum
Message Posted: Thu, 22 Jul 2004 @ 12:58:58 GMT
| Subj: | | Re: MLOAD of a file with multiple record types |
| |
| From: | | Michael Larkins |
Madhukar:
If you truly have 5 different record types in your file, you do not need to use continueif. This option is used only if you have the same
record data in multiple inputs. This was handy when records could only be 80 bytes (punched cards) and you needed 100 bytes of data to perform
the maintenance operation. The first input had the first 80 bytes and the next 20 were on the next card with a code punched into a location that
indicated whether or not to "continue" "if" the code was set and then continue reading until all the needed bytes were available in the buffer.
It concatenates the input data on the end of the existing data in the memory buffer instead of overlaying it with new data.
If your individual records are separate, you need to define either a .field or .filler than can by referenced in your APPLY portion of the
.IMPORT to determine which .DML section to execute based on a code.
Hope this helps,
Michael Larkins
Certified Teradata Master
| 
