Improve your application and system performance by eliminating the usage of QTEMP objects.
By Kent Milligan
After recently returning from five years of working on IBM Watson solutions, I was hoping that IBM i developers had moved away from using QTEMP tables with SQL. Yet the first two customer projects that I worked on featured SQL performance issues caused by improper usage of QTEMP. Based on this recent experience, I thought it would be good to highlight the top three reasons why programmers should not mix SQL with QTEMP in application code.