hmmm, unfortunately this is sad but true.
The science of database must be understood before the art of database can be practiced. This includes the relatively simple task of comparing a column's value to a literal. How hard can it be to compare and test for blanks? You know, the spaces sitting in a
Well, apparently it's more difficult on some platforms than others, and SQL coders jump through hoops and attempt back flips to "help" the database engine.
For more information and coaching on the topic, please see Kent Milligan's excellent article on the topic here.
If you want to get better at understanding the science of DB2 for i, and proficient at practicing the art of relational database with IBM i, then please reach out - we're here to help you become successful.