Using Context in tMySqlRow Component

adbawany — Sat, 16 Nov 2024 00:11:53 GMT

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.

Re: Using Context in tMySqlRow Component

Anonymous — Sat, 08 May 2021 08:09:53 GMT

Hello,

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

Best regards

Sabrina

topic Using Context in tMySqlRow Component in Talend Data Catalog

Using Context in tMySqlRow Component

Re: Using Context in tMySqlRow Component