Convert select query output to Json format in NodeJS

Question

I am doing a select query on a DB2 database using NodeJS. The query returns FIRST 5 ROWS.

I want to convert these 5 statement that the query returns into a Json format object. Is there something that is already built that i can reuse to convert query to json ?

var ibmdb = require('ibm_db');

ibmdb.open("DRIVER={DB2};DATABASE=profiledb;HOSTNAME=158.xx.xx.xxx;UID=user;PWD=pass;PORT=1234;PROTOCOL=TCPIP", function (err,conn) {
  if (err) return console.log(err);

  conn.query('SELECT STMT_TEXT, ESTIMATE FROM TABLEUSUAGE WHERE TIMESTAMP > (SELECT CURRENT DATE - 2 DAY FROM SYS.SYSDUMMY1) ORDER BY ESTIMATE DESC FETCH FIRST 5 ROWS ONLY', function (err, data) {
    if (err) console.log(err);

    var data_from_query = data; 

    console.log(data);

    conn.close(function () {
      console.log('done');
    });
  });

});

Marsh · Accepted Answer · 2014-12-01 05:02:22Z

12

Yes try the below statement that would convert your output to Json format.

 console.log(JSON.stringify(data));

answered Dec 1, 2014 at 5:02

Marsh

4176 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Convert select query output to Json format in NodeJS

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