×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
1) You should specify the same number of values and columns on the insert,
and make sure that they "match up".
You can use the DEFAULT keyword if you want to explicitly use a default
value.
2) Identity columns can be created so that they are GENERATED BY DEFAULT
or GENERATED ALWAYS
If you generate by default, the insert can specify a value for the
column, or not specify the value and allow the system to generate a value.
3) See:
http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/index.jsp?topic=%2Fsqlp%2Frbafyinsertidentity.htm
AND
http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/index.jsp?topic=%2Fsqlp%2Frbafysqlpidentity.htm
message: 4
date: Wed, 4 Sep 2013 13:55:52 +0000
from: "Smith, Mike" <Mike_Smith@xxxxxxxxxxxxxxxx>
subject: jdbcr4 and identity columns
I'm sure this is really easy to do, but I'm not having any luck.
I have a table on SQL SERVER that that has an identity column.
So a shortened version of the file might be
PREMISETABLE in SQL SERVER
OBJECTID
PREMISE
ADDRESS
stmt = JDBC_PrepStmt(conn : 'Insert Into PREMISETABLE'
+ '(PREMISE,'
+ 'PREMISEADDRESS)'
+ ' values (?,?,? )');
JDBC_setString (stmt: 2: UPPRM);
JDBC_setString (stmt: 3: SERVADDR);
rc = JDBC_ExecPrepUpd( stmt );
When I try this, I get an error stating that Parameter #1 has not been set.
It seems I can't set Parameter #1 either because its an identity column.
How do I insert records into this table ignoring the identity column?
Nick Lawrence
DB2 for IBM i
midrange.com
