In this Topic Hide
Quick and easy access to your System i data is what SEQUEL Web Interface is all about. All of your pre-built SEQUEL objects will display directly in the browser and launch a separate tab next to the Explorer tab. You can jump between each tab to review the results, drill-down and regroup (where applicable), create graphs and more. Let’s look at how each SEQUEL object displays or launches in SWI.
There are three ways to display a view, script view, or host table view: Double-click the object (SQLVIEW, SQLSCRV, SQLTBLV ) in the Explorer object list, select Display Results from the Actions menu, or right-click and select Display Results from the menu.
Actions Button
Actions Drop-down Menu
The results open in a new tabbed display similar to the main Explorer object list display. The body of the display shows the data selected by the view with the column order and the row sorting based on the view definition.
Use the buttons along the top of the result columns to direct results to the following output formats:
Download to PC
Create a Physical file on the System i
Create an IFS Document on the System
Create a Remote Database Table
Print Locally
Submit to a System i output queue
E-mail
as an attachment
Graph Results
Group and Sum
There are many options available to control the look and arrangement of the results display. These features are similar to those in the Explore object list. You can sort any of the columns, and click and drag to move them (left or right) anywhere you like. You can resize the width of each column and add or remove columns from the display.
Prompted
Views
Dynamic Drill-Down and Regrouping Views
Dashboards can contain a collection of SEQUEL, Web, and Windows objects and act as a single point of access to common, or often-used inquires, reports, charts, and more. Double click a dashboard (SQLDASH), or select Display Results from the Actions menu to open it in a separate SWI results tab. All the elements in the dashboard are ‘turned on’ and run.
All dashboard objects are supported in SWI, but some have minor limitations. Review the Compatibility Chart for more information.
Double-click a host report (SQLRPT), or select Display Results from the Actions menu to display it in a separate SWI results tab.
Use the buttons along the top of the result page to direct results to the following output formats:
Download to PC
Print Locally
E-mail as an attachment
Double-click a client report (SQLRPTC), or select Display Results from the Actions menu to display it in a separate SWI results tab.
Use the buttons along the top of the result page to direct report results to the following output formats:
Download to PC
Print Locally
E-mail as an attachment
Double-click a client table (SQLTBLC), or select Display Results from the Actions menu to display it in a separate SWI results tab.
If SWI is configured to use the Power i to process requests, a static result is displayed as shown below. Dynamic (interactive) Client Tables are available from a configured SEQUEL Web Server.
c3_client_table_results.gif
Use the buttons along the top of the result page to direct report results to the following output formats:
Print Locally
E-mail as an attachment
SEQUEL Scripts are used to combine multiple steps or processes together in a simple-to-execute ‘program’. Many times, data needs to be massaged, or work files must be built before achieving a final result. With SEQUEL Scripts you avoid the technical requirements of writing CL programs.
In SWI, scripts are simply launched. Either double-click a script (SQLSCRIPT), or select Run Script from the Actions menu. Scripts designed to display views, tables, or reports will open these results in a separate SWI results tab. Otherwise, a blank tab will open displaying just the name of the script.
A script view is processed and displayed just like a standard view. See the View section above to review how to display and work with script view results.
A SEQUEL Drill Down Application is a collection of views and/or tabling views along with an option file stored as single SEQUEL object on the System i.
Unlike Dynamic Drill-Down and Regrouping views, Drill Down Applications can start with summary or detail views, they can link to many different types of objects (Reports, Scripts, views, Windows objects, and more), and can be linked together with pre-defined options.
Like other SEQUEL objects in SWI, double click the application (SQLAPP), or select Display Results from the Actions menu. The object designed as the starting object for the application (usually a view) will open in a separate SWI results tab.
Right-click any row, as shown above, and select a drill down option to display new results in a separate tabbed window.
Use the buttons along the top of the result columns to direct results to the following output formats:
Download to PC
Create a Physical file on the System i
Create an IFS Document on the System
Create a Remote Database Table
Print Locally
Submit to a System i output queue
E-mail
as an attachment
Graph Results
Note: Drill Down Application implied links are not supported in SWI. You can convert your implied links to explicit links in the Application Designer by right-clicking each object and selecting the Create Option option. For more information on Drill Down Application link types, refer to the ViewPoint User Guide.
|
SEQUEL Web
Interface 10. |