Earlier this year, I wrote a blog talking about the following efficiencies your IT department, your IBM i partitions, and your organization can realize by using professionally written software to generate and deliver queries and reports.
Posted by:
The four keys for success in IBM i database queries and report writing software can be summed up in the simple acronym ASEF, which stands for:
Analysis
Selection
Extraction
Formatting
All IBM i queries and reports start and end with these four steps. Here’s ...
Continue Reading →
There are changes coming if your shop is running an AS400 or iSeries or Power System with IBM i and uses the Excel data transfer function that comes with IBM i Access for Windows (AS400, iSeries) .
Recent versions of the Excel data transfer add-in aren’t compatible with Microsoft Excel 2013. IBM is no longer supporting the data transfer add-in, and IBM’s stated direction is for ...
Continue Reading →Posted by:
Many companies ask us what they should look for in IBM i database query and report writer tools, such as our DBXFlex software. IMHO, a great database query tool contains the following elements.
The heart of why you need a database query tool for your AS400 or other IBM model is efficiency. When you query a database, it sets into motion a series of steps that can quickly spit out the information you are seeking, or slow down the system because you have created a query that returns too many records.
Database query software helps to keep your IBM power server from getting clogged up with inefficient requests that use up resources ...
Continue Reading →
Your IBM Power System database is a goldmine of information. But sometimes getting at that precious information is like trying to mine gold with a spoon. Database query tools can cut through the rock with laser like precision to extract every bit of data you need to create reports that are chock full of the insights and statistics your organization needs to ...