Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Calling SQL stored procedure

  1. #1
    Join Date
    Nov 2015
    Posts
    6

    Default Calling SQL stored procedure

    Greetings,

    New user here, trying to figure out how to call a sql stored procedure (with passing parameters) that returns a result set back. Looking at 'call DB Procedure' step, got the parameters set up - runs fine, but returns nothing.

    Using v.6

    Any help is appreciated.

    Art

  2. #2
    Join Date
    Nov 2015
    Posts
    6

    Default

    Never mind, figured it out. Need to use Table Input step, and define parameters with a previous step, for instance Data Grid. Works now.


    Quote Originally Posted by artour View Post
    Greetings,

    New user here, trying to figure out how to call a sql stored procedure (with passing parameters) that returns a result set back. Looking at 'call DB Procedure' step, got the parameters set up - runs fine, but returns nothing.

    Using v.6

    Any help is appreciated.

    Art

  3. #3
    Join Date
    Oct 2015
    Posts
    9

    Default

    Hi,
    Could you please attach a sample .ktr?It will help me a lot.

    Thanks-

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.