- RPG IV Cheat Sheet: Built-In Functions
- RPG IV Cheat Sheet: Integer Data-Type Chart
- RPG IV Data-types vs SQL and API Documentation
- XML Parser Error Codes
- RPG IV Cheat Sheet: 5250 Hexadecimal Codes
- Work Around for Literals on %DEC Built-in Function
Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.
Bob Cozzi's RPG IV Cheat Sheets
Published by: Bob Cozzi on 08 Feb 2011 view comments
Data-Type Comparison for the RPG IV Language
These charts illustrate the relationship between data-types declared in the RPG IV programming language and those specified in IBM i (formerly OS/400 for AS/400) API documentation and the SQL language.
| API Documentation | Old RPGIII | RPG IV |
|---|---|---|
| Bin(2) | 4B 0 | 5i 0 |
| Bin(4) | 9B 0 | 10i 0 |
| UBin(2) | N/A | 5U 0 |
| UBin(4) | N/A | 10U 0 |
| INT2 | 4B 0 | 5i 0 |
| INT4 | 9B 0 | 10i 0 |
| UINT2 | N/A | 5U 0 |
| UINT4 | N/A | 10U 0 |
| SQL Data-Type | Old RPGIII | RPG IV |
|---|---|---|
| SMALLINT | 4B 0 | 5i 0 |
| INTEGER | 9B 0 | 10i 0 |
| BIGINT | N/A | 20i 0 |