Five Stars

Fill up a table and execute stored procedure in a job

Hi,

 

In my job I fill up a table with an InputFilePositional. After that I want to call a Postgres function which works on the inserted table's rows. My function must be called after the inserting process.

How can I do this whole job in my Job Designs?

 

My job looks like:

metadata -> tMap_1 -> myTable (PostgresOutput) : IT WORKS.

 

If I link this way:

metadata -> tMap_1 -> myTable (PostgresOutput) -> tDBRow (which call my function) the job does not works properly.

Tags (2)
1 REPLY
Moderator

Re: Fill up a table and execute stored procedure in a job

Hello,

Would you mind posting your tPostgresRow component setting screenshot on forum? The "call function" doesn't work.

Additionally, there is a global variable like ((Integer)globalMap.get("tDBOutput_1_NB_LINE_INSERTED"))) that counts the number of the inserted data.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.