Archives of the TeradataForum
Message Posted: Thu, 11 May 2006 @ 14:50:43 GMT
We are in process of moving an application from Oracle to Teradata, but ran into issues on one of the tables which has a CLOB column in it.
To do a trial test run can anyone please send a sample bteq script, created a Test table like below. Wanted to try and do a test run to load an XML/Text file into this and see if it works as the first step.
CREATE SET TABLE RBClobTestA ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, DATABLOCKSIZE = 130560 BYTES, FREESPACE = 20 PERCENT, CHECKSUM = DEFAULT ( CLOBCOL CLOB(2097088000) CHARACTER SET LATIN, ID INTEGER) PRIMARY INDEX ( ID );
With your prior experiences does anyone have any tips/suggestions/thoughts while we do this?. Thanks in advance.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|