rpg-migration-analyzer
from dauquangthanh/hanoi-rainbow
Agent Skills, Custom Agents and Corresponding Software Development Workflow Commands.
npx skills add https://github.com/dauquangthanh/hanoi-rainbow --skill rpg-migration-analyzerSKILL.md
RPG Migration Analyzer
Analyzes legacy RPG programs (RPG III/IV/ILE) from AS/400 and IBM i systems for migration to modern Java applications, extracting business logic, data structures, file operations, and generating actionable migration strategies.
Overview
This skill provides comprehensive analysis and migration planning for RPG (Report Program Generator) applications. It extracts program specifications, converts RPG data types to Java equivalents, maps file operations to modern database access patterns, and generates implementation-ready Java code structures.
Key Migration Focus: RPG to Java with proper handling of packed decimals (BigDecimal), data structures (POJOs), file operations (JPA/JDBC), indicators (boolean variables), and business logic preservation.
When to Use This Skill
Use this skill when:
- Analyzing RPG source files (.rpg, .rpgle, .RPGLE) for modernization
- Planning migration from AS/400 or IBM i systems to Java
- Converting RPG data structures (D-specs) to Java classes
- Mapping RPG file operations (F-specs) to database access patterns
- Understanding RPG program dependencies and call chains
- Generating Java code equivalents from RPG business logic
- Estimating complexity and effort for RPG migration projects
- Creating migration documentation and strategy reports
- Modernizing legacy mainframe applications to microservices
- User mentions: RPG analysis, AS/400 migration, IBM i modernization, Report Program Generator, packed decimal conversion
Core Capabilities
1. Program Analysis
Extract and analyze RPG program components:
- Specification types: H-spec (header/control), F-spec (file definitions), D-spec (data definitions), C-spec (calculation/logic), P-spec (procedures)
- Data structures: D-specs with nested structures, arrays (DIM), external references (EXTNAME), qualifiers (LIKEDS, QUALIFIED)
- File definitions: Physical files, logical files, display files (WORKSTN), printer files
- Business logic: Calculation specifications, control structures (IF/ELSE/DO/FOR), expressions (EVAL)
- Indicators: Legacy indicators (*IN01-*IN99), built-in indicators (*INLR,*INOF)
- Built-in functions: String functions (%SUBST, %TRIM, %SCAN), date functions (%DATE, %DAYS), math functions (%DEC, %INT), file status (%EOF, %FOUND, %ERROR)
- Error handling: %ERROR, %STATUS, ON-ERROR blocks
2. Data Structure Mapping
Convert RPG data definitions to Java equivalents:
- D-spec conversion: Data structure definitions to Java classes (POJOs)
- Data type mapping:
- Packed decimal (P) →
BigDecimal(preserve precision) - Zoned decimal (S) →
BigDecimal(decimal with sign) - Character (A) →
String - Date (D) →
LocalDate - Time (T) →
LocalTime - Timestamp (Z) →
LocalDateTime - Indicator (N) →
boolean - Binary integer (I) →
intorlong
- Packed decimal (P) →
- Arrays (DIM): Convert to Java
List<T>or arraysT[] - Nested data structures: Convert LIKEDS to nested Java classes
- External data structures (EXTNAME): Generate JPA entities from database table definitions
- Initialization (INZ): Map to Java field initializers or constructors
3. File Operations
Parse and convert RPG file I/O to modern database access:
- File types: Physical files (DISK), logical files (keyed access), display files (WORKSTN), printer files (PRINTER)
- Access methods: Sequential (full read), keyed (direct access by key), arrival sequence
- I/O operations:
- READ/READE → JPA query methods, JDBC ResultSet iteration
- WRITE → JPA persist(), JDBC INSERT
- UPDATE → JPA merge(), JDBC UPDATE
- DELETE → JPA remove(), JDBC DELETE
- CHAIN → JPA findById(), Optional pattern
- SETLL/READE loop → JPA findBy...() queries with ordering
- File status: %EOF (end of file), %FOUND (record found), %ERROR (I/O error) → Java exceptions or Optional
- Transaction boundaries: Identify commit boundaries (COMMIT operation code)
4. Java Migration Strategy
Generate modern Java implementation patterns:
- POJOs: Plain Old Java Objects from D-spec data structures
- JPA Entities: @Entity annotations for database tables (from EXTNAME files)
- Repository pattern: Spring Data JPA repositories for file operations
- Service methods: Business logic from procedures and subroutines
- Bean Validation: @NotNull, @Size, @DecimalMin/Max from RPG field validations
- Exception handling: Convert %ERROR patterns to try-catch blocks with custom exceptions
- Collections: Java Collections API (List, Map, Set) from RPG arrays and data structures
- DTOs: Data Transfer Objects for service boundaries
- Transaction management: @Transactional annotations for commit boundaries
5. Dependency Analysis
Map program relationships and external dependencies:
- Program calls: CALLB (bound procedure calls), CALLP (prototyped procedure calls)
- Service programs: BNDDIR (binding directories), *SRVPGM objects
- **File d
...