Create procedure with ucase select - bug?

[Former Member]

Hi all,

this code

create table t1

(

field1_t1 varchar(10)

)

//

CREATE PROCEDURE xxx

RETURNS CURSOR AS

DECLARE :$CURSOR CURSOR FOR

SELECT UCASE(field1_t1) FROM YYYYXXXX.t1

;

It works well with MAXDB 7.6.00.34 (WinXP SP2 prof)

and with MAXDB 7.6.03.07 (WinXP SP2 prof) generates error:

Syntax error or access violation;-3008 POS(68) Invalid keyword or missing delimiter

Is it bug? Can anyone check this query on other system/database?

Best regards,

Lukasz

[lbreddemann · Accepted solution]

Hi Lukasz,

try this:

CREATE PROCEDURE xxx

RETURNS CURSOR AS

DECLARE :$CURSOR CURSOR FOR

SELECT <b><u>UPPER</u></b>(field1_t1) FROM YYYYXXXX.t1

;

Check the documentation <a href="http://http://maxdb.sap.com/currentdoc/71/81736bb9b311d2a97100a0c9449261/content.htm">String functions</a>

KR Lars

[Former Member]

Thanks for help. It solved the problem.

Mislead me fact that this select works fine alone, into procedure not.

Thanks and best regards.

Lukasz.