midrange.com – In My Humble Opinion

Words of wisdom and insight from the IBM i (System i / iSeries / AS400) community

Browsing Posts tagged sql

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

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 …

css.php

© 1993-2014 midrange.com - In My Humble Opinion All Rights Reserved