SEO

#1 (**permalink**) 02-27-2008, 06:28 AM

I am doing an insert into a table with a generated key. How do I obtain
the generated key of the record I just inserted?

#2 (**permalink**) 02-27-2008, 06:28 AM

Try

select gen_key from final table(insert into your_table (columns) values
(values))

That is, select the generated key as part of the insert statement.

I really, really like that feature.

-Chris

#3 (**permalink**) 02-27-2008, 06:29 AM

Chris wrote:
> Try
>
> select gen_key from final table(insert into your_table (columns) values
> (values))
>
> That is, select the generated key as part of the insert statement.
>
> I really, really like that feature.
>
> -Chris
>
Thank you very much. No doubt it is implied by the fine manuals, but I
sure didn't find it in the *[Ii]dent* samples in the samples directory.

#4 (**permalink**) 02-27-2008, 06:29 AM

The manuals aren't perfect either. IMNSHO, you need to know what you
are looking for.

Although, one thing about is really nice. It lists possible error codes
when using bad parameters.

B.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

How to get generated key back in php/db2 v8.1.9 Linux