Have DDS Files Finally Gone Way Of The Dinosaur

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 you are blowing it big time like I was. Let me explain.

Continue reading “Have DDS Files Finally Gone Way Of The Dinosaur”

Why I Dislike Code Generators

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)
* EGL
* 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.

NOTE: The following is an OPINION and does not have any bearing on how easy or hard a particular language / application is to use.

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)
  • EGL
  • 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.

Continue reading “Why I Dislike Code Generators”

IBM i vs. MySQL: a Performance Test

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 the attention of Joe Pluta who challenged me to write a more rigorous test comparing MySQL and the AS/400. He claimed that the AS/400 would beat MySQL every time.

Joe, you were right.

Continue reading “IBM i vs. MySQL: a Performance Test”