|
|
Archives of the TeradataForum
Message Posted: Tue, 15 Mar 2011 @ 16:09:44 GMT
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
| |