COMMON POWERUp 2025

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.