BTEQ issue with loading CLOB !

Tools

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 (2)