Archives of the TeradataForum
Message Posted: Fri, 08 Nov 2002 @ 08:30:21 GMT
My original problem was how to store a large file (BLOB a binary large object) into a Teradata table using BTEQ.
My original code to create the table was correct:
BTEQ code for the table:
create table filedb ( piece varbyte(32000) );
But the code for storing the data the varbyte should be just byte. So instead of:
using piecex (varbyte(32000))
using piecex (byte(32000))
.import data file = data using piecex (byte(32000)) insert into filedb ( piece ) values ( :piecex ); .quit
Also when I was creating the data file the first two bytes are the length of the data and the last character in the file data is a LF. I had the length and the LF at the end of the data file but I had the low/high bytes for the data length switched.
Thanks to Kuroda Akira from NCR Japan for helping solve my problem!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|