WWW.KIRTLEYTECH.COM

SEQUEL is the preeminent data access tool for the AS/400. Thousands of sites around the world are using SEQUEL to "unlock" information held in their AS/400 databases. They've found SEQUEL delivers AS/400 information with the utmost in performance and ease of use.

SEQUEL goes far beyond the capabilities of IBM's Query/400, SQL/400 or other products. It's not just another query and reporting product, but a tool you can rely on to accomplish all of your AS/400 data access requirements. SEQUEL's query and reporting capabilities are second to none, and you can also use SEQUEL to download data to PC applications, fix corrupted files, convert data, or even build data warehouse applications. It has countless other uses. In fact, there's very little you can't do with SEQUEL. And once you use SEQUEL, you'll agree that there's no better way to work with AS/400 data.

SEQUEL is a modular solution. You can select modules for your specific needs:

Kernel - The "engine" that drives SEQUEL's query and data formatting functions.
User Interface - Provides a user-friendly front end to the Kernel.
Report Writer - Report formatting second to none.
Tabling - Summarizes transaction data into "spreadsheet" files.
Auditing - Helps you track SEQUEL usage.

SEQUEL provides outstanding capabilities when working with AS/400 and iSeries data. Here's a summary:

User Actions

• GUI, Web and 'green screen' user interfaces available
• Run-time prompts can be included for any SEQUEL request
• Drill-down from one query to another
• Run multiple SEQUEL operations with a single user option
• Run SEQUEL operations from an icon
• Combine mulitple SEQUEL operations within a SEQUEL Script

Queries and Reports

• Use if-then-else logic in query statement or report calculations
• SORT or JOIN using a calculated field
• Create multiple-line heading, detail, subtotal and grand total formats
• Date conversion from/to any format, including date data type
• Character-to-numeric and numeric-to-character conversion
• Design reports on a full-screen WYSIWYG display
• The most powerful report writer available for the AS/400!

Data Download

• Extract AS/400 data and download into most popular PC file formats,
  including WebSphere-compatible XML
• Export records to a shared folder document
• Extract and create new AS/400 and iSeries files

FTP and E-mail

• E-mail query results in PC file format to any number of e-mail recipients
• FTP reports, extract files or spooled files to other servers

Charts and Graphs

• Graph AS/400 and iSeries data with SEQUEL ViewPoint
  

AS/400 and iSeries Database Operations

• Update fields
• Delete records
  
• Insert records
  
• Extract records to a physical file
  
• Summarize transaction data in a tabling file
  
• Update a field with data from another file

Convert Query/400 objects to SEQUEL Views

• CVTQRY command automatically converts Query/400 objects to SEQUEL view user spaces