RPG & SQL: Style and productivity: Guide to coding style, practices and productivity tools for the IBM i platform

RPG & SQL: Style and productivity: Guide to coding style, practices and productivity tools for the IBM i platform

Advices, practices, techniques, practical examples for those who develop on the IBM i Power platform.Tips and suggestions, to exploit every day or put aside for using when needed. Many ideas to supply our personal "toolbox" and feel encouraged to learn more, and to search for something new and better.Also, you can find a large section with a number of tools (even free!) to improve productivity, and Web resources to stay up to date!Full summary:Part 1: Style• RPG "full free": the benefits of the new syntax• The new RPG• Naming conventions and coding style• ILE galore: Service programs, binding directories, binder language• SQL: unleash its power• SQL naming - SQL options - Fetch loop with cursor - Blocked fetch loop - Retrieval of single values - Dynamically built instructions - The System catalog: a mine of information - The power of user-defined functions (UDF, UDTF) - SQL Triggers - MQTs - OLAP Functions - Cryptographic Functions - Handling of XML and JSON Data - Examples for all tastes• Database: DDS or DDL?• CL has been modernized, too• Qshell's hidden treasures • Practices to manage customizations• Documentation is important!Part 2: Productivity tools • Public IBM i• RDi: Rational Developer for i• MI Workplace• ILEditor• SQL Workbench• IBM System Debugger• Open source and freeware• Resources to stay current• Web links, downloadable stuff, contactsEnglish edition review: Claudia Campione