Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using the tGreenplumRow component actually but I am going to explain my concern referring to it as tMySql so that more people are familiar with it.
I have uploaded a file using the tFilelist component and then used the tJava component to set the context variable that I call file name.
I am able to print out the filename when I execute the job.
Next I am trying to insert values into a table. I am able to do so. Following is the code that works perfectly fine (please excuse the red marks. have put them to maintain confidentiality):
Next, I am trying to use the context variable that I have set in the tJava component.
I get an error:
ERROR: missing FROM-clause entry for table "**insert name of the file**".
Please help.
Hello,
In your sub job , please try to connect by trigger-->"OnComponentOk" type from the tMySqlRow to tJava.
Best regards
Sabrina