Re: Generated columns with user calc

[Peter Dow <petercdow@xxxxxxxxx>]

Hi Justin,

Afaik, that's correct. I think an SQL view is the normal way to have a 
derived column.

If you absolutely, positively, must have the derived column in the 
table, maybe you could use FIELDPROC.  Although it's normally for 
encrypting and decrypting a column's value, it appears you could use it 
to generate a value, although since it is done with a CALL to a program, 
not a procedure in a service program, I would imagine the performance is 
not great.

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx>

/
On 4/27/2021 3:04 PM, Justin Taylor wrote:
> I need to a derived/generated column to an existing table using a formula.
> The way I read the Db2 Ref, generated columns can only be one of a few
> system-controlled values.  Am I reading that wrong?
>
> TIA