How to update table with tDBOutput

Four Stars

How to update table with tDBOutput

Hello,

 

I tried to update data from a postgreSQl database using tDBOutput method and I have a mistake when I run the job.

L'élément du batch 0 UPDATE "public"."places" SET "expiration_date" = 2015-12-31 00:00:00.000000 +01:00:00 WHERE "null" = FRREGI_72 a été annulé. Appeler getNextException pour en connaître la cause.
caused by: ERROR: column "null" does not exist

Can you help me please.


Accepted Solutions
Ten Stars

Re: How to update table with tDBOutput

first link tdbCommit_1 with a "on subjob Ok" link.

Francois Denis

Tag as "solved" for others! Kudos to thanks!


All Replies
Ten Stars

Re: How to update table with tDBOutput

can you add print screen of your component?

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Four Stars

Re: How to update table with tDBOutput

I think I may have a problem with the connection. Because when I restarted the job few hours later it's worked but today I have the same mistake for an insertion.

Capture_Schema_Insertion.PNGinsertionCapture_schema_MAJ.PNGupdateCapture_job_MAJ.PNGupdate

Ten Stars

Re: How to update table with tDBOutput

first link tdbCommit_1 with a "on subjob Ok" link.

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Four Stars

Re: How to update table with tDBOutput

Thanks it's working