Loading…
Attending this event?
THE BEST IBM i & POWER SYSTEMS EDUCATION.When you come to POWERUp, you’ll be able to customize your experience. Choose from 300 sessions, covering over 20 areas of IT, when you plan your schedule. Visit the largest Expo of its kind and meet the experts behind the solutions. Attend social events to meet renowned speakers and peers alike. This conference is structured to give you the pure education and professional connections needed to best enhance your career. Are you ready to POWERUp?

Exhibitor Hall: https://www.expocad.com/host/fx/common/s24/exfx.html

Exhibitor Hall Map Here 
Thursday, May 23 • 8:00am - 9:00am
135: Optimizing Batch Processing with SQL

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

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 found 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.

Learning Objectives:
1- Identify potential programs that need to be optimized
2- 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 →


Thursday May 23, 2024 8:00am - 9:00am CDT
Meeting Room 103A 1508 Houston St, Fort Worth, TX 76102
  Programming - General
  • Session Level Intermediate
  • Digital Badge SQL
  • Audience Development people who have performance issues in native long running programs