AS400 Tutorials

Entries from October 25th, 2011

SQL Workaround For AS/400 Multi-Member Files

October 25th, 2011 Comments Off

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

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

I recently wrote an article for the Midrange IMHO blog. You can check it out here: -John Andersen

Tags:   · ·