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.
Guide
Self-Audit: Checking Assumptions at the Door
Sysadmins, devops engineers, and cybersecurity personnel are often kept awake by a number of questions.
How should I monitor my monitoring to be sure it will alert me when there is a security issue that needs my intervention? How can I be sure that the servers and processes in the environment haven’t been rooted already?
In the quest to get better sleep, it is a good idea to self-audit your...
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...
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.
Guide
The Query Decision-Making Kit
Is Query/400 still cutting it? Probably not. You’ve most likely heard that there are other data access tools out there, but you might not be sure which one is right for you—or even if it’s the right time to upgrade. The Query Decision-Making Kit can help.
For starters, you want data access to be simple, no matter your skill level. You want the option to view visual data in real-time, access data...
Blog
3 Ways Digital Document Management Helps Financial Institutions
Wed, 07/27/2016
Secure document management is an important consideration for any business, but for financial instutions in particular, keeping data secure is critical to keeping business running smoothly and clients happy. Learn how digital document management gives financial instutions the competitive edge they need to succeed.
Blog
Three Factors for Growth with Organizational Technology
Wed, 07/27/2016
Learn the three key factors involved with an organization's technological growth and how to overcome the challenges of implementing new technology amidst workplace resistance.
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
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...
Blog
Moving Documents Between IFS Folders
Mon, 06/27/2016
Because Webdocs maintains a separation between its internal file structure and the operating system’s, you can organize documents for your users in one manner, while organizing them on the IFS in an entirely different manner. This article takes you through the steps of reorganizing the folder structure on the IFS.
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.
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
Get Started with Remote Database Access
By Get Started with Remote Database Access 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
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
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.Exclusion...
Article
What is Sequel Data Warehouse?
By Alan Jordan on Mon, 06/27/2016
Sequel Data Warehouse is so much more than just a data warehouse. Learn what else this powerful ETL tool can do.
Article
Using Executive Dashboards in Sequel to Layer Yearly, Quarterly, and Monthly Data
By Using Executive Dashboards in Sequel to Layer Yearly, Quarterly, and Monthly Data on Mon, 06/27/2016
Find out how to get business value out of executive dashboards.
Article
HANDS OFF! Saying Goodbye to Manual Data Access
Mon, 06/27/2016
Organizations today face an ever-expanding volume of information that must be analyzed and delivered to the right people. While the resulting business intelligence offers us insight into processes and customers, many companies still rely on practices and technology that aren’t suited for managing data on a large scale.
As a December 2012 Financial Director article highlighted, 60 percent of those...