SEO

#1 (**permalink**) 02-27-2008, 05:00 AM

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

#2 (**permalink**) 02-27-2008, 05:00 AM

A SQL FUNCTION is READS SQL DATA by default, and that is not allowed in
a GENERATED expression. So, specify CONTAINS SQL.

B.

#3 (**permalink**) 02-27-2008, 05:02 AM

A SQL FUNCTION is READS SQL DATA by default, and that is not allowed in
> a GENERATED expression. So, specify CONTAINS SQL.
> B.

Works, thank you
Yaro

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

UDF in GENERATED ALWAYS column