Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 12 Jul 2004 @ 18:12:55 GMT


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


Subj:   Re: Windows-based Fast Export Script
 
From:   Ganga Palakattil

Hi Rob,

Finally, it is working...

Here is the output:

     3186139,73,1623,6208,0
     2536513,17,231,6246,1
     6464892,6,76,6664,1
     5036796,1,2,6246,1
     4072568,283,3208,6010,0

Here are the changes I made to the script:

     SEL TRIM(DT1.NPANXXX) || ',' || TRIM(DT1.OWNER_MARKET_ID) || ',' ||
         TRIM(DT1.OWNER_CARRIER_ID) || ',' ||
         TRIM(DT1.OCN) || ',' || TRIM(DT1.MARKET_TYPE) (CHAR(40)) (TITLE '')

     FROM (SEL NPANXXX (FORMAT 'ZZZZZZZZZ9') (VARCHAR(10))
             ,OWNER_MARKET_ID (FORMAT 'ZZZZZ9')  (VARCHAR(6)),

               OWNER_CARRIER_ID (FORMAT 'ZZZZZ9')  (VARCHAR(6)), OCN (VARCHAR(4)),

               MARKET_TYPE      (FORMAT 'ZZZZZ9')  (VARCHAR(6))

          FROM DBNAME.TABLE_NAME) DT1;

Thanks again for the help...

Ganga Palakattil



     
  <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: 23 Jun 2019