RE: Program performance incease ideas

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

Just a thgouht, but the trim(ivptcl) probably makes the SQL engine
unable to use the key for the WHERE clause.

Joe

> From: Brian Piotrowski
> 
> 
> Here's the raw code I am using:
> 
>       /free
>          read sswihi;
>          dow not %eof(sswihi);
>            SQLstmt ='select sum(ivpqty)';
>            SQLstmt = SQLstmt +' from sst37t2';
>            SQLstmt = SQLstmt +' where
ivptno='+apos+%trim(ihptno)+apos;
>            SQLstmt = SQLstmt +' and
> trim(ivptcl)='+apos+%trim(ihptcl)+apos;
>            SQLstmt = SQLstmt +' group by ivplcd, ivptno, ivptcl';
>       /end-free