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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob Stearns - 22 Mar 2006 23:26 GMT

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?

Reply to this Message

Chris - 23 Mar 2006 00:42 GMT

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

Reply to this Message

Bob Stearns - 23 Mar 2006 05:33 GMT

> Try
>
[quoted text clipped - 6 lines]
>
> -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.

Reply to this Message

Brian Tkatch - 23 Mar 2006 15:38 GMT

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.

Reply to this Message