Insert in CLOB

Database
Lee
N/A

Insert in CLOB

Hello,

I have created a new table with a CLOB field intended to store a deliminated character string, however a standard INSERT statement is only loading the first character of said string.

Any thoughts or guidance as to why this is happening and how to fix please?

All input gratefully received.

Thanks,
Lee UK
Tags (2)
2 REPLIES
Teradata Employee

Re: Insert in CLOB

By using the import feature of SQL-Assistant, you are able to load clobs or blobs,
SQLA has parameter markers for blobs and clobs:
Insert Into Foo Values ( 'bar', ?B, ?C)

The ?B is a placeholder for blob, and ?C is a placeholder for clob
Lee
N/A

Re: Insert in CLOB

Many thanks for that, I will investigate.