RE: SQL Update in RPGLE.

Not really.  When you consider that when RPG doesn't have an access
path, it has to read every record.

SQL _might_ have to do the same thing.  But the advantage SQL has over
RPG is that SQL can build a new access path on the fly from multiple
existing access paths.

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: Thursday, March 30, 2006 4:22 PM
> To: RPG programming on the AS400 / iSeries
> Subject: RE: SQL Update in RPGLE.
> 
> Except when SQL has to create the ACCESS PATH.  If there 
> isn't an already
> defined access path, SQL will build one and then the length 
> becomes longer.
> 
> Michael Schutte
> Work 614-492-7419
> email  michael_schutte@xxxxxxxxxxxx
> 
> 
>                                                               
>              
>              "Wilt, Charles"                                  
>              
>              <CWilt@xxxxxxxxxx                                
>              
>              om>                                              
>           To 
>              Sent by:                  "RPG programming on 
> the AS400 /     
>              rpg400-l-bounces@         iSeries" 
> <rpg400-l@xxxxxxxxxxxx>    
>              midrange.com                                     
>           cc 
>                                                               
>              
>                                                               
>      Subject 
>              03/30/2006 04:14          RE: SQL Update in 
> RPGLE.            
>              PM                                               
>              
>                                                               
>              
>                                                               
>              
>              Please respond to                                
>              
>               RPG programming                                 
>              
>               on the AS400 /                                  
>              
>                   iSeries                                     
>              
>              <rpg400-l@midrang                                
>              
>                   e.com>                                      
>              
>                                                               
>              
>                                                               
>              
> 
> 
> 
> 
> RPGLE is not "definitely much faster" than SQL.
> 
> RPGLE is faster when working one record at a time.  Once you start
> working with multiple records, then SQL moves ahead.
> 
> 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 Mike Troxclaire
> > Sent: Thursday, March 30, 2006 3:57 PM
> > To: rpg400-l@xxxxxxxxxxxx
> > Subject: RE: SQL Update in RPGLE.
> >
> > All the inputs are correct and I agree that there is no need
> > for SQL if only
> > one file is involved but I already have a ready made
> > complicated SQL query
> > so I wanted to go the SQL way. I agree that F specs were not
> > needed at all.
> > The update query ran just fine when I added "WITH NC" at the
> > end of the SQL
> > statement.
> >
> >   It would be very interesting to see some input on
> > performance when it
> > comes to SQL compared to RPGLE. RPGLE would definitely be
> > much faster but
> > just wondering by how much. I have atleast 12 files in my
> > UPDATE statement.
> >
> > Cheers,
> >
> > Mike.
> >
> > _________________________________________________________________
> 
> --
> This is the RPG programming on the AS400 / 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.
> 
> 
> 
> -- 
> This is the RPG programming on the AS400 / 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.
> 
>