Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

CREATE TABLE WITH LOB COLOUMNS

I am trying to create tables with LOB (BLOB/CLOB) columns. I tried with this simple stmt in database studio,SQL editor:

CREATE TABLE TEMP(TESTC1 INTEGER, TESTC2 BLOB)

But i am getting this error:

Error Executing 'CREATE TABLE TEMP(TESTC1 INTEGER, TESTC2 BLOB NOT null)' [-4006] (at 42): Unknown domain name:BLOB.

Also when i am using the Database Studio wizard to create table i am not getting any LOB column option in the column definition.

Please help.

Regards

Raja

Former Member
Former Member replied

Hi,

LONG is known in 7.6, 7.7 and even 7.8 to have a longer time for changing it.

CLOB/BLOB is not known in 7.6.

I think, this will help with the decision.

Elke

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question