Attending this event?
Join your friends and colleagues in the COMMON community at POWERUp 2020. In the company of peers and over 100 industry experts, you’ll enjoy the best in Power Systems and IBM i education over the course of 4 days. View the list of nearly 400 sessions, which cover over 20 areas of IT. POWERUp also boasts the largest exposition of its kind. This conference is structured to give you the pure education and professional connections needed to best enhance your career. Are you ready to POWERUp?
avatar for Rex Smith

Rex Smith

Tegratecs Development Corp.
Sr. Developer (ERP & Web)
Schaumburg, IL
Rex is a Sr. Developer at Tegratecs and enjoys developing business applications in traditional IBM i environments and in web environments. Rex enjoys interacting with customers and designing business application software that solves problems and meets user needs. He is currently doing business application development using c#, Db2 for i, RPG (both newer and older), CLP, SQL Server and ASP.NET.

Rex first learned SQL, relational join concepts, and Query by Example at Indiana University, so back in the early years of the IBM midrange he was quick to embrace query tools and OPNQRYF with joins and dynamic selection criteria. Rex is still a fan of RLA (record level access) and READE for business applications used in internal IBM i environments. But he feels that SQL is likely the best choice for web environments especially when it comes to database update transactions.

Rex is a huge fan of late model Db2 for i features, speed and power. Rex has dedicated quite a bit of time over the last eight years learning, prototyping and developing techniques for accessing and updating Db2 for i and SQL Server in business application scenarios. Rex feels there is a bit of a gap in knowledge and technique out there in the world, at least when it comes to maintaining large multi-user databases using SQL, with the same level of granularity and concurrency we have grown to expect from our IBM i applications. Rex will be doing a session at POWERUp2020 called Creating a Master File Data Layer with SQL PL, which will hopefully fill you in with intriguing details on what he is up to in this topic area and to (definitely) expose his production techniques when it comes to master files.

Rex is Sr. Developer, ERP & Web at Tegratecs Development Corp. based in Schaumburg, IL, a suburb of Chicago. He currently calls Indianapolis his home base. Rex is on the Board of The Omni User, a Chicago-based user group focusing on IBM i and surrounding technologies. In his spare time, Rex loves to golf and play keyboards.

My Speakers Sessions

Wednesday, September 2