Hi! I seem to experience a small problem with legacy SQL code I'm trying to use. Synthetic stripped down test-example is as follows.
Imagine this small table: create table test (id integer, binaryValue long byte) You can leave it empty to test: SELECT DISTINCT id FROM test WHERE id IS NOT NULL <works> SELECT DISTINCT id FROM test WHERE binaryValue IS NOT NULL <doesn't work> Any ideas around how to rewrite this to check for non null values for the blob but still maintain the distinct id. The result code says, that this query is not supported with the type long byte. Changing the type of the column is an option, but are there any other suitable blob typings? Any "split it up" suggestions? Cheers, Martin -- Martin G�llnitz Technical Lecturer fon +49.40.325587.221 fax +49.40.325587.999 [EMAIL PROTECTED] CoreMedia AG Ludwig-Erhard-Stra�e 18 D-20459 Hamburg, Germany www.coremedia.com CoreMedia - Smart Content Technology _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
