RE: Why is this SQL statement too complicated

Ralf Schneider  wrote:

> 
> I have modified a SQL statement (I added the LOWER function) 
> and after that 
> modification I get the error message -1103: Too complicated 
> SQL statement. 
> This is the statement:
> 
> SELECT "subject", "iid", "cip" FROM bkadm.original 
> WHERE "brisance" <= 2 AND LOWER("message") like '*nochmal*'
> 
> This does not seem too complicated for me compared to other 
> statements I use. 
> The statement is used in a search function and I inserted the 
> LOWER function 
> for a case insensitive search.
> 
> The documentation recommends to simplify the statement, but I 
> have no idea how 
> to make it simplier by having the same functionality.
> 
> The database is a SAPDB 7.3.0.21 on SuSE Linux 8.0.
> 
> Any suggestions?

This sounds strange indeed.
Please provide the table and view-definitions needed to define
bkadm.original and the full statement (as you wrote
The statement is used in a search function... this seems not
to be the whole thing) you are using.

Elke
SAP Labs Berlin