 |
 |
Archives of the TeradataForum
Message Posted: Thu, 23 Jun 2005 @ 09:58:59 GMT
| Subj: | | Re: Updating a CLOB column |
| |
| From: | | Victor Sokovin |
| | I am trying to update a table with a CLOB (2GB) column called REPORT_TEXT with a text file that has 1.6 gigs of text data. The table has
two other character columns (REPORT_NUMBER, REPORT_TYPE). | |
| | I tried using BTEQ .IMPORT VARTEXT FILE with the .SET LARGEDATAMODE ON but received a file size exceeded message due to its 64K limit.
SQL ASSISTANT import did not work due to its 999,999 byte limit. | |
| | Any suggestions how this could be done using one of the Teradata client tools. | |
We had a thread on this a couple of months ago and as far as I can remember the conclusion was that the limits of 64K and 1MB can be overcome
only if you are prepared to do a low-level programming using API.
You should be able to find the thread in the recent archives.
Regards,
Victor
| |
