Extraer el siguiente valor de una secuencia en DB2

Para extraer el valor actual utilicese

SELECT PREVVAL FOR [nombre_secuencia] FROM SYSIBM.SYSDUMMY1

Para obtener el siguiente valor

SELECT NEXTVAL FOR [nombre_secuencia] FROM SYSIBM.SYSDUMMY1

This entry was posted on viernes, abril 12th, 2013 at 07:05 and is filed under Base de Datos, DB2. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

Comments are closed.