Error SQLSTATE=02000 SQLCODE=100

[staplFred]

Regarding this closed issue:

• [https://github.com/Error SQLSTATE=02000 SQLCODE=100 #138]

I am having the same issue with the execSync function. I believe the same fix needs to be applied to it.

This similar snippit reproduces the issue.

const {dbconn, dbstmt} = require('idb-connector');  
const sSql = 'UPDATE MY.TABLE SET COL0=0 WHERE COL1 is not null'; 
const connection = new dbconn(); 
connection.conn('*LOCAL'); 
const statement = new dbstmt(connection); 
const results = statement.execSync(sql) 
statement.close(); 
console.log('results: ', results) 

Thanks.

[staplFred]

Can we please get this tagged for a new release? Thanks.