Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 22 Jul 2004 @ 12:58:58 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: MLOAD of a file with multiple record types
From:   Michael Larkins


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

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019