RE: SQL RPG question

[James Rich <james@xxxxxxxxxxx>]

On Fri, 28 Oct 2011, Morgan, Paul wrote:

> Why declare two cursors when one will do?
>
> Declare C1 cursor for
>  select CMCSNAME, CMADDR1, CMCITY, CMCST#6, CMCST#3
>    from CUSTML1
>   where CMCSNAME >= :SHCSNAME
>     and CMCSNAME LIKE:csgrpkwda
>     and :SHCO# IN( 0, CMSRVCO# )
>     and CMDEL <> 'D'
> order by CMCSNAME

That worked perfectly, thanks!

James Rich

if you want to understand why that is, there are many good books on
the design of operating systems. please pass them along to redmond
when you're done reading them :)
	- Paul Davis on ardour-dev