Archives of the TeradataForum

Message Posted: Wed, 25 May 2005 @ 16:07:21 GMT

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

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