node-ibm_db

Contact owners and managers

1–30 of 51

Welcome!!

This google group is for users of the ibm_db node module [ https://github.com/ibmdb/node-ibm_db/ ] to post questions related to the usage of the module with IBM DB2 and IBM Informix databases.

This forum is monitored by the developers of the ibm_db module and we will respond as promptly as possible to your questions here.

0 selected

Jonathan Tan, bimaljha3

1/27/20

Can we run an sql file via node-ibm_db?

Yes, using ibm...@2.6.3, you can execute sqlfile. It is documented here: https://github.com/ibmdb/

unread,

Can we run an sql file via node-ibm_db?

Yes, using ibm...@2.6.3, you can execute sqlfile. It is documented here: https://github.com/ibmdb/

1/27/20

Martin Selecký, bimaljha6

12/14/17

Problem with DB2 Pool

Dňa streda, 13. decembra 2017 17:09:34 UTC+1 bimaljha napísal(-a): Hi Martin, Problem is not with the

unread,

Problem with DB2 Pool

Dňa streda, 13. decembra 2017 17:09:34 UTC+1 bimaljha napísal(-a): Hi Martin, Problem is not with the

12/14/17

Jonas Kello, bimaljha2

10/23/17

Database name not found

The error says that the name of target AS400 database is not correct. Many applications are using

unread,

Database name not found

The error says that the name of target AS400 database is not correct. Many applications are using

10/23/17

Rodrigo Belli, bimaljha3

8/26/17

How to install ibm_db offline

Thank you Bimal Jha! Works for me too. att Rodrigo Belli On Thursday, August 24, 2017 at 6:28:23 AM

unread,

How to install ibm_db offline

Thank you Bimal Jha! Works for me too. att Rodrigo Belli On Thursday, August 24, 2017 at 6:28:23 AM

8/26/17

Jonathan Young, bimaljha2

8/2/17

equivalent functionality to query( sql, function(err, rows, moreResultSets){}) in ibm_db 2.x

Please use the latest version ibm...@2.1.0 that has fix for this issue. If your issue is still not

unread,

equivalent functionality to query( sql, function(err, rows, moreResultSets){}) in ibm_db 2.x

Please use the latest version ibm...@2.1.0 that has fix for this issue. If your issue is still not

8/2/17

Magnus Berglund, bimaljha2

7/10/17

Numeric fields in response object

Check how test-basic-test.js is returning numeric data. Update connection info in ibm_db/test/config.

unread,

Numeric fields in response object

Check how test-basic-test.js is returning numeric data. Update connection info in ibm_db/test/config.

7/10/17

J Lanham, … bimaljha8

6/27/17

Getting SQL1042C ... SQL STATE=580004 when connecting to the database

We have provided solution for SQL1042C error in many issues opened on github: https://github.com/

unread,

Getting SQL1042C ... SQL STATE=580004 when connecting to the database

We have provided solution for SQL1042C error in many issues opened on github: https://github.com/

6/27/17

Ruben Legarda, bimaljha2

6/15/17

Installing ibm_bd on node.js 6.11.0 with macOS sierra

Hi Ruben, Problem seems with your install_name_tool installed in the system. You may need to update

unread,

Installing ibm_bd on node.js 6.11.0 with macOS sierra

Hi Ruben, Problem seems with your install_name_tool installed in the system. You may need to update

6/15/17

Robert Loredo, … bimaljha6

5/10/17

ibm_db\lib\odbc.js outputs the following: self.odbc = (options.odbc) ? options.odbc : new odbc.ODBC();

Check the fix here: https://github.com/ibmdb/node-ibm_db/issues/168#issuecomment-300155925 Thanks and

unread,

ibm_db\lib\odbc.js outputs the following: self.odbc = (options.odbc) ? options.odbc : new odbc.ODBC();

Check the fix here: https://github.com/ibmdb/node-ibm_db/issues/168#issuecomment-300155925 Thanks and

5/10/17

Craig Wilson, bimaljha2

5/10/17

Windows 10 install error self.odbc = (options.odbc) ? options.odbc : ((ENV) ? ENV : new odbc.ODBC())

This is user permission related issue. See the fix here: https://github.com/ibmdb/node-ibm_db/issues/

unread,

Windows 10 install error self.odbc = (options.odbc) ? options.odbc : ((ENV) ? ENV : new odbc.ODBC())

This is user permission related issue. See the fix here: https://github.com/ibmdb/node-ibm_db/issues/

5/10/17

Duraimurugan Rajendran, bimaljha18

3/8/17

selectForConnectTimeout and recv error

Hi Durai, I would still request to share output of below commands to proceed further: db2level db2cli

unread,

selectForConnectTimeout and recv error

Hi Durai, I would still request to share output of below commands to proceed further: db2level db2cli

3/8/17

Janani sridhar, … Rohit Pandey3

1/20/17

Hi I am trying to connect to ibm_db. But getting the error database name not found at the remote node.

Hi @Janani sridhar any updates about the issue?

unread,

Hi I am trying to connect to ibm_db. But getting the error database name not found at the remote node.

Hi @Janani sridhar any updates about the issue?

1/20/17

Atul Kumar, bimaljha2

1/17/17

Facing Issue with multiple insert statement and rollback them if having some error

Check your answer here: https://github.com/ibmdb/node-ibm_db/issues/215 Thanks. On Tuesday, January

unread,

Facing Issue with multiple insert statement and rollback them if having some error

Check your answer here: https://github.com/ibmdb/node-ibm_db/issues/215 Thanks. On Tuesday, January

1/17/17

Kiryl Bucha, bimaljha2

11/21/16

How to verify connection is Alive and ready to execute statements.

If connection is broken then SQL30081N is expected. You can know some connection is good or not by

unread,

How to verify connection is Alive and ready to execute statements.

If connection is broken then SQL30081N is expected. You can know some connection is good or not by

11/21/16

Adam Hammond, bimaljha3

11/18/16

Using cursors to read a large dataset

Use below test.js file. It returns a single row at once that can be processed by application in loop.

unread,

Using cursors to read a large dataset

Use below test.js file. It returns a single row at once that can be processed by application in loop.

11/18/16

shailesh bhaskaran, bimaljha5

10/31/16

DB2 zos stored procedure support

ibm...@1.0.1 is released with OUT and INOUT parameter support for Stored Procedure. Please try it.

unread,

DB2 zos stored procedure support

ibm...@1.0.1 is released with OUT and INOUT parameter support for Stored Procedure. Please try it.

10/31/16

Kommineni Devaraj, bimaljha2

9/18/16

Dash DB throws connection opening error: SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP".

Please use ibm_db.Pool() to fix this issue. Please replace following line in your code var dashDB =

unread,

Dash DB throws connection opening error: SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP".

Please use ibm_db.Pool() to fix this issue. Please replace following line in your code var dashDB =

9/18/16

Dan Krissell, bimaljha3

8/9/16

Secure connection

Thank you Bimal, I was able to get it working. On Monday, August 8, 2016 at 10:56:18 AM UTC-4,

unread,

Secure connection

Thank you Bimal, I was able to get it working. On Monday, August 8, 2016 at 10:56:18 AM UTC-4,

8/9/16

Ken Johnson, bimaljha3

8/4/16

AWS - Elastic Beanstalk npm install issue

I am able to install the npm module manually on an ec2 instance. The issue is with the normal npm

unread,

AWS - Elastic Beanstalk npm install issue

I am able to install the npm module manually on an ec2 instance. The issue is with the normal npm

8/4/16

6/23/16

Best Practices: Accessing DB2i(OS/400) from Windows2102Server Angular2+NodeJS

Hi Bimal We are doing a prototype for the management to convince them saying Angular2+NodeJS+DB2

unread,

Best Practices: Accessing DB2i(OS/400) from Windows2102Server Angular2+NodeJS

Hi Bimal We are doing a prototype for the management to convince them saying Angular2+NodeJS+DB2

6/23/16

Bob hserus, bimaljha3

6/7/16

From Windows-NodeJS: How to read/write DB2i?

Thank you Bimal. Appreciated. On Wednesday, June 1, 2016 at 11:38:02 PM UTC-4, Bob hserus wrote: Hi

unread,

From Windows-NodeJS: How to read/write DB2i?

Thank you Bimal. Appreciated. On Wednesday, June 1, 2016 at 11:38:02 PM UTC-4, Bob hserus wrote: Hi

6/7/16

Michael Noh, Bimal K Jha2

5/31/16

Question: Is there any possibility to create a db?

Hi Michael, Currently there is no support for create db by node.js ibm_db driver. We may have it in

unread,

Question: Is there any possibility to create a db?

Hi Michael, Currently there is no support for create db by node.js ibm_db driver. We may have it in

5/31/16

Craig Wilson, bimaljha3

5/20/16

Windows initial 20 second query delay

Seems your windows system is slower or network is slower. You can check the time to get database

unread,

Windows initial 20 second query delay

Seems your windows system is slower or network is slower. You can check the time to get database

5/20/16

Wayne Patterson, … Rohit Pandey6

4/26/16

Request: Display node version compatibility

Yes very soon we are going to update our npm repository, till then please install it from git. Thanks

unread,

Request: Display node version compatibility

Yes very soon we are going to update our npm repository, till then please install it from git. Thanks

4/26/16

mbru...@manitoulintransport.com, bimaljha3

4/2/16

Use with iSeries Access ODBC Driver

Thanks Bimal :) On Thursday, March 31, 2016 at 2:36:51 PM UTC-4, bimaljha wrote: Hi Matt, node-ibm_db

