Archives of the TeradataForum

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

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

<-- 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>>