If you are still cranking out the traditional physical and logical file with DDS I think it’s time to get up to speed with SQL for both creating and querying files. For a long time I held onto using DDS, but with the capabilities in SQL if you are still clinging to DDS I think [...]
Those of you who follow the midrange.com lists probably are aware that I’m not a big fan of application code generators.
This includes (but is not limited to) …
* Case Tools (AS/SET, Synon, etc)
* SQL Pre-processors (RPG SQL, COBOL SQL, etc)
* JSP (to a limited extent)
* Various 3rd party application generators
The reason is simple … the code you write is not the code that executes.
A few years ago, I expressed on the midrange-l mailing list some frustration I was having regarding database performance on an AS/400. I recall saying something like … MySQL vastly outperforms the AS/400. For the tests I was doing, it appeared that MySQL was indeed faster. My tests weren’t very rigorous, however. My posts caught [...]
I’ve recently been working on an ILE RPG program that needs to read a SQL table that has a VARCHAR column encoded with CCSID 1200 (Unicode). Since RPG doesn’t normally handle Unicode, it takes a little extra effort to process the contents. Here’s a quick example of how you handle this data …