Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Synchronous executeNonQuery() #583

Closed
lucaskuperman opened this issue Oct 10, 2019 · 1 comment
Closed

Synchronous executeNonQuery() #583

lucaskuperman opened this issue Oct 10, 2019 · 1 comment

Comments

@lucaskuperman
Copy link

Hello, I'm attempting to use ibm_db on a serverless IBMFunction, and for that, would be beneficial to have a executeNonQuerySync() method. Is there already such a method? If not, is there a plan for it? If not, how can I easily and synchronously run an update and get the number of rows affected? Thanks!

@bimalkjha
Copy link
Member

@lucaskuperman You can use executeNonQuerySync() method in your code. It is supported in ibm_db. Only thing is documentation was missing that I added now. You can see its use in test file here: https://github.com/ibmdb/node-ibm_db/blob/master/test/test-chinese-char.js#L34 . Thanks.

bimalkjha added a commit that referenced this issue Dec 3, 2019
* doc: Docker Linux Container instructions

* support for install --debug option on windows

* fix: blob data corruption issue #582

* doc: update doc for executeNonQuerySync API, issue #583

* force push connection to the queue when poolSize breaches maxPool boundry (#581)

* Support for node v12 on z/OS, and fix some test cases for z/OS (#586)

* fix: update unzipper version, issue #588

* fix: use v8::Isolate for nodev >= 11

* fix: ignore sqlcode 100 by executeNonQuery, issue #591

* fix: add executeNonQuerySync in odbc.js issue #595
bimalkjha added a commit that referenced this issue Dec 9, 2019
 * doc: update for issue #593 (Bimal Jha)
 * fix: update windows binary using latest code (Bimal Jha)
 * fix: for memory leak issue #576 (Bimal Jha)
 * fix: update windows binary for vscode 1.40.x (Bimal Jha)
 * update windows binaries (Bimal Jha)
 * fix: add executeNonQuerySync in odbc.js issue #595 (Bimal Jha)
 * fix: ignore sqlcode 100 by executeNonQuery, issue #591 (Bimal Jha)
 * fix: use v8::Isolate for nodev >= 11 (Bimal Jha)
 * fix: update unzipper version, issue #588 (Bimal Jha)
 * Support for node v12 on z/OS, and fix some test cases for z/OS (#586) (alexcfyung)
 * force push connection to the queue when poolSize breaches maxPool boundry (#581) (ashutoshrnjn)
 * doc: update doc for executeNonQuerySync API, issue #583 (Bimal Jha)
 * fix: blob data corruption issue #582 (Bimal Jha)
 * support for install --debug option on windows (Priyanka Manoharan)
 * doc: Docker Linux Container instructions (Bimal Jha)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants