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

Not all files accessible #7

Closed waltercrombez closed 1 year ago

waltercrombez commented 4 years ago

Hi,

Experimenting with node-red-contrib-db2-for-i I experienced a strange behaviour. For some files on the IBM i the result of a simple 'SELECT * FROM ' was nicely returned into the msg.payload, for others, the result was an empty msg.payload : string[0] . I could not figure out why. Any idea how to get this resolved ?

bmarolleau commented 4 years ago

Hi! Can you share the kind of SQL query you are running, with a sample table DDL , to see if it is related to the node itself? As designed, the node should be able to run any SQL statement for select, update, delete. Assuming you have the necessary user (private/public) authority to access the data in Db2 for i. Keep us posted, thx for the feedback.

waltercrombez commented 4 years ago

Hi,

I Attached a DSPFD and the SQL to create the file. The SQL statement which I defined in a Function node is

< msg.payload="select * from WCR_.DM0100p"; return msg; <

QPDSPFD_WALTERC_QPADEV000B_157363_19.pdf

Tx VM

waltercrombez commented 4 years ago

dm0100p.txt

bmarolleau commented 4 years ago

Hi @waltercrombez Any news on this issue? could you determine the cause of the issue , on your side?
Keep us posted.