Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 04 Apr 2001 @ 07:17:50 GMT


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


Subj:   Re: Column Headers with Fast Export
 
From:   Michael Larkins

Hi Chris:

FastExport and most of the Teradata utilities do not care about column headings. They are only concerned with positional fields of data.

If you are attempting to use the column headings for a PC spreadsheet, you might want to use BTEQ. It has the ability to export a DIF (Data Interchange Format) file. This file format is compatible with all the major PC spreadsheet programs (ie. Excel, Lotus, etc).

It does not look like a standard file, because it is not. Instead, it defines tuples and various other "record" types to define the cell location of each piece of data. The column heading are included.

To use:

.export DIF file=


Hope this helps you along your way,

Michael Larkins



     
  <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