All Forums Tools
ma255076 1 post Joined 11/14
03 Dec 2014
BTEQ issue with loading CLOB !

hello,
 
im kinda new to the tools, I got an issue running my BTEQ script with a ,CLOB column.
when I run it , I get "Teradata Database returned an invalid LOB token"
__________________

.IMPORT VARTEXT ';' LOBCOLS=1 FILE=GIS_SAMPLE.txt;

.QUIET ON

.REPEAT *

USING(

OBJECTID  VARCHAR (100),

 

 POINTSARRAY CLOB AS DEFERRED)

 

INSERT INTO Yaya.GIS_sample(

OBJECTID,

 

POINTSARRAY

)

 

VALUES (

:OBJECTID,

 

:POINTSARRAY

);

 

 

 

.quit;

 

___________________

 

 

Tags:
You must sign in to leave a comment.