Hi,
DB2 UDB 8.2.2, Win32
I'm trying to create GENERATED ALWAYS column with UDF in definition
My code
CREATE FUNCTION ADM.F_AAAA(par_InStr VARCHAR(10))
RETURNS VARCHAR(10)
SPECIFIC F_AAAA
DETERMINISTIC
NO EXTERNAL ACTION
RETURN par_InStr
@
create table adm.aaa(
f1 varchar(10),
f2 varchar(10) generated always as (adm.F_AAAA(f1))
)
I recive error SQLSTATE=42621. What is wrong?
Can anybody help me? I am looking for simple example
Thanks
Yaro