how to select and compare long data from maxdb

[Former Member]

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

[vijay_kumar49 · Accepted solution]

try this

SELECT e.ename, d.dname FROM emp e, dept d WHERE e.deptno = d.deptno AND e.sal < 1000;

[Former Member · Accepted solution]

Thanks, but I do not understand how to alter it under my inquiry

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

[vijay_kumar49 · Accepted solution]

SAPPOPDB is it Table Name?

CHUNK_DATA is it ColumnName?

T_CHUNK --- what is this?

[Former Member · Accepted solution]

SAPPOPDB  - db name

CHUNK_DATA  - data in lob type (

example ACED000573720051636F6D2E7361702E656E67696E652E73657276696365732E656A62332E666163616465732E696E7465726E616C2E696D706C2E7365727665

)

T_CHUNK - table name

[vijay_kumar49 · Accepted solution]

Please reffer this SAP Library - Messages