Archives of the TeradataForum
Message Posted: Thu, 22 Jul 2004 @ 12:58:58 GMT
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,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|