Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: parameter usage in Execute SQL Script

  1. #1

    Default parameter usage in Execute SQL Script

    i define:

    select (t2.datum - t1.datum) into return
    from d_date t1,
    d_date t2
    where t1.datum_id = t2.datum_id
    and t1.datum = datetime_created
    and t2.datum = dt_afgesloten;

    where datetime_created and dt_afgesloten are to parameters that are defined and are incoming in the expression. I also have enabled the "Execute for each row" option. Still this returns in a error. it says:

    unknown column 'datetime_created' in where clause

    how do i use the parameters in a query?

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

    Default

    Use ?'s ... the arguments are positional not by name... and note that the sql step replacement the ?'s on it's own... so they're not "officially" parameter markers.

    Regards,
    Sven

  3. #3

    Default

    you are so right! thanks for the help

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.