Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Variables and Arguments in a SQL Script Step

  1. #1

    Default Variables and Arguments in a SQL Script Step

    Hi guys,

    I set variables 1 and 2 from within a transformation. The workflow continues and reaches a new transformation that uses one previously set variable but at the same time the tranformation retrieves a list to be exeuted step by step in and SQL Query.

    SQL script: Alter table TMP_${MESCOL}_PORENTIDAD ADD [${MESCOL}-?] float

    The question is, if In a SQL Script, I can use an environment variable and at the same time define arguments, so both values will be replaced.

    I have made several tries and only one works at a time, not both.

    Any suggestions.

    Regards,

    Ben

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

    Default

    I think it was recently changed in 3.0, so not in 2.5

    Regards,
    Sven

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.