Loading…
COMMON India has ended
Welcome to COMMON India!

Here you can view our catalog of sessions and plan your conference
Tuesday February 25, 2025 1:00pm - 2:00pm IST
This session will empower yourself with the ability to scan your source file - Unlocking a world of multi-dimensional possibilities.

This session will also highlight Advanced Embedded SQL in RPG, covering SQL cursors, fetch techniques, and performance optimization tools to improve application efficiency and robustness.

Understand how an IBMi developer can leverage their skills to efficiently scan source code using RPG. This opens doors to a multiple powerful and versatile applications like:

  1. Impact Analyser: Perform impact analysis for field or file changes to identify all files and programs accessing a specific field.
  2. Field Transformation: Display and modify all files and programs that utilize a specific field.
  3. Object Dependencies: Identify all programs that are invoking the specific program.
  4. Coding Standard Inspector: Analyse code to identify deviations from coding standards.

Equip developers with advanced embedded SQL techniques to build more robust, efficient, and maintainable RPG applications by enhancing data manipulation, retrieval, and performance.
  1. SQL Cursors vs. RPG Op Codes: Cursors offer more flexibility, simplifying data handling and maintainability.
  2. Single vs. Multiple Fetch: Choose single fetch for precision or multiple fetches for batch processing to optimize retrieval.
  3.  Performance Tools: Use query hints and execution plans to enhance SQL performance in RPG applications.
Speakers
avatar for Pavan Thute

Pavan Thute

Senior Software Engineer, Rocket Software, Rocket Software
Pavan is a Senior Software Engineer with 15 years of experience in IBM i technology, has worked as an AS400 developer, team lead, and corporate trainer.He has contributed to companies like IBM, ANZ, Mphasis, CETAS Shipping and conducted IBM i training for organizations such as UST... Read More →
avatar for Gopinath Ravi

Gopinath Ravi

Senior Software Engineer, Rocket Software, Rocket Software
Gopinath is a Senior Software Engineer with 9 years of experience in developing and improving applications on the IBM i platform. Over the years, he’s successfully led several projects and is currently heading the development for Rocket DevOps team at Rocket Software. Known for... Read More →
avatar for Shridhar Srinivasan

Shridhar Srinivasan

Senior Manager, Software Engineering, Rocket Software, Rocket Software
Shridhar is a Senior Manager, Software Engineering at Rocket Software with over two decades of experience in software engineering. He currently leads the product development for the Rocket DevOps solution for IBM i and Enterprise, driving innovation and ensuring high-quality, timely... Read More →
Tuesday February 25, 2025 1:00pm - 2:00pm IST
Newton

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

Share Modal

Share this link via

Or copy link