 |
 |
Archives of the TeradataForum
Message Posted: Mon, 10 Oct 2005 @ 15:19:27 GMT
| Subj: | | Re: Equivalent of DB2's BIGINT in Teradata |
| |
| From: | | Victor Sokovin |
| | Actually, I need to download data from the DB2 table and then fastload it into the Teradata table. I tried using the DECIMAL(18) option in
the fastload where i defined the BIGINT data of the input file as DECIMAL(18). It couldn't read the data properly as DECIMAL(18) read 10 bytes
and threw an error which said "Record too short by 2 bytes". | |
Strange. BIGINTs should normally be of length 8.
How do you export the data from DB2? It sounds like you might export it as CHARs with some code page byte added or something like that. Try to
inspect the exported file in any hex editor to verify the format and, if necessary, correct it. I think what you are looking for is 8 bytes per
BIGINT. The rest must go.
Regards,
Victor
| |
