Loading…
POWERUp 2020 has ended
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?
Back To Schedule
Tuesday, September 1 • 2:45pm - 3:45pm
Optimizing batch processing with SQL

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Tweet Share
Native file processing has been used for years, showing to be a very strong yet simple way of accessing, analyzing, and maintaining data in IBM i. Time has passed since the appearance of SQL in the platform, and it is still looked by many traditional developers as “too modern, complex, not that easy”. I’ve been working on batch processing optimization, and find that the replacement of traditional file processing with SQL processing has many performance advantages. Also permits the use of many features that can replace part of program logic. In this session we’ll walk thru some case studies, and show you how SQL can help in optimization issues.
Identify potential programs that need to be optimized Learn the basics of replacing native file processing with SQL
Speakers
avatar for Cecilia Howlin

Cecilia Howlin

Owner, PYRAMIS S.R.L.
Cecilia Howlin has been working on this platform from the very beginning. On her first job at IBM Argentina, she learned S/38. And never left the platform, since she thinks it never appeared other operating system as good as this one.She usually worked on technical issues, like installing... Read More →

Tuesday September 1, 2020 2:45pm - 3:45pm EDT
Hanover E
  Database
  • LEVEL Intermediate
  • AUDIENCE Development people who have performance issues in native long running programs

Attendees (7)