RE: SQL Update in RPGLE.

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.
> 
> _________________________________________________________________