Archives of the TeradataForum
Message Posted: Thu, 17 Jun 2004 @ 08:55:00 GMT
| Subj: | | Re: Fastexport manual inconsistency |
| |
| From: | | Dieter Noeth |
John Mansfield wrote:
| | Fair comment. I am in fact running the script on windows. Should the manual not make it clear that the file will be fundamentally
different depending upon what platform the extract is run? Perhaps going so far as to detail what those differences might be. | |
ACK.
At least in "Attributes of the Destination File" of the EXPORT command it says:
"The Teradata Database data types in the VM and MVS environments are described in Table 3-3 on page 3-22."
| | Perhaps today I will spend the day trying to infer how dec(18,2) fields might actually be packed. | |
It's a 8 byte integer with a sclae factor of 100, i.e. 12345.67 is stored as 1234567
In "SQL Ref. Data Types and Literals" the external representation of data types is explained.
Dieter
| 
