Hi christoph, this is bug, but this bug is Yours,

let we see the definition of STRLEN function

DECLARE EXTERNAL FUNCTION substrlen
CSTRING(255), SMALLINT, SMALLINT
RETURNS CSTRING(255) FREE_IT
ENTRY_POINT 'IB_UDF_substrlen' MODULE_NAME 'ib_udf';

So if You exceed 255 chars, the function fails, it's OK.

You can write Your own strlen with longer strings.

See You, Tom

> /* THE NEXT COMMAND CAUSES THE ERROR, THE LENGTH OF THE RESULT
> EXCEEDS 255 CHARACTERS */
> TXT = TXT || CTX || CAST(NUM AS VARCHAR(8)); LEN = STRLEN(TXT);
> END
>
> regards, christoph
>