Example of using stmtError()

[abmusse]

Original report by Kristopher Baehr (Bitbucket: krisbaehr, GitHub: krisbaehr).

---

Are there any examples available for calling stmtError()? Thanks!

[abmusse]

Original comment by Xu Meng (Bitbucket: mengxumx, GitHub: dmabupt).

---

@krisbaehr , you can use the stmtError() or the error parameter to print the error messages --

#!javascript
function exec(sql){
  console.log("\n[SQL]:" + sql);
  stmt.exec(sql, function(rs, err) {
    if(err) {
      console.log("[error]:" + err);
      stmt.stmtError(db.SQL_HANDLE_STMT, 1, (rs) => {console.log("[stmtError]:" + rs);});
    }
    else
      console.log(rs);
    stmt.closeCursor();
  });
}

#!shell

bash-4.4$ node 0818-db2_error_msg.js
[SQL]:SELECT * FROM UNKNOWN.NOTTHERE
[error]:SQLSTATE=42704 SQLCODE=-204 NOTTHERE in UNKNOWN type *FILE not found.
[stmtError]:SQLSTATE=42704 SQLCODE=-204 NOTTHERE in UNKNOWN type *FILE not found.

[abmusse]

Original comment by Kristopher Baehr (Bitbucket: krisbaehr, GitHub: krisbaehr).

---

Thanks @dmabupt .