Archives of the TeradataForum

Message Posted: Wed, 10 Aug 2005 @ 11:11:15 GMT

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

Michael,

Thanks for your help.

When I used DIF in export it is exporting data in below pasted form

     -1    0
     EOD

     TABLE

     0    1


     VECTORS

     0    16


     TUPLES

     0    12


     LABEL

     1    1
     transid

     LABEL

     2    1
     divisionname

     LABEL

     3    1
     unitnum

     LABEL

     4    1
     transenddt

     LABEL

     5    1
     transendtime

     LABEL

     6    1
     cashierid

     LABEL

     7    1
     postrmnlid

     LABEL

     8    1
     POSTRMNLtypeDESC

     LABEL

     9    1
     netsalesamt

     LABEL

     10    1
     taxamt

     LABEL

     11    1
     bsktdiscamt

     LABEL

     12    1
     dtlnetsalesamt

     LABEL

     13    1
     dtlnonwgtsalesqty

     LABEL

     14    1
     dtlwgtsalesqty

     LABEL

     15    1
     total_qty

     LABEL

     16    1
     hdraverageamt

     SIZE

     1    20

Is there any work around to display data with column heading and column values below it as pasted below

     divisionname                                            unitnum
     TRANSENDDT
     x                                                                 4
     20050325
     y                                                    95
     20050325
     z                                                    91
     20050325

Still some values are displayed in exponential like 3.176E+17

Thanks,

Vijay.

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