Resources
Article

Enhance Your Reporting with Sequel Date Functions

By Heath Kath on Fri, 01/06/2017
Sequel makes it easy to work with your date fields, from converting the numeric or character field into a true date data type field to performing date calculations. Continue reading to learn how to convert non-date data type fields.
IBM i Business Intelligence
Article

How-To: Analyze Year-End Data Quickly with Flexible Client Tables

By Heath Kath on Thu, 12/01/2016
Year-end reporting is coming… Are you ready? Do you know your options? Are you prepared to collect all of the data you need to see how your company fared for the year? You’re in luck, because Sequel Client Tables make year-end reporting a breeze. Drill down into the level of information you need for your reports. Compare data across multiple years to spot trends and add context. And highlight...
IBM i Business Intelligence
Make forms processes more efficient with document creation and delivery software
Case Study

Major Steel Supplier Strikes Gold with a Document and Forms Management Solution and Superb Support

Paperwork and steel go hand-in-hand for one major steel supplier (MSS) with locations across North America. Every piece of steel they ship includes paperwork assuring customers of the quality of the product they’re receiving.But MSS had a problem: their processes were keeping them from meeting customer expectations. It was time to make a change.The Paperwork ProblemPre-printed forms and Dot matrix...
Automation
Data recovery graphic
Article

4 Reasons to Add VTLs

By Tom Huntington on Tue, 08/30/2016
Backup and recovery processes are among the unsung heroes of data center operations. Though end results may not be readily apparent on an everyday basis, natural and digital disasters have a way of humbling companies that do not take this risk management discipline seriously.
IBM i Automation
Article

Database 101: Why You Can Rely on IBM i

Fri, 08/19/2016
IBM i is the perfect environment for data access and reporting. Read this article to learn how you can better utilize your Power Systems databases.
IBM i Business Intelligence
Article

How Banks Leverage Big Data for Big Value

Fri, 08/19/2016
Technology professionals in the banking industry face a wide range of concerns due to the nature of the data stored within their systems. The potential reward in stealing or compromising financial data makes these organizations a prime target for cybercrime, while stringent industry regulations require security to be extremely tight at all times. Is it possible to strike a balance between defensive, regulatory, and data access needs and still provide access to data for analytics without compromising the security of the entire system? The truth is that many organizations in the financial sector have deployed analytics technology while being able to keep their security tight, and are benefiting from it.
IBM i Business Intelligence
Article

Add Power to SEQUEL Scripts with Logic

Mon, 08/01/2016
SEQUEL Scripting is a process that allows users to run multiple SEQUEL and system commands together. Scripts allow for much of the same capability of Command Language Programs (CLP) without the need for programming knowledge or a compiling of the objects.
IBM i Business Intelligence
Article

Dealing with Temporary Files in WebDocs iSeries

Thu, 07/28/2016
WebDocs iSeries uses the IFS directory /RJSTEMP and the library RJSTEMP to store information and files temporarily. In general, it will attempt to clean up after itself, but there are situations which arise that do not perform clean up operations. As a result, files will gradually accumulate, taking up disk that could otherwise be used for other processes. The RJSTEMP library The RJSTEMP isn’t...
IBM i Automation
Article

Advanced Troubleshooting in WebDocs iSeries

Thu, 07/28/2016
As a WebDocs iSeries administrator, if something goes wrong your users will look to you to find, and fix, the matter. Simply knowing where to look when an initial error message is unclear can resolve a huge percentage of difficulties.
IBM i Automation
Article

Considerations For Securing NFS Shares For Use With Webdocs iSeries

Mon, 06/27/2016
NFS has long had a tentative relationship to security. As with its cousin, CIFS/SMB (more commonly know as Windows File Sharing), security was not an area of primary focus. The elements of security that exist are significant, but they are nontrivial to implement, particularly across operating systems and with third-party applications.
Automation
Article

How-To: Slice and Dice Your Data with Client Tables

Mon, 06/27/2016
In the era of big data users need to view their data in a way that makes sense and lets them dive deeper. SEQUEL’s Client Tables are an interactive solution, much like pivot tables, which allow users to reorganize and summarize columns and rows of data in a spreadsheet-like format both on a PC and on a mobile device or tablet. With Client Tables on the go, you can access data from your office, in...
IBM i Business Intelligence
Article

Get Started with Remote Database Access

By Heath Kath on Mon, 06/27/2016
Many organizations are expanding to use multiple platforms in their IT environments. There are many reasons for this: it can be due to company acquisitions or application vendor platform shifts, or when a department requires a certain software package with features that require a different platform. For example, many Customer Relationship Management (CRM) tools employed by sales teams reside on a...
IBM i Business Intelligence
Article

The Partitioning Paradox Solved

Mon, 06/27/2016
There is rarely a dull moment for IBM i administrators, as their operating environments continuously absorb and distribute new data. While this trend certainly keeps teams engaged, it also triggers fears that current protocols may not be enough to meet the challenges of tomorrow. First and foremost, there is often some doubt as to whether storage plans will be able to scale to manage the sheer...
IBM i Business Intelligence