Archives of the TeradataForum

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

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

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