Re: How to call function IDENTITY_VAL_LOCAL() when inserting data using JDBC driver

See the section "Retrieving auto-generated keys" at:

http://www.ibm.com/developerworks/java/library/j-jdbcnew/

Google "jdbc generated keys" or "jdbc RETURN_GENERATED_KEYS" for more details.


Joe Sam

Joe Sam Shirah - http://www.conceptgo.com
conceptGO - Consulting/Development/Outsourcing
Java Filter Forum: http://www.ibm.com/developerworks/java/
Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
Going International? http://www.jguru.com/faq/I18N
Que Java400? http://www.jguru.com/faq/Java400

----- Original Message ----- From: "Ashish Kulkarni" <ashish.kulkarni13@xxxxxxxxx>
To: "Java Programming on and around the iSeries / AS400" <java400-l@xxxxxxxxxxxx>
Sent: Thursday, April 01, 2010 1:51 PM
Subject: How to call function IDENTITY_VAL_LOCAL() when inserting data using JDBC driver

If i insert data in a table from RPG, and if the column is of type identity
i can do some thing like below to find out the latest number of the inserted
record, how can i do the same in JDBC driver

VALUES IDENTITY_VAL_LOCAL() INTO :IVAR;


--
Ashish
www.ayurwellness.com
www.mysoftwareneeds.com
--
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.