Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 15 Mar 2011 @ 16:09:44 GMT


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


Subj:   Error on FastExport Query Execution
 
From:   Anomy.Anom

Hi,

Can any one help me out ,how to make a delimited flat file for FastExport Job

I have made the Fast Export Command as

     Export Outfile Fastout
     Mode Record Format text  , ;


     000001 .LOGTABLE   S61_CSY579_TABLES.VP6111_EXPORT_LOG;
     000002 .BEGIN EXPORT;
     000003 .EXPORT OUTFILE FASTOUT
     000004  MODE RECORD FORMAT TEXT;
     000005 SELECT
     000006 CAST(COALESCE(CAST(CUST_ID AS CHAR(10)),'9999999999')AS CHAR(10))
     000007 ,CAST(COALESCE(CAST(CUST_NAME AS CHAR(20)),'XXXXXXXX')AS CHAR(20))
     000008 ,CAST(COALESCE(CAST(CUST_JOINING_DATE AS CHAR(10)),'3500-12-31')
     000009 AS CHAR(10))
     000010 ,CAST(COALESCE(CAST(CUST_SALARY AS CHAR(08)),'9999.99') AS CHAR(08))
     000011 ,CAST(COALESCE(CAST(CUST_ACCOUNT_ID AS CHAR(10)),'9999999999')
     000012 AS CHAR(10))
     000013 ,CAST(COALESCE(CAST(MAX_SUM AS CHAR(08)),'99999999')AS CHAR(08))
     000014 ,CAST(COALESCE(CAST(PART_VALUE AS CHAR(05)),'99999')AS CHAR(05))
     000015 ,CAST(COALESCE(CAST(GRAND_SUM AS CHAR(08)),'99999999')AS CHAR(08))
     000016 FROM TEST.EXP_TABLE;
     000017 .END EXPORT;
     000018 .LOGOFF;

But it is throwing error while submitting this from Mainframe


Thanks



     
  <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: 27 Dec 2016