Re: Stored Procedure to return data set to MS SQL call

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Just open a cursor and don't close it in your SP.

Any opened cursors when the SP ends are returned.

create procedure myproc
  language SQL
  dynamic result set 1
begin
  declare c1 cursor with return for
    select * from sysibm.sysdummy1;

  open c1;
end;



On Thu, Mar 12, 2015 at 11:26 AM, (WalzCraft) Jerry Forss <
JForss@xxxxxxxxxxxxx> wrote:

> Howdy,
>
> We have a system here that uses MS SQL Server.
>
> I have created several Stored Procedures that they call using parameters.
> Example of they send me Customer Number and I return Customer Name.
> Works great.
>
> I want to start using stored procedures to return data sets that may be
> created using SQL or put together by a program.
>
> Does anyone have good examples of how to do that or docs that can explain
> how to do it?
>
> Thanks!!!!
>
>
> Subject to Change Notice:
>
> WalzCraft reserves the right to improve designs, and to change
> specifications without notice.
>
> Confidentiality Notice:
>
> This message and any attachments may contain confidential and privileged
> information that is protected by law. The information contained herein is
> transmitted for the sole use of the intended recipient(s) and should "only"
> pertain to "WalzCraft" company matters. If you are not the intended
> recipient or designated agent of the recipient of such information, you are
> hereby notified that any use, dissemination, copying or retention of this
> email or the information contained herein is strictly prohibited and may
> subject you to penalties under federal and/or state law. If you received
> this email in error, please notify the sender immediately and permanently
> delete this email. Thank You;
>
> WalzCraft PO Box 1748 La Crosse, WI. 54602-1748
>
> www.walzcraft.com<http://www.walzcraft.com/> Phone... 800-237-1326
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.