Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 01 Mar 2007 @ 02:04:26 GMT

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

Subj:   Re: Multiple record types using mload
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, February 28, 2007 19:00 -->

MultiLoad won't do this. APPLY is intended to let you execute different SQL statements (possibly modifying different tables), not to handle different input record layouts.

If the records are all the same length (for fixed length) or same number of fields (for variable length) you may be able to make this work with overlapping definitions in LAYOUT. Don't forget to reset column position back to 1 or whatever when you start a different group.

But different length / different number of fields - forget it. Find another way.

  <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: 28 Jun 2020