You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by Shreyas Kaushik <Sh...@Sun.COM> on 2005/07/27 18:48:20 UTC
[Fwd: Help with Identity_Val_Local() and DERBY-353]
Some pointers need for Narayanan here.
thanks
Shreyas
Re: [Fwd: Help with Identity_Val_Local() and DERBY-353]
Posted by Daniel John Debrunner <dj...@debrunners.com>.
Shreyas Kaushik wrote:
> Some pointers need for Narayanan here.
>
> thanks
> Shreyas
>
> ------------------------------------------------------------------------
>
> Subject:
> Help with Identity_Val_Local() and DERBY-353
> From:
> V Narayanan <V....@Sun.COM>
> Date:
> Wed, 27 Jul 2005 18:51:19 +0530
> To:
> sun-derby-discuss@Sun.COM
>
> To:
> sun-derby-discuss@Sun.COM
> CC:
> Shreyas Kaushik <Sh...@Sun.COM>, Amit Handa <Am...@Sun.COM>
>
>
> Hi,
> I had a few doubts regarding the working of the identity_val_local
> function.
>
> An insert statement containing --generated by default as identity-- does
> a getSetAutoincrementValues to get and set values from the SYSCOLUMNS
> table. so in effect it takes the identity column value from the
> SYSCOLUMNS table.
>
> The identity_val_local() function returns the last single statement
> insert value for the identity column.
There are additional semantics for identity_val_local(), you need to add
'for the current connection (session)' to the end of your definition.
Dan.