AS400 Tutorials

Entries Tagged as 'iSeries'

Leveraging Query/400 And SQL

September 17th, 2012 Comments Off

I think it’s time to start talking up the benefits of SQL on the IBM i, AS/400 and iSeries. When I first started out on the system we did not have the licensed programs to make use of SQL… when I moved on to another company that had it I quickly realized what I had […]

Tags:   · · · · · ·

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:   · · · · · ·