Guru: Alternate SQL Row-Selection Criteria Revisited Revisited

I am not a “do as I say and not as I do” kind of person. After I wrote the article Guru: Alternate SQL Row-Selection Criteria Revisited, I got serious about using dynamic SQL in my RPG programs instead of enabling and disabling logical expressions in the WHERE clause. I’m reliving the days when OPNQRYF was my best friend, trying to make apostrophes play nice with string concatenation.

Overall, I’m happy with the change. When I have converted the switch-laden version to dynamic SQL, I have seen a noticeable performance improvement in some cases, and at least a slight

The post Guru: Alternate SQL Row-Selection Criteria Revisited Revisited appeared first on IT Jungle.

Verified by MonsterInsights