Plex 2E

Expand all | Collapse all

iSeries Stored Procedures

Jump to Best Answer
  • 1.  iSeries Stored Procedures

    Posted 06-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 10-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 02-17-2016 07:18 AM

    Hi George

     

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

     

    Regards,

     

    Tjaart