Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 25 May 2005 @ 16:35:23 GMT


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


Subj:   Re: Fastload Problem: No room in database
 
From:   Babu_Gopal

No Narayan,

Everytime I will create the new table and I will populate and atlast I will union all the tables and I will populate it to final table. My Table Structure is

     CREATE SET TABLE TEMP_DB.LND_ABC_WALL_PROD ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL
          (
           EMP_TP CHAR(4) CHARACTER SET LATIN NOT CASESPECIFIC,
           SRVC_DTL_ID CHAR(13) CHARACTER SET LATIN NOT CASESPECIFIC,
           SEQ_NO CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC,
           TRFF_CD CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
           QN CHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC,
           RATE_CD CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC,
           S_AND_E_EFF_DT CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC,
           PCMS_PROD_CD CHAR(6) CHARACTER SET LATIN NOT CASESPECIFIC,
           SRVC_PROD_VL CHAR(8) CHARACTER SET LATIN NOT CASESPECIFIC,
           S_AND_E_CONFIG CHAR(60) CHARACTER SET LATIN NOT CASESPECIFIC,
           REMARK CHAR(15) CHARACTER SET LATIN NOT CASESPECIFIC,
           CCTIMESTAMP CHAR(26) CHARACTER SET LATIN NOT CASESPECIFIC)
     PRIMARY INDEX ( EMP_TP );


     
  <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