Archives of the TeradataForum

Message Posted: Thu, 22 Jun 2006 @ 14:54:41 GMT

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

Hi,

Still facing problem in data file when doing fast export..

The table structure and fastexport query is as follows..

     sel
     (COALESCE(Trim(Cast(Account_Num_Formatted          as Char(060))),''))||'|'
     ||(COALESCE(Trim(Cast(Account_Modifier_Num           as Char(060))),''))||'|'
     ||(COALESCE(Trim(Cast(Time_Period_Cd                 as Char(060))),''))||'|'
     ||(COALESCE(Trim(Cast(DBS_Agmt_Hist_Start_Dt  AS DATE FORMAT 'YYYY-MM-DD')), ''))||'|'
     ||(COALESCE(Trim(Cast(DBS_Agmt_Summary_Type_Cd       as Char(060))),''))||'|'
     ||(COALESCE(Trim(Cast(Currency_Cd                    as Char(060))),''))||'|'
     ||(COALESCE(Trim(Cast(DBS_Agmt_Hist_Amt              as Char(060))),''))||'|'
     ||(COALESCE(Trim(Cast(DBS_Agmt_Hist_End_Dt          AS DATE FORMAT 'YYYY-MM-DD')), ''))||'|'
     ||(COALESCE(Trim(Cast(Account_Num_BDW                as Char(060))),'')) (char(500))
     from DT_MART_CPMS_IN.CPMS_CBIN_IBALCE;


     CREATE SET TABLE DT_MART_CPMS_IN.CPMS_CBIN_IBALCE ,FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT
          (
           Account_Num_Formatted CHAR(45) CHARACTER SET LATIN NOT CASESPECIFIC,
           Account_Modifier_Num CHAR(18) CHARACTER SET LATIN NOT CASESPECIFIC,
           Time_Period_Cd CHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC,
           DBS_Agmt_Hist_Start_Dt DATE FORMAT 'YY/MM/DD',
           DBS_Agmt_Summary_Type_Cd CHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC,
           Currency_Cd CHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC,
           DBS_Agmt_Hist_Amt DECIMAL(18,4),
           DBS_Agmt_Hist_End_Dt DATE FORMAT 'YY/MM/DD',
           Product_Id CHAR(40) CHARACTER SET LATIN NOT CASESPECIFIC,
           DBS_Source_System_Id CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC,
           PARTY_HOST_NUM_LEGAL_ENTITY VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
           Account_Num_BDW CHAR(45) CHARACTER SET LATIN NOT CASESPECIFIC)
     PRIMARY INDEX ( Account_Num_Formatted );

original data is like this ...

     811010000019 CBIN D 2006-10-16 436 INR 0.0000         9999-12-31
     811010000019 CBIN D 2006-10-16 43 INR 91,487.0000 9999-12-31
     811010000019 CBIN D 2006-10-16 82 INR 0.0000         9999-12-31

In data file after fast exporting one of the value not getting before decimal point. This problem only if it is null (I mean if it not having any value).

     811210000019|CBIN|D|2006-11-09|43|INR|91487.0000|9999-12-31|IN_30100_CAC
     OR|30100|015|113346

     811210000019|CBIN|D|2006-10-16|82|INR|.0000|9999-12-31|IN_30100_CACOR|30
     100|015|113346

     811210000019|CBIN|D|2006-10-16|436|INR|.0000|9999-12-31|IN_30100_CACOR|3
     0100|015|113346

Please let me know the possible soultions for exporting..

Thanks for your help in Advance.

Raghu

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