sql abfrage mit substring

[juergenkemeter]

select substring('AE' concat digits(dec(prid, 7, 0)) concat '/' concat substr(digits(pryear), 3, 2)
from hilfssto.proverw
where PRID = [PRID]

gibt folgendes aus:
---------------------------
DB2 Table Editor Developer
---------------------------
Keyword WHERE not expected. Valid tokens: , FOR.
(SQL code = -199, SQL state = 42601)
---------------------------
OK
---------------------------


ersetze ich where durch for, kommt folgendes:
---------------------------
DB2 Table Editor Developer
---------------------------
Token = was not valid. Valid tokens: ).
(SQL code = -104, SQL state = 42601)
---------------------------
OK
---------------------------

/jk

[Fuerchau]

select 'AE' concat digits(dec(prid, 7, 0)) concat '/' concat substr(digits(pryear), 3, 2)
from hilfssto.proverw
where PRID = [PRID]

[juergenkemeter]

alles klar, funktioniert. Danke!!

/jk