Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Problem with executing SQL query with parametres

  1. #1

    Default Problem with executing SQL query with parametres

    Hi all,

    Ive got problem in kettle.

    1. Ive got a text file containing parametres. This file looks like this:

    Input.txt:

    source_project;destination_project;start_date;finish_date;login
    5;2;17.9.2007;21.9.2007;560

    2. Then i want to use these parametres in execution of Select SQL query, but it doesnt work

    The SQL query shows this picture:




    After running this transformation kettle write error message like: Unsupported lexical unit.

    Can U help me pls ?

    Thx

    Paul

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

    Default

    If you read the text above the big input field you will see "Question marks will be replaced by arguments". Probably it should read "Question marks will be replaced by input fields"

    So they way you want to use the input fields as variables won't work. The question marks will be replaced by the input fields in a positional way (the fields in your input row have to appear in the right order).

    Regards,
    Sven

  3. #3

    Default

    I dont catch your point exactly...So how it should be declared exactly?


    Thx


    Quote Originally Posted by sboden View Post
    If you read the text above the big input field you will see "Question marks will be replaced by arguments". Probably it should read "Question marks will be replaced by input fields"

    So they way you want to use the input fields as variables won't work. The question marks will be replaced by the input fields in a positional way (the fields in your input row have to appear in the right order).

    Regards,
    Sven

  4. #4

    Default

    Ive got it!!!



    Thx for help, mate


    Quote Originally Posted by paveluk View Post
    I dont catch your point exactly...So how it should be declared exactly?


    Thx

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.