SEQUEL 10 Brings i/OS Reporting Enhancements

April 27, 2010 Alex Woodie

The SEQUEL Software subsidiary of Help/Systems unveiled a new release of the SEQUEL business intelligence software earlier this month. SEQUEL 10 will give System i customers faster connections to DB2/400, as well as the capability to create longer and more complex queries that execute against DB2/400 or other databases, among other enhancements.

SEQUEL is a multi-purpose i/OS utility that excels at executing queries and generating reports from DB2/400 as well as other relational databases, like SQL Server and MySQL. The software uses a special version of the SQL syntax that its owners say is more familiar to users and easier to use than the standard SQL syntax.

But in addition to business intelligence capabilities, the software, which Help/Systems obtained with its acquisition of Chicago-based Advanced Systems Concepts (ASC) nearly four years ago, can also be used as a programmer productivity tool, a form design and report output tool, a database conversion tool, or a Web enablement tool. BI just happens to be what it’s best at, so that’s how it’s marketed.

Expanding the size of SEQUEL views, or queries, from 5,000 to 20,000 characters brings users a couple of benefits with SEQUEL 10. First, it enables developers to create longer and more complex views. Big reports that perhaps needed to be broken up across multiple queries can now be executed in a single query.

Another benefit of the larger supported query size is the capability to create tailored queries for specific databases. This functionality goes hand in hand with another version 10 enhancement: the capability to automatically convert the SEQUEL SQL syntax to either standard SQL or database-specific SQL that executes against DB2/400, MySQL, SQL Server, or the Oracle database.

The vendor says it has added a new SYNTAX parameter that can be used with any SEQUEL command that works with SQL, such as CRTVIEW, DISPLAY, and DSNREPORT. This SYNTAX parameter automatically translates SEQUEL SQL to a database-specific SQL syntax at run time for faster execution.

For accessing local DB2/400 databases, SEQUEL converts the SEQUEL SQL to standard SQL. For accessing remote databases like MySQL or SQL Server, SEQUEL version 10 will convert the SEQUEL SQL to SQL that is specific for the server.

Since the SEQUEL software runs on the System i server, that is what most customers will use it with. SEQUEL version 10 brings System i performance improvements using the SQL Query Engine (SQE) utility that has been built into the i/OS operating system for the past several releases.

Another benefit in version 10 is the capability to use unqualified filenames for creating queries. The software will automatically translate the SEQUEL SQL to standard SQL, which should make it easier to write queries.

For more info, see www.sequel-software.com.

System i Vendors Merge as Help/Systems Acquires ASC

Help/Systems’ SEQUEL Gets More BI Tooling

                     Post this story to del.icio.us
               Post this story to Digg
    Post this story to Slashdot

Tags:

TL Ashford writes software to generate Barcode Labels and Forms for the IBM i.

Our software products are the most feature-rich, cost-effective solutions available!

TLAForms converts traditional IBM i spool files into high quality, professional forms that are output as PDF documents. A form is associated with a spool file and the form is designed. TLAForms then ‘watches’ the IBM i output queue for a new spool file to be generated. When a new spool file is generated, TLAForms reads the data from the spool file, places the data on the form, and outputs a PDF document. The PDF documents can be archived to the IFS, automatically emailed, and printed.

Features:

Select Data directly from an IBM i Spool File
Burst IBM i Spool Files based on page or Spool File data
Add spool file data to form as Text using a wide variety of fonts and colors (the MICR font for printing checks is included in the software)
Add spool file data to form as bar code – including 2-dimensional bar codes PDF-417 and QRCode
Configure SQL statements to retrieve and use IBM i File data on forms
Utilize Actions to show or hide objects on the form based on data within the spool file
Import Color Graphics
Use Color Overlays
Create Tables
Forms can be archived to the IFS
Forms can be emailed automatically
Forms can be printed to any IBM i, Network or Windows printer
Forms are automatically generated when a new spool file is generated in the IBM i output queue
NO PROGRAMMING required
On-Line Video Training Library

Learn more about TLAForms at www.tlashford.com/TLA2/pages/tlaforms/overview.html

Barcode400 is native IBM i software to design and print labels directly from your IBM i in minutes! Compliance and RFID labeling is easy using Barcode400’s tools and templates.

Features:

Software resides on the IBM i
IBM i security and Backup
Labels are centrally located on the IBM i
Label formats are available to all users the instant they are saved – even in remote facilities
GUI designer (Unlimited Users)
Generate Labels as PDF documents!
Print to 100’s of thermal transfer printers
Print to HP and compatible printers
Print labels interactively – No Programming Necessary!

OR Integrate into existing application programs to automatically print labels – Barcode400 has been integrated with nearly every ERP and WMS software available on the IBM i, including thousands of in-house written applications.

On-Line Video Training Library
Free Compliance Labels
Generate Checks using the MICR font
RFID Support (optional)
History / Reprint Utility
Integration Assistant
Low Cost (no tiered pricing)

Learn more about Barcode400 at www.tlashford.com/TLA2/pages/bc400labels/overview.html

Brian Kelly Takes a Run at Congress and for Congress Files in Subprocedures

Table of Contents

Content archive

Recent Posts

Subscribe

Pages

Search