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 by Massimo Duca, Claudia Campione
English | January 26, 2019 | ISBN: N/A | ASIN: B07N5K2R1B | 539 pages | AZW3 | 3.27 MB
English | January 26, 2019 | ISBN: N/A | ASIN: B07N5K2R1B | 539 pages | AZW3 | 3.27 MB
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!
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, contacts
• 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, contacts
English edition review: Claudia Campione