Pivoting with SQL Kent Milligan – IBM Technology Expert Labs

​Now that each employee’s deduction has a unique identifier associated with it, the next step is getting those individual deduction column values into a single row for each employee.
The Partition By keyword on the Row_Number specification is what causes the seqnum column (i.e., the unique identifier) value to reset to 1 when it encounters the deductions for a different employee. Read More 

RPG Trek, The Next Generation Jack Woehr

​Our client “Bruce” was discussing the RPG talent shortfall and how to get the next generation on board to write and maintain legacy RPG code dating back to the 1980s. Bruce had a System 36 manufacturing application written in fixed-format RPG. The system was solid and users were satisfied. But Bruce knew that he had to modernize the code for ease of maintenance and to expand the developer talent pool for future applications. Bruce knew that he had to modernize the code for ease of maintenance and to expand the developer talent pool for future applications. The Solution Bruce’s team…
The post RPG Trek, The Next Generation appeared first on Seiden Group. Read More 

Verified by MonsterInsights