Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Tue, 02 Mar 2004 @ 22:16:27 GMT





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




Subj:   A Fast Export Issue
 
From:   Ganga Palakattil



The following Fast Export script produces the output given below:

How do I fix it to get comma-delimited ASCII output? I am running it on MP-RAS V2R5.0. Though I referred the archive and manual, none was so helpful in this.

Thanks in advance for your help...

SCRIPT:

.LOGTABLE obc_load.felog;

.LOGON sftddev/mdbload,mdbload1;

.BEGIN EXPORT

    SESSIONS 20;

.EXPORT OUTFILE /home2/td/sourcecode/obc/LERG.TXT;

SELECT * FROM OBC_LOAD.NPA_NXX_OUTBOUND;

.END EXPORT;

.LOGOFF;

OUTPUT:

   A=B4&   =E7   6246
   |=A5b   L   6664
   =FC=DAL       6246
   =AD[3   =B5   6300

Thanks

Ganga Palakattil





     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 23 Feb 2008