COMMON India

Managing the IBM i does not have to be a walk though the green screen, much of the system management capabilities are available using an intuitive modern web based interface – IBM Navigator. This session will introduce this new interface and spend ALL of the time, SHOWING how you can manage many aspects of the IBM i with Live Demo! Audit Journal, Monitoring, Active Jobs, Advanced Job Scheduled, Performance, User Profile Management, and so much more. Come with your favorite questions and we will demo your favorites.

Learn how the recent enhancements to RPG have added many new features and enhancements to the way you can use arrays. This will include all the new Built in Functions, Data Structure arrays, and dynamic arrays.

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.

In the tradition of previous Technology Refreshes (TR), the database team is delivering enhancements on the same cadence. Attend this session to hear about the many enhancements to SQL on i, SQL Query Engine, IBM i Services and more. This session will cover the new and enhanced Db2 for i capabilities added to IBM i 7.4 and IBM i 7.5 over the most recent IBM i Technology Refreshes.

Please join us in exploring the various developments & strong ongoing ISV ecosystem we have for our esteemed IBM i customers. We will discuss about few ISVs & their capabilities prevailing to ISA & APAC markets.