Get Last Inserted IDENTITY

mauvis · New User Joined: 27 Jul 2007 Posts: 11 Location: india

Hello,

I need to know the last inserted IDENTITY into a table.

Searching the web I've found to use SCOPE_IDENTITY(), but I'm not able to use this one.

Can anybody please let me know how we can find out the last inserted IDENTITY into the table.

Thanks & Regards,
Joe

enrico-sorichetti · Posted: Tue Feb 05, 2008 2:02 pm

did You search for "db2 last identity"
You will find many useful links
( also the pro and cons about using such facility, mostly cons

)

mauvis · New User Joined: 27 Jul 2007 Posts: 11 Location: india

Hello,

I'll want to know how can I make use of this. I didn't find anything for this.

please let me know.

Thanks & Regards,
Joe

abhishekmdwivedi · New User Joined: 22 Aug 2006 Posts: 95 Location: india

Here's a link which will help you :
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/r0004231.htm

ulfnsc · Posted: Tue Feb 05, 2008 4:51 pm

Hi Joe,
try this www.craigsmullins.com/dbu_0204.htm

/uffe

mauvis · New User Joined: 27 Jul 2007 Posts: 11 Location: india

Thanks Everyone...It worked out for me with IDENTITY_VAL_LOCAL()!