Archives of the TeradataForum

Message Posted: Thu, 11 May 2006 @ 14:50:43 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

Regards,

Raj

	<Prev	Next>		<<First	<Prev	Next>	Last>>