Beermann, Albert wrote:
Hello Everbody !
I want to create an index on upper(name1)
create index stadressstammname1 on stadressstamm (upper(NAME1))
You missed the fact, that indexes are allowed only on database
functions, meaning user defined functions, not pre-defined functions
described in the manual.
So you have to create a database function, use there the pre-defined
function upper in and then use the user-defined-function name in the
create index statement
eset.htm
Elke
SAP Labs Berlin
Error: unknown database function upper
Any help welcomed.
Best regards
Albert
''
''
(0 0)
+(_)+
| Tel: 0541/5841-868 |
| Fax: 0541/5841-869 |
| Mail: mailto:a.beermann (AT) piepenbrock (DOT) de |
| Internet: http://www.piepenbrock.de |
++
|__|__|
|| ||