Structured Query Language (SQL) has become the mainstay for data manipulation on most platforms today. It is important for today's IBM i professional to understand the traditional DDS tools, but most new database systems are created and manipulated using SQL. The intent of this series of articles is to expose the reader to both the traditional tools and the latest tools and concepts. SQL is a complete database language with data-definition, data-manipulation, and data-control components.
Following the recent launch of LongRange, the first native mobile app builder for RPGdevelopers, comes LongRange University, free online education for building stylish, high-performance Apple and Android mobile apps fully integrated with your core IBM i applications.
DBXFlexreport writer / query tool extracts data from IBM i, iSeries and AS/400 database files creating custom reports directly to Excel and PDF.
Extract data from one or multiple IBM i data files to create custom reports
Output directly to Excel, PDF, CSV and print files
Perform record and field selection
Add calculations, color, sort, justification, date format etc.
Runs on any IBM System running IBM OS V5R1 or higher
Standalone module can pre-process spooled files for use by other IBM i software applications.
DBXFlex provides flexibility over legacy reporting allowing users to create reports by accessing the data they want, and outputting to formats they need, delivered by email and archived to network servers. . For a closer look, schedule an online demonstration, or request a free trial