Archives of the TeradataForum

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

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

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>>