Re: Adding calculated field

[rpglist@xxxxxxxxxxx]

Got it, thanks Rob....



> generate is for identity columns, you know, like an order number, customer
> number or some such number you want to system to automatically increment.
>
> You can do what you want but not in the physical table.  It will be in a
> view.  For example
> create view rob/inventory as(
> select itemnumber,
>        OpeningBalance+receipts+adjustments-issues as OnHand
> from erplib/itemmaster)
>
> Then it's easy to do
> select itemnumber, onhand
> from rob/inventory
> order by onhand desc
>
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>           Garrett, IN 46738
> Ship to:  Dock 108
>           6928N 400E
>           Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> From:   rpglist@xxxxxxxxxxx
> To:     midrange-l@xxxxxxxxxxxx,
> Date:   09/19/2012 01:25 PM
> Subject:        Adding calculated field
> Sent by:        midrange-l-bounces@xxxxxxxxxxxx
>
>
>
>
>
> Does DB2 support adding a calculated field such as
>
> ...
> int fld1,
> int fld2,
> int fld3 generate as (fld1+fld2));
>
> I thought the GENERATED ALWAYS AS would work but its burping on that.
>
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.