A co-worker pointed out an interesting clause in the DB2 CREATE TABLE and CREATE INDEX statements. If you’re like us and trying to integrate some DB2/SQL with your legacy S/3x applications, you may have run into a case where you need to differentiate between your table name and the record Continue Reading →

If you work in an environment with many iSeries servers, it might be necessary to embed the system name in an SQL query.  Fortunately, IBM provides a system table called “LOCATIONS”.  If you query this table and limit your search to only return the “local” entry, the system will tell Continue Reading →