AS400 Tutorials

Entries from October 25th, 2011

SQL Workaround For AS/400 Multi-Member Files

October 25th, 2011 Comments Off on SQL Workaround For AS/400 Multi-Member Files

One thing I really dislike¬†about the As/400, iSeries and IBM database system is the ability, or feature if you will, of being able to create multi-member data files. Multi-member files allow you to essentially create a database file with the same layout and structure but with a different “member” still a apart of the file […]

Tags:   · · ·

Not All Joins Are The Same

October 20th, 2011 Comments Off on Not All Joins Are The Same

When writing custom¬†reports you will eventually run into a situation where you want to be able to query data from two or more files, joining them together into the final report. This is where joins come in to play. Since relational databases, are well, relational if the data is similar or somehow related there should […]

Tags:   · · · · · ·

Check This Out

October 17th, 2011 Comments Off on Check This Out

I recently wrote an article for the Midrange IMHO blog. You can check it out here: http://imho.midrange.com/2011/09/07/the-green-screen-sucks-and-other-heresy/ -John Andersen

Tags:   · ·