search

IBM / node-red-contrib-db2-for-i

A Node-RED node to read and write to a Db2 for i database from Node-RED on IBM i.
https://flows.nodered.org/node/node-red-contrib-db2-for-i
8 stars 7 forks source link

Change CCSID #11

Closed 7rueLightSeeker closed 3 years ago

7rueLightSeeker commented 3 years ago

Hey, I’m trying to execute "SELECT * FROM SYSTOOLS.GROUP_PTF_CURRENCY P;". It is unsuccessful because of CCSID 65355. Is there a way to change the CCSID of the QSQSRVR Job?

7rueLightSeeker commented 3 years ago

Changing the Users CCSID from *SYSVAL to the required Values worked for me. For further information look at nodejs-idb-connector: https://github.com/IBM/nodejs-idb-connector/issues/134