Using Context in tMySqlRow Component

[adbawany]

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.

[Anonymous]

Hello,

In your sub job , please try to connect by trigger-->"OnComponentOk" type from the tMySqlRow to tJava.

Best regards

Sabrina