<div>
I do not know the exact thing in DB2, but probably example from other database might get you on the right track. The Auto Increment is referred as follows in the following database<br />
<br />
Micorosft Access : AutoNumber<br />
Microsoft SQL : Identity<br />
Oracle: Sequence<br />
<br />
DB2 might have something similari.<br />
<br />

</div>


I do not know the exact thing in DB2, but probably example from other database might get you on the right track. The Auto Increment is referred as follows in the following database

Micorosft Access : AutoNumber
Microsoft SQL : Identity
Oracle: Sequence

DB2 might have something similari.



<div>
Hi simpsol,<br />
<br />
Actually, the DDL for an auto increment column is different for SQL Server, MySQL, DB2, and Oracle. &nbsp;Just substituting the keyword 'IDENTITY' with 'AUTOINCREMENT' isn't enough.<br />
<br />
<br />
Kent<br />

</div>


Hi simpsol,

Actually, the DDL for an auto increment column is different for SQL Server, MySQL, DB2, and Oracle.  Just substituting the keyword 'IDENTITY' with 'AUTOINCREMENT' isn't enough.


Kent


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
&nbsp; I'm on DB2 UDB 8.2.<br />
&nbsp; &nbsp;I have a table TB_INS_JOB(A INT, B VARCHAR(20),C VARCHAR(10));<br />
&nbsp; &nbsp;I'm doing the following:<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp;INSERT INTO TB_INS_JOB(B,C)<br />
&nbsp; &nbsp; &nbsp; &nbsp; SELECT B,C FROM TB_CP_JOB;<br />
<br />
When i insert the values into TB_INS_JOB, i want the values in the column to Auto Increment, for each row inserted.<br />
&nbsp;<br />
&nbsp; How can i do it? Please advise.
</div>
</div>


Hi,

  I'm on DB2 UDB 8.2.
   I have a table TB_INS_JOB(A INT, B VARCHAR(20),C VARCHAR(10));
   I'm doing the following:

       INSERT INTO TB_INS_JOB(B,C)
        SELECT B,C FROM TB_CP_JOB;

When i insert the values into TB_INS_JOB, i want the values in the column to Auto Increment, for each row inserted.
 
  How can i do it? Please advise.

Auto Increment in Insert into Select

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.