unread,

Use with iSeries Access ODBC Driver

Thanks Bimal :) On Thursday, March 31, 2016 at 2:36:51 PM UTC-4, bimaljha wrote: Hi Matt, node-ibm_db

4/2/16

mhe...@gmail.com, bimaljha3

3/11/16

how to insert a file as a blob?

I saw that example and tried blob(?) instead of ? in my values clause before I posted my question. It

unread,

how to insert a file as a blob?

I saw that example and tried blob(?) instead of ? in my values clause before I posted my question. It

3/11/16

mc4...@stern.nyu.edu, bimaljha2

3/8/16

Installing node v4.3.2 on mac osX Yosemite encountering Error

Hi, Please provide the complete npm install output. The main error is missing from the pasted text. I

unread,

Installing node v4.3.2 on mac osX Yosemite encountering Error

Hi, Please provide the complete npm install output. The main error is missing from the pasted text. I

3/8/16

Justin Johnson, bimaljha2

2/28/16

Attempting to node-gyp rebuild ibm_db, windows 7, msvs 2105

Check this answer https://github.com/ibmdb/node-ibm_db/issues/96 . It should help you. Thanks. On

unread,

Attempting to node-gyp rebuild ibm_db, windows 7, msvs 2105

Check this answer https://github.com/ibmdb/node-ibm_db/issues/96 . It should help you. Thanks. On

2/28/16

Matt Harris, Justin Johnson2

2/25/16

ibm_db fails to install on CentOS 6.6

See this issue: https://github.com/nodejs/nan/issues/448 It looks like your gcc is a few versions

unread,

ibm_db fails to install on CentOS 6.6

See this issue: https://github.com/nodejs/nan/issues/448 It looks like your gcc is a few versions

2/25/16

Valerio Riva, … bimaljha4

2/8/16

Can't connect from osx 10.11.3 neither Ubuntu 14.04.3 LTS to bluemix dashdb service

It seems that today it works on osx with 0.0.15 and 0.0.19 also without exporting DYLD_LIBRARY_PATH!

unread,locked,

Can't connect from osx 10.11.3 neither Ubuntu 14.04.3 LTS to bluemix dashdb service

It seems that today it works on osx with 0.0.15 and 0.0.19 also without exporting DYLD_LIBRARY_PATH!

2/8/16

Search

Clear search

Close search

Google apps

Main menu