Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 28 Feb 2007 @ 14:55:56 GMT

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

Subj:   Re: Error for .import with filter condition
From:   Michael Larkins


I do not believe I understand your latest question. But consider this:

1. you indicate that your file contains 14 different record types - each record type requires an identifier to know which fields to use in which tables and their respective location within the record

2. Mload has to read all the records in the file to know which ones are to be loaded via this script and which to ignore

3. a buffer is set up in memory for the longest record (defined by the LAYOUT) I am assuming that the extra characters are going to follow the data needed in our BIT record. Therefore the filler will be at the end of the LAYOUT

4. you can use the record redefinition to define multiple record types in the same LAYOUT to load up to 5 different types in the same script

5. the LAYOUT must accurately define the location, type and length for each FIELD being used in your SQL statement(s)

6. unused fields coming in should be ignored as FILLER (individually or as a single string when possible) or FIELDS must contain a number that represents the beginning location instead of the *

6. a single Mload can load up to a maximum of 5 tables using the IMPORT mode, therefore you need a minumum of 3 Mload scripts

I hope that one or more of these answer your question.


Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

  <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