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

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