topic Re: tDBRow does not end in Talend Studio

tDBRow does not end

Anonymous — Sat, 16 Nov 2024 03:40:38 GMT

hi...

I used tDBRow to run the partition truncate.

The truncate works well, but tDBRow doesn't end.

in my mind tos is dont know the job is over...

Is there any way?

Thanks..

Re: tDBRow does not end

Anonymous — Mon, 06 Jan 2020 03:07:46 GMT

Hello,

What's the sql query of tDBInput component in your job design? Could you please post your component setting screenshot here which will be helpful for us to address your issue.

Best regards

Sabrina

Re: tDBRow does not end

Anonymous — Mon, 06 Jan 2020 03:25:40 GMT

Hi, post SQL is

SELECT
T1.CHNGYM

...

       ...
      , CURRENT_TIMESTAMP
FROM LCCNBAS.GCTR02HT T1
WHERE CHNGYM =   '"+globalMap.get("p_YM")+"'

Insert is very well...

i think, tDBRow is a problum...

thank you...

Re: tDBRow does not end

Anonymous — Mon, 06 Jan 2020 15:17:48 GMT

Hi,

I am slightly confused by your current job flow. I could see that you are extracting the data from source DB but in tDBRow, you are just doing table truncate. Why don't you do this step before reading the data from table and connect to tDBInput using On SubJob Ok component?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved