Blog
Who's Afraid of IASPs?
By Tom Huntington on Tue, 08/16/2016
As IASP technology continues to grow, so will its uses for high availability (HA) and backups. The result of that will be shrinking hardware costs and complexity and increased redundancy.
Guide
Download “How IT Professionals Can Navigate PCI DSS Compliance” Guide
The Payment Card Industry Data Security Standard (PCI DSS) applies to every organization that processes credit or debit card information. This includes merchants and third-party service providers that store, process, or transmit credit card data.
The launch of PCI DSS helped expose serious security shortcomings, failures to follow security best practices, and...
Article
Robot and FlashCopy
By Tom Huntington on Tue, 08/16/2016
Last month, Chuck Stupca (retired IBMer) and Chuck Losinski (Fortra) presented a webinar discussing FlashCopy for IBM i. Based on the attendance, it looks like this is a very important topic for many of you so I wanted to explain how FlashCopy ties to Robot products.
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.
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...
Article
Easily Accessing Data on Remote Databases with SEQUEL
Mon, 06/27/2016
With SEQUEL you can retrieve information not just from your local IBM i, but also on other IBM i’s, SQL servers, Oracle, MySQL, and other remote databases. Once you have the remote host definition defined you are ready to convert data on other platforms into meaningful information right from your local IBM i. The ability to design views with SEQUEL SQL and translate them on the fly to native SQL...
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...
Article
Sequel Tips and Tricks: Enhance Your IBM i Queries
By Mike Stegeman on Mon, 06/27/2016
Get more out of your IBM i queries (and help your users help themselves).
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...
Article
Thinking About Moving Your Data Off IBM i?
Mon, 06/27/2016
Find out three things you need to consider before you move your data.
Article
Staying on IBM i Sounds Like Money in the Bank
Mon, 06/27/2016
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...
Article
SEQUEL Works with your Growing (BIG) Data
Mon, 06/27/2016
As you collect more information, your relational database files continue to grow and you’re faced with a challenging issue: how to handle all of that information efficiently and accurately, and how to overcome the obstacle of mining and delivering useful information without bogging down the system.
Partition files are the solution to BIG DATA on IBM i because of:
Improved manageability for...
Article
Separate Signal From Noise in Big Data
Mon, 06/27/2016
You don’t need a reminder of the strain big data will place on your IBM i storage environments in the coming months and years, but server workloads won’t be the only thing expanding. As CIOs navigate the transition from megabytes and gigabytes to terabytes and petabytes, their colleagues' business intelligence plans continue to grow more complex and ambitious as well.
In the age of data-driven...
Article
Why Use a Client Report Option (CRO) Report?
Mon, 06/27/2016
A Client Report Option (CRO) is an excellent PC-based reporting tool allowing you to distribute information at a new level.
Article
Working with Variables Part I: Building Run-Time Prompted Views with Sequel
By Heath Kath on Mon, 06/27/2016
Make your queries easier for everyone. Find out how to use run-time prompts in Sequel.
Article
Additional ViewPoint Administrator Functions
Mon, 06/27/2016
What does this function do?
SEQUEL Field Level Authorization uses an exclusion/inclusion dictionary function that lets administrators provide authorization to libraries, files, and fields. The dictionary, which can be defined as exclusion or inclusion, is an additional filter applied on top of system object security limits. It does not replace system object authority but supplements it.
...
Article
Use Sequel Applications to Drill into Detailed Data and PC Applications
By Mike Stegeman on Mon, 06/27/2016
Need to empower users with detailed data? Find out how Sequel's drill-down capabilities make it easy!
Article
How to Use Key Performance Indicators to Deliver Value
By Mike Stegeman on Mon, 06/27/2016
What are KPIs? Which ones should you be tracking? Should you share them?