Skip to Content
0
Former Member
Aug 21, 2015 at 03:28 PM

how to select and compare long data from maxdb

41 Views

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