Archives of the TeradataForum

Message Posted: Wed, 16 Mar 2011 @ 08:35:14 GMT

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

Hi Anomy,

Use the sql query as below format to get delimited data. Please revert back if you need more information.

     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;

Thanks and Regards

Kiran

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