A SEQUEL Client Table is an interactive solution for dynamic Desktop Online Analytical Processing (Desktop OLAP or DOLAP) and cube analysis. With a Client Table, it’s possible for you to build client/server views that allow end users to explore, summarize, and pivot large quantities of data quickly from IBM i and other databases. Once a Client Table is displayed, users can perform interactive...

In an earlier article, we introduced prompted views as a way to enable end users by allowing them to retrieve data without the need for code. We discussed how this approach meets the needs of users while freeing time that database administrators might otherwise spend running countless similar queries. Finally, we showed you how to configure default values for your prompts and explained how to use ...

Managing big data requires making some big decisions: how to store, query, and report on the constantly increasing stream of data. Although the practice of ‘data at scale’ or table partitioning is popular on IBM i, it creates a partitioning paradox that often adds complications to efficiently querying data.

A Client Report Option (CRO) is an excellent PC-based reporting tool allowing you to distribute information at a new level.

Need to empower users with detailed data? Find out how Sequel's drill-down capabilities make it easy!

IBM added additional security functions in version 7.1 to further establish the Power Systems IBM i operating system as a world-class securable environment.

“I’m trying to scan a document, but keep getting a TWAIN error.”

Many Query/400 users spend too much time trying to manage existing queries, from modifying old ones to searching for the right one just to get basic data. SEQUEL can make this process much faster and easier.

Have you ever made a change to an IBM i object and then wished you could undo the change like with PC objects? This is a common mistake many business and IBM i professionals encounter on a regular basis, but SEQUEL now gives you a built-in solution.

As the end of 2013 draws near, many businesses have budgets on their minds. Most companies will run year-end numbers to determine the full scope of their investments, and analyze what sort of changes can be made to cut costs and increase profit margins. As the number crunching begins, it’s time to consider numerous variables, including those that fall under the IT department. Decisions made within...

Data security has been a prominent feature in recent technology headlines as the costs associated with data breaches continue to escalate. Business and IT leaders alike have become all too aware of the need to protect valuable information, but questions of how - and to what extent protection is needed- are common sticking points. The rule of least privilege has been a long-held strategy that...