Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Problems with calling a db procedure on Informix

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Default Problems with calling a db procedure on Informix

    Hi,

    I am trying to use an informix stored procedure that takes two fields as input and returns a value.
    In Informix:
    Code:
    call plz2bl('12345', 'Town');
     
    (expression)       
     
    Nordrhein-Westfalen
    When I use the DB Procedure Call step and leave result name empty and enter the two fields as parameters and nothing more, the procedure seems to be found and of course I get no result. If I enter a result name I get "Function doesn't have an output parameter or the out parameter isn't returned". If I enter a parameter with type Out, I am being told that the "routine (plz2bl) can not be resolved."

    What am I doing wrong?

    Thanks in advance

    Holger
    Last edited by Hymmen; 04-07-2009 at 09:15 AM.

  2. #2

    Default

    Is nobody using this feature?

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.