Code: Detail

Especializações:Asp.net, Ajax, C#, Visual Basic.net, Wcf, XML FrameWork .net 1.1, 2.0 e 4.0, OO, Design Patterns Arquitetura SOA, DDD, MVP e MVVM Html, Css, JavaScript Sql Server 2000, 2005 e 2008 Oracle 8i e 9i Asp3, Visual Basic 6 e COM+

DB2 - (Portuguese)

Obter o valor do Identity no db2

Script para obter o valor da coluna identity após efetuar um insert em uma tabela que possui um campo do tipo identity. No sql server seria select @@identity, ja no db2 é assim:

Last update: 07/10/2015
DB2       
 
N/A
N/A
N/A
N/A
 

select IDENTITY_VAL_LOCAL() as last_cod from sysibm.sysdummy1

Source:
 
Users who have marked this routine as a favorite
 
 
 
The site ti4fun is not responsible for the content on sites for which you have external links

Articles, routines, tips, forums, blogs or any other content posted on ti4fun site is not tested and not validated, so you should test and validate any information collected on the ti4fun site before applying it to final use environment, such as example, production. the TI4FUN site is not responsible for quality or for any damages, direct, indirect or consequential, from use of any content posted by the authors in the site.

All content published on the ti4fun site is the responsibility of the author and do not necessarily express the views of the site ti4fun and its employees.