Re: Generated by column syntax

pls do not top post, see below

"Jerry Alan Braga" <jerry.braga@xxxxxxxxxxx> schreef in bericht
news:KBABi.16778$vP5.12746@xxxxxxxxxxx
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@xxxxxxx> wrote in message
news:1188480358.787976.242160@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Aug 30, 7:13 am, "Jerry Alan Braga" <jerry.br...@xxxxxxxxxxx>
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


.

Relevant Pages

  • Re: Unification of Methods and Functions
    ... It is hard to judge the complexity of a proposed syntax by looking ... "textbook" explanation of instance variables. ... explanation than the one I prefer or the one that is in the Python ... Becuase perl is weakly typed this 'makes sense' in perl, ...
    (comp.lang.python)
  • what is this syntax: 0102 ?
    ... On p. 131-132 in "Programming Ruby 2d.", ... Is that Ruby's unicode syntax? ... How about a ding dang explanation Mr. ... Thomas? ...
    (comp.lang.ruby)
  • Re: "with" Coders are Monsters
    ... Nick Hodges (CodeGear) presented the following explanation: ... do something about the syntax, and especially since you agree with ...
    (borland.public.delphi.non-technical)
  • Re: problem with File.Delete
    ... (one explanation, in this case, those of Booghost, was enough ... ... Redundant ... Can somebody tell me the right syntax? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Thoth filtering question
    ... You can google for a tutorial on regex (regular expressions) for the ... full explanation of the syntax. ...
    (comp.sys.mac.comm)