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:
- Impact Analyser: Perform impact analysis for field or file changes to identify all files and programs accessing a specific field.
- Field Transformation: Display and modify all files and programs that utilize a specific field.
- Object Dependencies: Identify all programs that are invoking the specific program.
- 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.
- SQL Cursors vs. RPG Op Codes: Cursors offer more flexibility, simplifying data handling and maintainability.
- Single vs. Multiple Fetch: Choose single fetch for precision or multiple fetches for batch processing to optimize retrieval.
- Performance Tools: Use query hints and execution plans to enhance SQL performance in RPG applications.
