Re: Stored Procedure (or SQL) to get a value then update it to +1

[Mike Wills <mike@xxxxxxxxxxxx>]

The key is yy#### formated to yy-#### we reset the count every year. Can't
really do that. Most of our stuff works this way. (To annoyance sometimes)

I have no clue what will happen in 2090 when we start getting duplicate
keys.

--
Mike Wills
http://mikewills.me


On Wed, Jul 11, 2012 at 1:27 PM, <rob@xxxxxxxxx> wrote:

> Replace the file with a 'sequence' data area.
> http://archive.midrange.com/midrange-l/201207/msg00186.html
>
>
> 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:   Mike Wills <mike@xxxxxxxxxxxx>
> To:     midrange-l@xxxxxxxxxxxx,
> Date:   07/11/2012 02:16 PM
> Subject:        Stored Procedure (or SQL) to get a value then update it to
> +1
> Sent by:        midrange-l-bounces@xxxxxxxxxxxx
>
>
>
> Stored procedures are not strong in this one.;-)
>
> We have a "constant" file that holds the next sequence number for one of
> our applications. I now need to access that from an external application.
> I
> am hoping I can write a stored procedure to essentially
>
> SELECT nextkey from CONSTANT
> UPDATE CONSTANT SET nextkey = nextkey + 1
>
> How would I put this one stored procedure?
>
>
> --
> Mike Wills
> http://mikewills.me
> --
> 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.