S/List Overview

S/List User Manual

	Introduction
	S/List Overview
	Starting S/List
	S/List Report
	S/List Query
	S/TCL
	Keystrokes
	Appendix A
	Appendix B
	Appendix C - LIST Keywords

Links on this page:

S/List Overview
General Comments

S/List Overview

S/List is made up of two parts. The first is simply the SList subroutine. The Syntax for the SList subroutine is:

Call SList(ListStatement)

Where ListStatement is any valid OpenList statement. This corresponds exactly to the Advanced Revelation equivalent of PERFORM ListStatement. S/List can be called through either a program:

Figure 1: Syntax for SList subroutine

Or, it can be called through the System Monitor:

Figure 2: System Monitor

Figure 3: Statement in System Monitor

Producing:

Figure 4: Print Preview report

Because S/List is designed to be called from within Open Insight windows, it is said to operate "in an event context". What this means is that if you try to run it from the Execute line in the System Editor, you will get an error message. This message is not fatal and can be ignored. If you do not wish to see the message then simply use the System Monitor Execute line instead of the System Editor Execute line. We recommend running it from the click event of a button but that is of course entirely at the developer's discretion.

The S/List Workspace is effectively just a tool, which builds up such statements and allows them to be stored or executed. There are two parts to the S/List Workspace. The first is Query and the second is Report. A Query generates a Select list, which is a list of row keys from a table that match your query. A Report takes a list of row keys, which are generated by either a Query or user-defined row keys and generates a report displaying the table fields that the user selected. Reports and Queries will be discussed in further detail at a later stage, where you can learn how to create both.

To view stored S/List Query and Report records in the System Editor do the following:

	From the Application Manager, click on System Editor.
	Press CTRL R to open the Open Record window
	You can open a record by selecting Table Name, then Row. For the Table Name, select SYSREPOSREPORTS. There will be a number of selections including S/List Queries and S/List Reports. To view an S/List report, look for the records in SYSREPOSREPORTS with a key layout of Application* SLISTLAYOUT*Report Name, where Application is the name of the application you logged into. Report Name is the name of the saved report.

For this example we will use S/List Query:

SYSPROG*SLISTQUERY*KATE

SYSPROG is the name of the application, SLISTQUERY shows it's a Query, and KATE is the name of the record.

Field No.	Example	Content
1	selection for dem	Query Description
2	11013	Query Update Date is shown in an internal format.
3	36829	Query Update Time is shown in an internal format
4	SYSPROG	User who created query
5	BY-DSND UPDATED	The Query Sort Order
6	üüWITH UPDATED BETWEEN "1 2 98" AND "12 2 98"üýOrüüWITH UPDATED BETWEEN "1 1 98" AND "12 1 98"ü	Displays the Selection Criteria in the query.
7	SYSREPOS	The table Queried
8	SELECT SYSREPOS WITH UPDATED BETWEEN "1 2 98" AND "12 2 98" OR WITH UPDATED BETWEEN "1 1 98" AND "12 1 98" BY-DSND UPDATED	Full Query Sentence

Table 1: Examples of S/List Query data in System Editor

Below shows you screen shots for each field:

Figure 5: Query Details Tab

Figure 6: Sort Order Tab

Figure 7: Selection Criteria Tab

Figure 8: Query Sentence

To view the inserts that describe the structure of the SLISTQUERY and SLISTLAYOUT records.

	From the Application Manager, click on System Editor.
	Go to File and select Open Insert (or CTRL I)
	An Insert window will come up, where you can select the LIST_QUERY_EQUATES and SLIST_LAYOUT_EQUATES.

Figure 9: S/List Query Structure

General Comments

S/List should not care whether key words and options are typed in lower or uppercase, but if you do experience problems it never hurts to assume that uppercase is the safest option.

The order of the various clauses and keywords is also irrelevant (except for the initial LIST [n] TableName), though obviously enough any column modifiers should follow the relevant column.

There are, at the time of writing very few known problems with the system. Because of the use of the OIPI utility for printing and print previewing, once a report has been directed to the screen, S/List has lost control.

Of course, this being Windows, it is possible to tab off elsewhere and do some word processing while you wait; the only proviso is that you cannot launch another S/List report while the first one is still being printed.

[top]