Sequel IBM i Tutorial: Views, Viewpoint and Business Reporting
Sequel for IBM i is a data access and reporting product family distinct from Ruby Sequel and Sequel Pro. Follow a Sequel view from its source definition through selection and calculation, then examine how Viewpoint presents authorized query and report objects.
Here's a popular Sequel IBM i video — watch it, then summarize it with one click. Or paste any other YouTube link below.
— or paste your own YouTube link —
Want to keep the key points from a YouTube video? Paste the link below to turn it into structured notes.
Why Use Sequel IBM i Tutorial: Views, Viewpoint and Business Reporting
- Identify Sequel view definitions on IBM i
- Select source fields for business queries
- Configure calculated and filtered output
- Navigate authorized Viewpoint objects
- Separate query definitions from report files
Frequently Asked Questions
What does the word view mean in this Sequel workflow?
A Sequel view defines access to selected data and underpins supported outputs and related objects. Interpret it through the product's terminology rather than automatically equating every saved view with a native SQL database view.
How does Viewpoint relate to IBM i data?
Viewpoint provides a graphical interface for supported Sequel data access and reporting workflows. The underlying host objects and source permissions remain relevant even when a user works through a desktop-style interface.
Why verify an existing query's selection rules?
A familiar report name can hide filters, joins or calculated fields that no longer match the business question. Inspect those definitions before using the output as evidence for a new analytical decision.
Can an exported report stay current without another run?
An exported file represents an output at its generation time unless a separate refresh process exists. Distinguish that artifact from a saved definition that can be executed again against newer data.
Are Query/400 and Sequel identical tools?
They are different IBM i query and reporting workflows, although Sequel provides supported ways to work with existing query definitions. Verify converted logic rather than assuming a familiar report layout proves identical results.