Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Question ab "Call DB Procedure" Step

  1. #1
    Join Date
    Dec 2006
    Posts
    106

    Default Question ab "Call DB Procedure" Step

    Dear all..

    its very clear to know that we can call a stored procedure or a function by applying "Call DB Procedure" Step in Kettle.
    But it just can support returning a Scalar value(ex. a string or a int). I mean that if i want to call a Table-valued function, how can I do?
    can Kettle support that? or is there any way to design such requirement?
    Thanks for giving me solutions..

    Regards,
    Jeff

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

    Default

    No table-value output... probably easiest would be to select from your table-value output using a table input step.

    Regards,
    Sven

  3. #3
    Join Date
    Dec 2006
    Posts
    106

    Default

    Thx Sven..
    thats wut i think to solve my problem as well as u

    Regards,
    Jeff

  4. #4
    Join Date
    Jan 2008
    Posts
    1

    Default pivot option in spoon

    Hi guyz
    im facing a problem of creating a database table with its attributes being rows of some other table. im working on mysql as my back-end. i guess i need a pivot option to deal with my problem but just cant figure out if the spoon tool has this pivot option. apart from this if any one has some way out kindly let me noe.


    thx
    Vyom

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.