Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Problem with Execute SQL Script

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Feb 2009
    Posts
    10

    Default Problem with Execute SQL Script

    Hi all,
    I've a transformation that use the "Execute SQL Script" for writing into a log table.
    This step must be executed after the evaluation of a previously setted variable (a boolean), done by a "Filter Row" step, however irrespective of the value of this variable, the Execute SQL always run ... true or false this step run always ...
    The "Filter Row" run properly, indeed if I use a "Text file output" instead of the "Execute ..." when the condition is true the transformation go in a flow and when is false go in the opposite.
    The same thing appen if I use the "Switch/Case" instead of "Filter Row" ...

    There is a bug ?

  2. #2

    Default

    Samatar

  3. #3
    Join Date
    Feb 2009
    Posts
    10

    Default

    Quote Originally Posted by shassan2 View Post
    I read it, sorry, maybe I don't understand: this step run whatever condition there is in the transformation, before the "Execute ..." call itself ?
    Just put it in the transformation and it run ?

    Thanks

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.