I need to do a query involving the internal SAP tables for the BPM and I have the following problem with querying the BC_BPEM_EL_ENTRY table (the DB used is SAP's MaxDB):
As you can see there are a lot of binary columns. How can I query those columns in the WHERE clause of a SELECT query?
I thought that converting the binary columns to hexadecimal and querying against that would work but the HEX function doesn't seem to work although it's listed in the docs (http://help.sap.com/saphelp_nw74/helpdata/en/44/d9ca62b7f74427e10000000a155369/content.htm)
I did a very simple test query but I get an error:
Exception of type com.sap.sql.log.OpenSQLException caught: The SQL statement "SELECT HEX(PROC_DEF_ID) FROM BC_BPEM_EL_ENTRY " contains the syntax error[s]: - 1:11 - SQL syntax error: the token "(" was not expected here
I thought I could use the hex function in the WHERE clause like that:
SELECT whatever columns
WHERE HEX(PROC_DEF_ID) = '...'
Could you suggest how to query those binary columns?
Thanks in advance!