|
[{"id":"103bfa37.6b516e","type":"DB2 for i","z":"eadfbe70.b0e7e","mydb":"9a3f5153.5dafc","name":"","arraymode":true,"x":492,"y":185,"wires":[["86657e84.1cdde8"]]},{"id":"c8920ea2.8dd158","type":"inject","z":"eadfbe70.b0e7e","name":"SQL Query","topic":"database","payload":" SELECT * FROM ACMEAIR.MYTABLE","payloadType":"str","repeat":"","crontab":"","once":false,"x":247,"y":186,"wires":[["103bfa37.6b516e"]]},{"id":"86657e84.1cdde8","type":"debug","z":"eadfbe70.b0e7e","name":"","active":true,"console":"false","complete":"false","x":697,"y":182,"wires":[]},{"id":"c82b0b2e.67d66","type":"DB2 for i","z":"eadfbe70.b0e7e","mydb":"9a3f5153.5dafc","name":"","arraymode":true,"x":588,"y":297,"wires":[["f7986cf5.8a94a8"]]},{"id":"f7986cf5.8a94a8","type":"debug","z":"eadfbe70.b0e7e","name":"","active":true,"console":"false","complete":"false","x":792,"y":293,"wires":[]},{"id":"2a5644b9.d4f37c","type":"inject","z":"eadfbe70.b0e7e","name":"SQL Query","topic":"database","payload":" SELECT * FROM ACMEAIR.MYTABLE","payloadType":"str","repeat":"","crontab":"","once":false,"x":128,"y":296,"wires":[["14a02360.7889a5"]]},{"id":"14a02360.7889a5","type":"template","z":"eadfbe70.b0e7e","name":"Setting msg.database","field":"database","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"CNX2","output":"str","x":358,"y":299,"wires":[["c82b0b2e.67d66"]]},{"id":"9a3f5153.5dafc","type":"DB2 for i Config","z":"","cnnname":"CNX1","db":"*LOCAL"}] |