Plex 2E

 View Only
  • 1.  iSeries Stored Procedures

    Posted Jun 06, 2014 08:37 AM

    Hi

    I would like to use a stored procedure on the iSeries in Plex.  Now I have read a couple of articles regarding returning the result set into a cursor, but struggling to put it into practice so that we can use a blockfetch type function to retrieve the data.

    Has anyone here have an example of using a stored procedure.  Our iSeries is on v6.1 of the OS.

    Regards,

    Tjaart van der Walt



  • 2.  Re: iSeries Stored Procedures

    Posted Oct 22, 2014 10:50 AM

    Any examples to offer tjaartvdw?

     

    Tjaart van der Walt wrote:

     

    Hi

    I would like to use a stored procedure on the iSeries in Plex.  Now I have read a couple of articles regarding returning the result set into a cursor, but struggling to put it into practice so that we can use a blockfetch type function to retrieve the data.

    Has anyone here have an example of using a stored procedure.  Our iSeries is on v6.1 of the OS.

    Regards,

    Tjaart van der Walt



  • 3.  Re: iSeries Stored Procedures



  • 4.  Re: iSeries Stored Procedures
    Best Answer

    Posted Feb 17, 2016 07:18 AM

    Hi George

     

    I found the solution and it was to do with the sequence of parameters.

     

    Regards,

     

    Tjaart