Skip to Content

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

how to select and compare long data from maxdb

I have sap and java db. I try select data from table with this request

sql_execute SELECT * FROM SAPPOPDB.T_CHUNK where T_CHUNK.CHUNK_DATA < '10000'

but got this response

-24988,ERR_SQL: SQL error

-7032,SQL statement not allowed for column of data type LOB

db structure

DOMAIN_HASH KEY NUMBER  10  0  SEL+UPD+   0   1   1   25.04.2014  17:31:17   25.04.2014  17:31:17

DOMAIN_COUNTER  KEY NUMBER  10  0  SEL+UPD+   0   2   2   25.04.2014  17:31:17   25.04.2014  17:31:17

SESSION_HASH  KEY NUMBER  10  0  SEL+UPD+   0   3   3   25.04.2014  17:31:17   25.04.2014  17:31:17

SESSION_COUNTER KEY NUMBER  10  0  SEL+UPD+   0   4   4   25.04.2014  17:31:17   25.04.2014  17:31:17

CHUNK_NAME  KEY VARCHAR UNICODE 200  SEL+UPD+   5   5   25.04.2014  17:31:17   25.04.2014  17:31:17

CHUNK_DATA OPT LONG BYTE SEL+UPD+   6   25.04.2014  17:31:17   25.04.2014  17:31:17

please help how I can get CHUNK_DATA from table?

DB - MaxDB Thank you

Tags:
Former Member

Helpful Answer

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