how to get the last insert id from a table in DB2 using nodejs and ibm_db package

Question

I would like to get back the primary key of the last inserted row in DB2 form node.js using ibm_db package. I tried using

select id from NEW TABLE (insert into (val1, val2, ...) values ('lorem', 'ipsum', ...))

and .prepare(sql, callback) to make DB call in node.js. The result in the callback doesn't contain any property or method to get the auto-generated key. Any help is appreciated.

Bimal Jha · Accepted Answer · 2016-11-22 13:01:47Z

2

Yes, you need to fetch the data from result after execute as below:

  conn.prepare("select * from mytab1", function (err, stmt) {
    if(err) {
      console.log(err);
      return conn.closeSync();
    }
    stmt.execute([], function(err, result) {
      if(err) console.log(err);
      else {
        data = result.fetchAllSync();
        console.log("Fetched Data = " );
        console.log(data);
        result.closeSync();
        conn.close(function () { console.log('done'); });
      }
    });
  });

Check the ibm_db/test/test-basic-test.js file for details. Thanks.

answered Nov 22, 2016 at 13:01

Bimal Jha

4094 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to get the last insert id from a table in DB2 using nodejs and ibm_db package

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related