Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 14 Jul 2004 @ 15:09:33 GMT


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


Subj:   Re: Syntax to associate multiple tables to worktable/errortables in teradata
 
From:   Michael Tarajos

You can have as many tables as needed in an mload, just make sure the WT, ET, and UV tables are paired.

For example:

     BEGIN IMPORT MLOAD
            TABLES          &DB_SR_LINE,
                            &DB_ITIN_CPN,
                            &DB_PYMT,
                            &DB_TKT

            WORKTABLES      &DB_SR_LINE_WT,
                            &DB_ITIN_CPN_WT,
                            &DB_PYMT_WT,
                            &DB_TKT_WT

            ERRORTABLES     &DB_SR_LINE_ET
                            &DB_SR_LINE_UV,
                            &DB_ITIN_CPN_ET
                            &DB_ITIN_CPN_UV,
                            &DB_PYMT_ET
                            &DB_PYMT_UV,
                            &DB_TKT_ET
                            &DB_TKT_UV

            AMPCHECK ALL
            SESSIONS 16

The comma placement is critical to getting mload to work properly.



     
  <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: 15 Jun 2023