Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Call Stored Procedure passng entire row

  1. #1
    Join Date
    Aug 2007
    Posts
    2

    Default Call Stored Procedure passng entire row

    Hi,

    I'm creating transformation which will help in keeping two different databases synchronised (both Postgresql databases). I would like to call a function which accepts a row.

    Is there any way of passing the current row as an argument?

    Thanks in advance

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    No... not as "THE row", a row in PDI is not the same as a row in the database... you have to put in the columns.

    On a side note, there are better tools out there to synchronize databases than Kettle/PDI

    Regards,
    Sven

  3. #3
    Join Date
    Aug 2007
    Posts
    2

    Default

    Hi,

    thanks for the reply. I'll have to change some function then to make then...

    Yes there are better tools for db synchronisation, but this is a very weird scenario..

    Thanks again

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.