Make sure the function is defined as:
DETERMINISTIC, NO SQL or CONTAINS SQL, and NO EXTERNAL ACTION.
For semantic reasons a generated column cannot depend on any data outside
of the row or have unpredictable results.

Cheers
Serge



"kmalleck" <db2udbdba-ezmlmshield-x48516564.[Email address protected] wrote
on 10/21/2005 04:55:24 AM:

> Hi all,
>
> Can anyone tell me how to use a UDF in a generated always column?
>
> I am trying to set up columns that are goingt o be case insensitive and
> accent insensitive...
> So I wrote a function that converts all characters to their non-accented
> upper case..
> But I can't generate a column for this...
> Any help please ?
>
> Thanks
>
>
_____________________________________________________________________________

>
> This message and the attached documents are confidential and covered
> by professional secrecy. They are intended to their adresses only.
> They should not be used for any purpose and their content should not
> be disclosed to anyone. In case you have received this message and
> the attached documents by mistake, please advise us and delete them
> immediately.
>
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>


DB2 & UDB email list listserv db2-l LazyDBA home page