Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Windows-based Fast Export Script
 
From:   Rob Paller

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016