Re: Generated by column syntax

pls do not top post, see below

"Jerry Alan Braga" <jerry.braga_at_hotmail.com> schreef in bericht news:KBABi.16778$vP5.12746_at_edtnps90...
>I have seen on some posts that you can do the following
>
> alter table test add col_3 generated always by (col_1 + col_2); --
> virtual col
>
> alter table test add col_3 generated by (col_1 + col_2); -- stored virtual
> col
>
> what is the syntax of the generated statement, where are the docs on this
>
>
> <fitzjarrell_at_cox.net> wrote in message
> news:1188480358.787976.242160_at_22g2000hsm.googlegroups.com...
>> On Aug 30, 7:13 am, "Jerry Alan Braga" <jerry.br..._at_hotmail.com>
>> wrote:
>>> does anyone have any references to this and what are the capabilities
>>
>> Do you have a better explanation of what you want?
>>
>>
>> David Fitzjarrell
>>
>
>

Isn't that DB2 code?

Shakespeare Received on Thu Aug 30 2007 - 10:18:40 CDT