tDBRow does not end

[Anonymous]

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..

[Anonymous]

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

[Anonymous]

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...

[Anonymous]

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