RE: Is SQL cursor open at the job level?

Michael,

Using ACTGRP(*NEW) allows you to call an RPG IV program recursively,
even though technically RPG IV programs don't support recursion.

Lim could make his recursive procedure into a stand alone program that
used ACTGRP(*NEW).

That would get the job done, but performance would be comparatively
horrible (due to the ACTGRP(*NEW)).  It might suffice if he's only going
a few levels deep for a few items at a time.

HTH,


Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx 
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of 
> Michael_Schutte@xxxxxxxxxxxx
> Sent: Wednesday, April 12, 2006 4:31 PM
> To: RPG programming on the AS400 / iSeries
> Subject: RE: Is SQL cursor open at the job level?
> 
> I read it somewhere.  I'll have to find it again.  But it was 
> something
> like that to allow recursive calls.
> 
> Michael Schutte
> Work 614-492-7419
> email  michael_schutte@xxxxxxxxxxxx
>