For a school project I'm trying to develop an app that parses an RSS feed, runs a sentiment analysis on the headlines, and then stores the headlines in different tables according to keywords in their headlines. In the tables I have three columns set up - Headline, Sentiment, URL.
I'm basically certain that my node-RED app is connected to my IBM Db2 because I was having a problem with connection limits which was showing an error both on my node-RED debug window and in my IBM Db2 instance, but nothing is being stored in any of my tables when I deploy my app.
Here's a screenshot of my flow.
My function node has the following code in it:
HEADLINE : msg.payload,
SENTIMENT : msg.sentiment.score,
URL : msg.topic
And a screenshot of my switch node:
In my dashDB out nodes I have the table set as MCF67624.DRONE (with drone being replaced by whichever table the node is connecting to. I wasn't sure whether I just had to enter the table name or format it like SCHEMA.TABLE but neither has worked so far.
Another possibility I considered is that maybe I'm storing the information as the wrong data type in the table? I have tried storing the Headline and URL information as CHAR, VARBINARY and BLOB and no luck so far with any, and I've had the sentiment being stored as an integer.
I've tried to be as specific as possible so I hope this is a good question, I've done a lot of googling and can't seem to find a simple tutorial on how to do this. I've read the info in node-RED itself about the dashDB node and I feel like I'm doing everything necessary but clearly I'm missing something.
Any help is so so appreciated.