Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Variables not replaced

  1. #1
    Join Date
    May 2009
    Posts
    3

    Default Variables not replaced

    Hello,

    First : excuse me for my poor english ^^

    Now my problem :

    I have a problem with environment variables.
    I set some variables with value and use some of them to connect to my database. And i save the others in a table.

    For my connection : it works. The variables is replaced by their values with no problem.

    But for the saving : the variables isn't replaced. Ex : if i have a variable DB_NAME, it will save me ${DB_NAME} in my table.

    I have this problem only since yesterday. Before it worked.

    Someone has an idea to solve this issue ?

    Thanks a lot!

  2. #2
    Join Date
    Feb 2009
    Posts
    321

    Default

    you have a table input step?? enable the option "replace variables"
    anyway post the ktr...

  3. #3
    Join Date
    May 2009
    Posts
    3

    Default

    I have no table input.
    My saving is done by a procedure.

    And if i switch it with a XML output, there is no change.

    I put one of my ktr.

    PS : If i do it with a table input, it works
    Attached Files Attached Files
    Last edited by Gadom; 06-22-2009 at 11:16 AM.

  4. #4
    Join Date
    Feb 2009
    Posts
    321

    Default

    another option is use the step "get Variables" (replace your step "Arguments Log 3" ) that`s works too...

    other option:
    you can use the sentence "call" in a "sql Script" step.

  5. #5
    Join Date
    May 2009
    Posts
    3

    Default

    Thanks a lot Hernanthiebaut.
    I use the step "get variables" and it works very well now

  6. #6
    Join Date
    Feb 2009
    Posts
    321

    Talking

    you're welcome

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.