Archives of the TeradataForum

Message Posted: Sat, 10 Jul 2004 @ 20:38:51 GMT

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

Replace your SQL with the following. It concatenates the fields and delimiters into a singe field to be exported.

     SEL DT1.NPANXXX || ',' ||
         DT1.OWNER_MARKET_ID || ',' ||
         DT1.OWNER_CARRIER_ID || , ||
         DT1.OCN || ',' ||
         DT1.MARKET_TYPE (CHAR(44)) (TITLE '')
     FROM (SEL NPANXXX (FORMAT '9999999999') (CHAR(10))
             , OWNER_MARKET_ID  (FORMAT '9999999999')  (CHAR(10))
             , OWNER_CARRIER_ID (FORMAT '9999999999')  (CHAR(10))
             , OCN              (CHAR(4))
             , MARKET_TYPE      (FORMAT '9999999999')  (CHAR(10))
           FROM DBNAME.TableName) DT1;

--
Rob Paller
Teradata Certified Master

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