Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: sql sentence to file

  1. #1
    Join Date
    Jan 2009
    Posts
    11

    Default sql sentence to file

    Hello people,

    Is there any way to get the text string that the step "update" generate? ie, I want to pass to file the sentence sql and not to run in ddbb.

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    No, the Update step doesn't give you the generated SQL statements.

    Generate them yourself - no big deal.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Jan 2009
    Posts
    11

    Default

    I created a plugins based on "sql file output". This process generates UPDATE statement in a file ("append").
    In a second process, i run the SQL file into a "job". Then I managed to have transactions with different database transformations.


    NOTE: I also managed to lower execution times with the idea of ​​generating sentences in a file, 60% of the time!!!

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.