RE: SQLRPGLE won't compile...

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx 
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of 
> SRamanujan@xxxxxxxxxxxxxxxxxx
> Sent: Tuesday, April 05, 2005 11:25 AM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: RE: SQLRPGLE won't compile...
> 
> 
> Hi Frank,
> Yes, please select the fields that you have declare in the 
> DS. Or create a ds with only 2/3 fields that you are 
> selecting.  Please also remove the qualified, this also works 
> from v5r3.
> 
> SQL is great and I was commenting more on your multiple row 
> fetch which you need not do for the kind of process you are 
> working on.  If you are replacing a read, I suggest you could 
> fetch in a loop as below.  (If you are going this route, 
> please change you multiple occurs DS to single.)
> 
> Declare cursor ..
> Open cursor 
> Dou sqlstt/sqlcod check
>       Fetch cursor into :MyDs
>       doAllProcess()
> enddo
> close cursor          
> 
> HTH.
> Thanks,
> Sudha
> 
> Sudha Ramanujan
> SunGard Futures Systems
> sramanujan@xxxxxxxxxxxxxxxxxx
> (312) 577 6179
> (312) 577 6101 - Fax
> 

But if he's trying to get the best performance out of SQL, and according to the 
original post he is; then he does need to be using a multi-row fetch.

In fact, I'd recommend that he up the number of rows fetched at a time.  If I 
recall correctly, from Joe Pluta's IAAB website, SQL out performs RPG at 100+ 
rows.  If his report has 50 lines on a page, then do a fetch of some multiple 
of 50.  The more rows you fetch, the faster it will perform, but it will also 
use more memory.


HTH,
Charles