RE: Help with SQL statement Performance

Rob wrote:

What? SETLL/READ/CHAIN?
Input Primary has a much better blocking factor.
While true, I only meant it as sarcasm. Have a nice weekend.
:-)

Rob -

LOL, funny you mention that.
For what it's worth, last week I wrote my first cycle program in over 30 years:

(F0911SRE1 is a view over the JDE F0911 file)

FF0911SRE1 UP E DISK
FF55LPSRE1 IF E K DISK

D KYSRE ds LIKEREC( I55LPSRE1 : *KEY )

KYSRE.SRICU = GLICU;
KYSRE.SRICUT = GLICUT;
Chain %KDS( KYSRE ) I55LPSRE1;
If %Found( F55LPSRE1 );
If SRPM01 = *blanks;
Except RELEAS0911;
Else;
GLPM01 = SRPM01;
Except UPDT0911;
EndIf;
EndIf;

OI0911 E UPDT0911
O GLPM01

O E RELEAS0911