<div>
<div class="content wysiwyg-content">
column T is defined as INTEGER GENERATED ALWAYS AS IDENTITY ( START WITH 1 INCREMENT BY 1 ).<br />
<br />
How to find the next number for T without actually insert a new record? &nbsp;The table has old data and I have trouble insert a new record. &nbsp;Thanks.<br />
<br />

</div>
</div>


column T is defined as INTEGER GENERATED ALWAYS AS IDENTITY ( START WITH 1 INCREMENT BY 1 ).

How to find the next number for T without actually insert a new record?  The table has old data and I have trouble insert a new record.  Thanks.



column INTEGER GENERATED ALWAYS AS IDENTITY ( START WITH 1 INCREMENT BY 1 )

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.