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
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
