Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 26 Nov 2004 @ 15:29:45 GMT


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


Subj:   Spooling a Teradata table to a text file using .EXPORT
 
From:   svijayko

I used to spool out an Oracle table using the following code:

     SPOOL $HOME/csm/dat/cs_vendor_cell_offer.dat
     COLUMN id_strategy    FORMAT A9
     column id_vendor_cell format A9
     column id_cross_sell format A8
     column id_offer format A9
     column num_priority format A9
     column num_days_between_offers format A9

     select
     lpad(id_strategy,9,' ') id_strategy,
     lpad(id_vendor_cell,9,' ') id_vendor_cell,
     lpad(id_cross_sell,8,' ') id_cross_sell,
     lpad(id_offer,9,' ') id_offer,
     lpad(num_priority,9,' ') num_priority,
     lpad(num_days_between_offers,9,' ') num_days_between_offers
     from cs_vendor_cell_offer
     order by id_vendor_cell, num_priority
     /
     SPOOL OFF

I am trying to achieve the same spool results with the TD version of the table. However, I am uable to achieve the same spool results. Can anybody help me?


Thanks

--Vijay


     help table cs_vendor_cell_offer;

     Column Name                    Type Comment
     ------------------------------ ----
     ---------------------------------------
     ID_STRATEGY                    I    ?
     ID_VENDOR_CELL                 D    ?
     ID_CROSS_SELL                  CF   ?
     ID_OFFER                       I2   ?
     NUM_PRIORITY                   I2   ?
     NUM_DAYS_BETWEEN_OFFERS        I2   ?


     
  <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