 |
 |
Archives of the TeradataForum
Message Posted: Thu, 02 Oct 2003 @ 07:59:18 GMT
| Subj: | | Re: BTEQ Export Syntax |
| |
| From: | | Dieter Noeth |
TeradataForum wrote:
| | I think I've seen this on the form before but can't find it in a hurry. | |
| | Using BTEQ Export (NOT FastExport), How do I format: | |
| | a Date field as Char (8), Format 'yyyymmdd' | |
>
| | a Decimal (10.2) field as Char (12), Format '-9(8).99' | |
.EXPORT REPORT ...
select
datecol (format 'yyyymmdd'),
decimalcol (Format '-9(8).99')
.EXPORT DATA ...
select
datecol (format 'yyyymmdd') (char(8)),
decimalcol (Format '-9(8).99') (char(12))
Dieter
| |
