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

[Bob Stearns]

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?

[Chris]

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

[Bob Stearns]

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.

[Brian Tkatch]

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.