Creating Queries for Simplified Data Access

If you are still using native SQL for queries, it’s time to try SEQUEL [1] for simplified data access.

Creating and using queries should be an enjoyable part of your workday—an easy way to access the information you need. But, that process can be tiresome with the wrong query interface. A SEQUEL query is called a view, and a view contains all the selection criteria you need to access data from your System i.

SEQUEL ViewPoint [1] makes it easy to design views using simple point‑and-click operations. Plus, you can create ad hoc queries any time you need information from your System i database. Minutes after you install SEQUEL, you’ll see it transform data access on your System i in ways you never imagined:

• Access remote databases
• Add run-time prompts
• Build tables, reports, and graphs from your data
• Build views across multiple files
• Convert existing queries into SEQUEL objects
• Export results into Excel files or in file formats such as CSV, TXT, PDF, and more
• Send results to your PC to build new views

From simple ad hoc queries, to executive dashboards, to providing information on the Web, SEQUEL delivers System i data in the format that works best for you. Read more about SEQUEL ViewPoint! [1]

Related Topics

SEQUEL [1]

SEQUEL Web Interface [2]

[3]