Home
Starting
Environment
DBMS
VisualPQL
Procedures
SQL
Forms
Host/API
Index
#
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
Index
S
S
s picture
VISUALPQL /Reading and Writing Files /I/O List - Input Specification
SAMPLE
PQL PROCEDURES /CSV Save File /CSV Save File
PQL PROCEDURES /Overview /Common keywords
VISUALPQL /Database Access /PROCESS CASE
VISUALPQL /Accessing Tables /PROCESS ROWS
SAMPLE;on SELECT
SQL /SELECT /Keywords
sampling
SQL /SELECT /Keywords
SARG function
VISUALPQL /Functions /Alphabetic List of All Functions
SAS SAVE FILE
PQL PROCEDURES /SAS Save File /SAS Save File
SAVE
SQL /Control Commands /GET
VISUALPQL /VisualPQL Programs and Routines /RETRIEVAL, PROGRAM, SUBROUTINE
SAVE FILE BOX
VISUALPQL /Graphical User Interface /Other GUI Commands
SAVE TABLE
PQL PROCEDURES /SAVE TABLE /SAVE TABLE
SBST function
FORMS /COMPUTE /Functions
SQL /SQL Functions /Standard Functions
VISUALPQL /Functions /Alphabetic List of All Functions
SCALE
FORMS /Field /DSPEDIT
FORMS /Field /PMTEDIT
SQL /Tabfiles and Tables /Column Options
scaled variable
DATABASE /Introduction /Defining Variables
SCALED VARS
DATABASE /Schema /SCALED VARS
VISUALPQL /Variables /SCALED VARS
SCALED VARS;size implications
DATABASE /Tuning and Efficiency /Disk Space
SCATTER
PQL PROCEDURES /Plot /Plot
SCHEMA
PQL PROCEDURES /XML SAVE FILE /XML SAVE FILE
Schema Database Definition
DATABASE /Schema /Schema
schema delete
DATABASE /Schema /DELETE SCHEMA
schema functions
VISUALPQL /Functions /Schema & Database Functions
schema listing
DATABASE /Schema /SIR SCHEMA LIST
Schema Record Definition
DATABASE /Schema /Schema
Schema Update
DATABASE /Schema /Modifying Database Definitions
schema write
DATABASE /Schema /WRITE SCHEMA
scientific format
SQL /SET, SHOW and CLEAR /Parameter List
scientific notation
DATABASE /Introduction /Variable Formats
Scratch Files
ENVIRONMENT /Appendix /SIR/XS Files
SCREEN
VISUALPQL /PQLForms /SCREEN
Screen co-ordinates;PQLForms
VISUALPQL /PQLForms /PQLForms General Clauses
screen coordinates
FORMS /General Clauses /AT
screen name
FORMS /Using Forms /Status Area
screen size
FORMS /General Clauses /
SCREENS
FORMS /GENERATE /Syntax
VISUALPQL /PQLForms /GENERATE
scroll keys
FORMS /Using Forms /Entering Data
SCROLLAT function
VISUALPQL /Functions /Alphabetic List of All Functions
SCROLLTO function
VISUALPQL /Functions /Alphabetic List of All Functions
SEARCH
FORMS /CALL /
FORMS /General Clauses /ACTIVITIES
search command
FORMS /Using Forms /Status Area
search init
FORMS /Using Forms /Status Area
search members
ENVIRONMENT /Menus /Search Members
search mode
FORMS /Using Forms /Status Area
FORMS /Using Forms /Search Mode
search patterns
FORMS /Using Forms /Search Mode
searching records
FORMS /Using Forms /Search Mode
Secondary index creation
DATABASE /Schema /CREATE DBINDEX
secondary indexes
DATABASE /Tuning and Efficiency /Loading Factor
SECURE
FORMS /FORM /DATABASE
SECURITY
DATABASE /Schema /CONNECT DATABASE
DATABASE /Schema /WRITE SCHEMA
DATABASE /Schema /SECURITY
FORMS /FORM /DATABASE
FORMS /Introduction /Security
SQL /Control Commands /CONNECT DATABASE
VISUALPQL /Accessing Tables /PQL CONNECT TABFILE
SECURITY; Variable
DATABASE /Schema /VAR SECURITY
security;read levels and passwor
DATABASE /Schema /READ SECURITY
security;system
DATABASE /Schema /SYSTEM SECURITY
seed
VISUALPQL /Database Access /PROCESS CASE
VISUALPQL /VisualPQL Programs and Routines /RETRIEVAL, PROGRAM, SUBROUTINE
VISUALPQL /Accessing Tables /PROCESS ROWS
SEEK function
VISUALPQL /Functions /Alphabetic List of All Functions
segmentation, labels
PQL PROCEDURES /Tabulate /Other Options
SELECT
SQL /SELECT /SELECT
VISUALPQL /PQLForms /SCREEN
SELECT ALL
VISUALPQL /Graphical User Interface /Dialog Control Commands
SELECT DCONTROL
VISUALPQL /Graphical User Interface /DEDIT
SELECT ITEM
VISUALPQL /Graphical User Interface /Dialog Control Commands
select limit exceeded
SQL /SET, SHOW and CLEAR /Parameter List
SELECT;AS in VIEW
SQL /Paths and Views /CREATE VIEW
SELECT;asterisk
SQL /SELECT /Variable List
SELECT;automatic execution
SQL /SET, SHOW and CLEAR /Parameter List
SELECT;CASELIM
SQL /SELECT /Keywords
SELECT;COMPILE_ONLY
SQL /SELECT /Keywords
SELECT;computing values
SQL /SELECT /Variable List
SELECT;DBMS
SQL /SELECT /Keywords
SELECT;DISTINCT
SQL /SELECT /Output
SELECT;expressions
SQL /SELECT /Variable List
SELECT;FORMAT
SQL /SELECT /FORMAT
SELECT;FROM
SQL /SELECT /FROM
SELECT;GROUP BY
SQL /SELECT /Aggregation
SQL /SELECT /GROUP BY
SELECT;ON
SQL /SELECT /ON
SELECT;ORDER BY
SQL /SELECT /ORDER BY
SELECT;OUTER
SQL /SELECT /OUTER
SELECT;OUTPUT
SQL /SELECT /Keywords
SELECT;RECLIM
SQL /SELECT /Keywords
SELECT;SAMPLE
SQL /SELECT /Keywords
SELECT;SELLIM
SQL /SELECT /Keywords
SELECT;setting limits
SQL /SELECT /Keywords
SELECT;UNION
SQL /SELECT /UNION
SELECT;UNIQUE
SQL /SELECT /Output
SELECT;UNQ
SQL /SELECT /Output
SELECT;variable list
SQL /SELECT /Variable List
selecting procedure table record
PQL PROCEDURES /Overview /Common keywords
SELLIM
SQL /SET, SHOW and CLEAR /Parameter List
SELLIM;on SELECT
SQL /SELECT /Keywords
SELSIZE
SQL /SET, SHOW and CLEAR /Parameter List
SEPARATE
SQL /SET, SHOW and CLEAR /Parameter List
SEPARATOR
PQL PROCEDURES /CSV Save File /CSV Save File
SEPARATOR;FORMAT
SQL /SELECT /Column Formats
SERADMIN function
VISUALPQL /Functions /Alphabetic List of All Functions
SERADMIS function
VISUALPQL /Functions /Alphabetic List of All Functions
SEREXEC function
VISUALPQL /Functions /Alphabetic List of All Functions
SERGET function
VISUALPQL /Functions /Alphabetic List of All Functions
SERLINES function
VISUALPQL /Functions /Alphabetic List of All Functions
SERLOG function
VISUALPQL /Functions /Alphabetic List of All Functions
SERNOOUT function
VISUALPQL /Functions /Alphabetic List of All Functions
SERSEND function
VISUALPQL /Functions /Alphabetic List of All Functions
SERSENDB function
VISUALPQL /Functions /Alphabetic List of All Functions
SERTEST function
VISUALPQL /Functions /Alphabetic List of All Functions
SERVER
VISUALPQL /ODBC Client /CONNECT
SERVER NOOUTPUT
ENVIRONMENT /Commands /SETCLEAR
SERWRITE function
VISUALPQL /Functions /Alphabetic List of All Functions
session functions
VISUALPQL /Functions /Session Functions
SET
ENVIRONMENT /Commands /SETCLEAR
SQL /Data Entry and Modification /UPDATE
SQL /SET, SHOW and CLEAR /SET, SHOW and CLEAR
VISUALPQL /Introduction /Variables
VISUALPQL /Variables /SET
SET BUFFER
ENVIRONMENT /Commands /INCLUDE BUFFER | FILE | MEMBER
SET DATABASE
DATABASE /Schema /SET DATABASE
SET DIALOG TITLE
VISUALPQL /Graphical User Interface /Dialog Control Commands
SET IMAGE
VISUALPQL /Graphical User Interface /Dialog Control Commands
SET INI file text
VISUALPQL /Functions /Alphabetic List of All Functions
SET INPUT
ENVIRONMENT /Commands /INCLUDE BUFFER | FILE | MEMBER
SET ITEM
VISUALPQL /Graphical User Interface /Dialog Control Commands
SET ITEM FONT
VISUALPQL /Graphical User Interface /Dialog Control Commands
SET MASTER
ENVIRONMENT /Commands /SETCLEAR
SET OUTPUT
ENVIRONMENT /Commands /SETCLEAR
SETAKL function
VISUALPQL /Functions /Alphabetic List of All Functions
SETDFC function
VISUALPQL /Functions /Alphabetic List of All Functions
SETDIR function
VISUALPQL /Functions /Alphabetic List of All Functions
SETPOS function
VISUALPQL /Functions /Alphabetic List of All Functions
SETRANGE function
VISUALPQL /Functions /Alphabetic List of All Functions
SETRC function
VISUALPQL /Functions /Alphabetic List of All Functions
Setting variables
VISUALPQL /Variables /Assigning Values
SGET function
VISUALPQL /Functions /Alphabetic List of All Functions
SGLOBAL function
VISUALPQL /Functions /Alphabetic List of All Functions
SHORT
DATABASE /Schema /SIR SCHEMA LIST
SHOW
SQL /SET, SHOW and CLEAR /SET, SHOW and CLEAR
SHOW DATABASE
DATABASE /Schema /SET DATABASE
SHOW ITEM
VISUALPQL /Graphical User Interface /Dialog Control Commands
SHOWMISS
PQL PROCEDURES /Full Report /Syntax
PQL PROCEDURES /Quick Report /Syntax
PQL PROCEDURES /WRITE RECORDS /WRITE RECORDS
PQL PROCEDURES /XML SAVE FILE /XML SAVE FILE
VISUALPQL /VisualPQL Programs and Routines /RETRIEVAL, PROGRAM, SUBROUTINE
SHUTDOWN MASTER
ENVIRONMENT /Commands /SHUTDOWN MASTER
SIGN function
FORMS /COMPUTE /Functions
SQL /SQL Functions /Standard Functions
VISUALPQL /Functions /Alphabetic List of All Functions
SIMPLE
VISUALPQL /Variables /DEFINE PROCEDURE VARIABLES
simple break
PQL PROCEDURES /Full Report /Example 4: Simple Breaks
simple variables
VISUALPQL /Variables /Explicit Variable Declarations
SIN function
VISUALPQL /Functions /Alphabetic List of All Functions
sine function
VISUALPQL /Functions /Alphabetic List of All Functions
SINGLE
PQL PROCEDURES /Quick Report /Syntax
SQL /SET, SHOW and CLEAR /Parameter List
SINGLE PRECISION
SQL /Tabfiles and Tables /Column Data types
SIR FILE DUMP
DATABASE /Data /SIR FILE DUMP
SIR FILE LIST
DATABASE /Data /SIR FILE LIST
SIR MERGE
DATABASE /Backup /SIR MERGE
SIR SAVE FILE
PQL PROCEDURES /SIR Save File /SIR Save File
SIR SCHEMA LIST
DATABASE /Schema /SIR SCHEMA LIST
SIR SPREADSHEET
DATABASE /Data /SIR SPREADSHEET
SIR SUBSET
DATABASE /Backup /SIR SUBSET
SIR/XS Messages
ENVIRONMENT /Appendix /Error Messages
sircgi.htm
VISUALPQL /Reading and Writing Files /WRITE
sircode
ENVIRONMENT /Commands /System Globals
sircust
ENVIRONMENT /Commands /System Globals
sirexp
ENVIRONMENT /Commands /System Globals
SIRForms
ENVIRONMENT /Menus /Forms & Data Entry
sirid
ENVIRONMENT /Commands /System Globals
sirsqls
ENVIRONMENT /ODBC /SirSQL Server
SIRUSER function
VISUALPQL /Functions /Alphabetic List of All Functions
SIRUSER parameter
ENVIRONMENT /Appendix /Execution Parameters
sirver
ENVIRONMENT /Commands /System Globals
size estimating
DATABASE /Tuning and Efficiency /Size Estimating
size of variables
DATABASE /Introduction /Variable Formats
DATABASE /Tuning and Efficiency /Disk Space
SKEW
PQL PROCEDURES /Condescriptive /Condescriptive
PQL PROCEDURES /Frequencies /Frequencies
SKIP
DATABASE /Data /ADD REC
SKIPPED
ENVIRONMENT /Commands /PRINT BACK
SKIPPED;PRINTBACK
ENVIRONMENT /Appendix /Execution Parameters
skipping
VISUALPQL /Database Access /PROCESS CASE
skipping columns
SQL /DISPLAY /Headings and Footings
SL parameter
ENVIRONMENT /Appendix /Execution Parameters
SLIDER
VISUALPQL /Graphical User Interface /SLIDER
SMAX function
VISUALPQL /Functions /Alphabetic List of All Functions
SMIN function
VISUALPQL /Functions /Alphabetic List of All Functions
SMISSING
VISUALPQL /Variables /PRESET
sort
ENVIRONMENT /Appendix /Execution Parameters
PQL PROCEDURES /CSV Save File /CSV Save File
PQL PROCEDURES /Overview /Common keywords
VISUALPQL /Variables /Arrays
SORT IDS
DATABASE /Schema /KEY FIELDS
SORTIDS
FORMS /GENERATE /Syntax
PQL PROCEDURES /SIR Save File /SIR Save File
sorting
PQL PROCEDURES /Overview /Common keywords
PQL PROCEDURES /Quick Report /Syntax
SQL /SELECT /ORDER BY
SQL /SET, SHOW and CLEAR /Parameter List
SORTN
ENVIRONMENT /Commands /SETCLEAR
SPACE
ENVIRONMENT /Commands /SPACE
FORMS /Compiler Directives /Compiler Directives
SPACEC
SQL /SET, SHOW and CLEAR /Parameter List
SPACED
SQL /SET, SHOW and CLEAR /Parameter List
SPACES
SQL /SET, SHOW and CLEAR /Parameter List
SPACET
SQL /SET, SHOW and CLEAR /Parameter List
SPACING
PQL PROCEDURES /Quick Report /Syntax
SQL /SET, SHOW and CLEAR /Parameter List
SQL /SET, SHOW and CLEAR /Parameter List
SQL /SET, SHOW and CLEAR /Parameter List
SPAN modifier
PQL PROCEDURES /Tabulate /Variable Modifiers
spanner labels
PQL PROCEDURES /Tabulate /Other Options
spanners
PQL PROCEDURES /Tabulate /Variable Modifiers
PQL PROCEDURES /Tabulate /Variable Modifiers
PQL PROCEDURES /Tabulate /Other Options
SPIN
VISUALPQL /Graphical User Interface /SPIN
SPREAD function
VISUALPQL /Functions /Alphabetic List of All Functions
SPREAD SHEET
PQL PROCEDURES /Spread Sheet /Spread Sheet
spreadsheet
DATABASE /Data /SIR SPREADSHEET
ENVIRONMENT /Menus /Spreadsheet
SPSS SAVE FILE
PQL PROCEDURES /SPSS Save File /SPSS Save File
SPSSX SAVE FILE
PQL PROCEDURES /SPSS Save File /SPSS Save File
SPUT function
VISUALPQL /Functions /Alphabetic List of All Functions
SQL
PQL PROCEDURES /Quick Report /Quick Report
SQL Comments
SQL /Overview /Syntax Rules
SQL Server
ENVIRONMENT /ODBC /SirSQL Server
SQRT function
FORMS /COMPUTE /Functions
VISUALPQL /Functions /Alphabetic List of All Functions
square root function
FORMS /COMPUTE /Functions
VISUALPQL /Functions /Alphabetic List of All Functions
SRCH function
VISUALPQL /Functions /Alphabetic List of All Functions
SREAD function
VISUALPQL /Functions /Alphabetic List of All Functions
SRST function
FORMS /COMPUTE /Functions
VISUALPQL /Functions /Alphabetic List of All Functions
SRTN parameter
ENVIRONMENT /Appendix /Execution Parameters
SRTSIZE
SQL /SET, SHOW and CLEAR /Parameter List
STANDARD
DATABASE /Schema /WRITE SCHEMA
standard deviation
PQL PROCEDURES /Condescriptive /Condescriptive
PQL PROCEDURES /Frequencies /Frequencies
PQL PROCEDURES /Plot /Plot
standard deviation function
VISUALPQL /Functions /Alphabetic List of All Functions
VISUALPQL /Functions /Alphabetic List of All Functions
standard error of the mean
PQL PROCEDURES /Condescriptive /Condescriptive
PQL PROCEDURES /Frequencies /Frequencies
STANDARD SCHEMA
DATABASE /Schema /STANDARD SCHEMA
STANDARD VARS
DATABASE /Schema /STANDARD VARS
START
FORMS /AT, DRAW and TEXT /DRAW
start case
VISUALPQL /Database Access /PROCESS CASE
STATEMENT
VISUALPQL /ODBC Client /Statement
statement labels
VISUALPQL /Control Flow /JUMP
STATIC
VISUALPQL /VisualPQL Programs and Routines /RETRIEVAL, PROGRAM, SUBROUTINE
VISUALPQL /VisualPQL Programs and Routines /EXECUTE SUBROUTINE
Statistics
ENVIRONMENT /Menus /Output Procedures
PQL PROCEDURES /Condescriptive /Condescriptive
PQL PROCEDURES /Condescriptive /Condescriptive
PQL PROCEDURES /Frequencies /Frequencies
PQL PROCEDURES /Plot /Plot
SQL /SET, SHOW and CLEAR /Parameter List
statistics;average
SQL /SQL Functions /Aggregation functions
statistics;count
SQL /SQL Functions /Aggregation functions
statistics;sum
SQL /SQL Functions /Aggregation functions
STATS
SQL /SET, SHOW and CLEAR /Parameter List
STATTYPE function
VISUALPQL /Functions /Alphabetic List of All Functions
status
FORMS /Using Forms /Status Area
FORMS /Using Forms /Status Area
status area
FORMS /General Clauses /BOTTOM
STATUS LINE
VISUALPQL /Graphical User Interface /WINDOW STATUS
STD
SQL /SELECT /Aggregation
STD function
SQL /SQL Functions /Aggregation functions
STD;SUBTOTAL
SQL /DISPLAY /SUBTOTAL
STD;TOTAL
SQL /DISPLAY /TOTAL
STDE
PQL PROCEDURES /Condescriptive /Condescriptive
PQL PROCEDURES /Frequencies /Frequencies
STDERR
PQL PROCEDURES /Tabulate /Statistics
STDEV
PQL PROCEDURES /Frequencies /Frequencies
PQL PROCEDURES /Tabulate /Statistics
STDEV function
VISUALPQL /Functions /Alphabetic List of All Functions
STDEVR function
VISUALPQL /Functions /Alphabetic List of All Functions
STDNAME function
VISUALPQL /Functions /Alphabetic List of All Functions
STDOUT
PQL PROCEDURES /Overview /Common keywords
STDOUT WRITE
VISUALPQL /Reading and Writing Files /WRITE
STDV
PQL PROCEDURES /Condescriptive /Condescriptive
STOP
DATABASE /Data /ADD REC
FORMS /CALL /ONRESTART
FORMS /CALL /ONRETURN
SQL /Control Commands /END
VISUALPQL /Control Flow /EXIT
stop key
FORMS /Using Forms /Flow of Control
stop screens
FORMS /Using Forms /Flow of Control
STOPSCREEN
FORMS /Screens /STOPSCREEN
storage efficiencies
DATABASE /Tuning and Efficiency /Disk Space
STRING
FORMS /Field /DSPTYPE
FORMS /Field /TYPE
FORMS /FORM /
SQL /Tabfiles and Tables /Column Data types
VISUALPQL /Introduction /Variables
VISUALPQL /Variables /STRING
string comparisons;case sensiti
SQL /SET, SHOW and CLEAR /Parameter List
string edit function
VISUALPQL /Functions /Alphabetic List of All Functions
string functions
VISUALPQL /Functions /String Functions
string length
ENVIRONMENT /Appendix /Execution Parameters
ENVIRONMENT /Commands /STRING LENGTH
VISUALPQL /Variables /Implicit Variables
string length function
VISUALPQL /Functions /Alphabetic List of All Functions
string search function
VISUALPQL /Functions /Alphabetic List of All Functions
string to number conversion func
FORMS /COMPUTE /Functions
string to number function
VISUALPQL /Functions /Alphabetic List of All Functions
string variables
DATABASE /Introduction /Defining Variables
DATABASE /Schema /CHARACTER
strings
PQL PROCEDURES /Tabulate /Other Options
VISUALPQL /Variables /Expressions
STRIP
FORMS /Field /DSPEDIT
FORMS /Field /PMTEDIT
STRUCTURED
DATABASE /Schema /SIR SCHEMA LIST
stub format error
PQL PROCEDURES /Tabulate /Error Processing
STUBCONTINUATION
PQL PROCEDURES /Tabulate /Stub Formatting
STUBDIVIDER
PQL PROCEDURES /Tabulate /Stub Formatting
STUBFILLER
PQL PROCEDURES /Tabulate /Stub Formatting
STUBHEIGHT
PQL PROCEDURES /Tabulate /Stub Formatting
STUBINDENTATION
PQL PROCEDURES /Tabulate /Stub Formatting
stubs
PQL PROCEDURES /Tabulate /Expressions
STUBTITLE
PQL PROCEDURES /Tabulate /Stub Formatting
STUBWIDTH
PQL PROCEDURES /Tabulate /Stub Formatting
STUDENTs T-Test
PQL PROCEDURES /Plot /Plot
SUBDIR function
VISUALPQL /Functions /Alphabetic List of All Functions
subheading
ENVIRONMENT /Commands /TASK NAME
SUBPROCEDURE
VISUALPQL /Control Flow /SUBPROCEDURE
subqueries
SQL /SELECT /Subqueries
SUBROUTINE
VISUALPQL /PQLForms /FORM
VISUALPQL /VisualPQL Programs and Routines /RETRIEVAL, PROGRAM, SUBROUTINE
subroutine;input parameters
VISUALPQL /VisualPQL Programs and Routines /RETRIEVAL, PROGRAM, SUBROUTINE
subroutine;returning values
VISUALPQL /VisualPQL Programs and Routines /RETRIEVAL, PROGRAM, SUBROUTINE
subroutines
ENVIRONMENT /Menus /Member Types
subscript, arrays
VISUALPQL /Introduction /Variables
subscripts
VISUALPQL /Introduction /Variables
VISUALPQL /Variables /Arrays
subset
DATABASE /Backup /SIR SUBSET
subset database
ENVIRONMENT /Menus /Unload
subset databases
DATABASE /Tuning and Efficiency /Disk Space
SUBSTR function
VISUALPQL /Functions /Alphabetic List of All Functions
substring function
FORMS /COMPUTE /Functions
VISUALPQL /Functions /Alphabetic List of All Functions
substring search function
VISUALPQL /Functions /Alphabetic List of All Functions
substrings function
FORMS /COMPUTE /Functions
SUBTITLE
FORMS /Compiler Directives /Compiler Directives
PQL PROCEDURES /Descriptive /Descriptive
SUBTOTAL
SQL /SET, SHOW and CLEAR /Parameter List
subtotal variables
PQL PROCEDURES /Quick Report /Syntax
SUBTOTAL;AVG
SQL /DISPLAY /SUBTOTAL
SUBTOTAL;COUNT
SQL /DISPLAY /SUBTOTAL
SUBTOTAL;ERASE
SQL /DISPLAY /Break and Subtotal Columns
SUBTOTAL;EXCEPT
SQL /DISPLAY /Break and Subtotal Columns
SUBTOTAL;MIN
SQL /DISPLAY /SUBTOTAL
SUBTOTAL;STD
SQL /DISPLAY /SUBTOTAL
SUBTOTAL;SUM
SQL /DISPLAY /SUBTOTAL
subtotals
PQL PROCEDURES /Quick Report /Syntax
PQL PROCEDURES /Quick Report /Syntax
PQL PROCEDURES /Quick Report /Syntax
PQL PROCEDURES /Quick Report /Syntax
SQL /DISPLAY /Grouping and Totalling
subtotals;spacing
SQL /SET, SHOW and CLEAR /Parameter List
SUFFIX, GET VARS
VISUALPQL /Variables /GET VARS
suffix;:V
VISUALPQL /Variables /INCLUDE EXTERNAL VARIABLE BLOCK
SUM
PQL PROCEDURES /Condescriptive /Condescriptive
PQL PROCEDURES /Frequencies /Frequencies
SQL /SELECT /Aggregation
SUM function
SQL /SQL Functions /Aggregation functions
VISUALPQL /Functions /Alphabetic List of All Functions
SUM;SUBTOTAL
SQL /DISPLAY /SUBTOTAL
SUM;TOTAL
SQL /DISPLAY /TOTAL
SUMFILE
DATABASE /Data /ADD REC
VISUALPQL /VisualPQL Programs and Routines /RETRIEVAL, PROGRAM, SUBROUTINE
Summary
DATABASE /Data /Batch Data Input Specifications
summary variables
VISUALPQL /Variables /Variables
SUMR function
VISUALPQL /Functions /Alphabetic List of All Functions
SUPQ
SQL /Control Commands /Database Parameters
SVVAL function
VISUALPQL /Functions /Alphabetic List of All Functions
SWAP ITEM
VISUALPQL /Graphical User Interface /Dialog Control Commands
symbol
FORMS /AT, DRAW and TEXT /DRAW
symmetric outer join
SQL /SELECT /Output
synonym
SQL /Control Commands /CREATE SYNONYM
SYNONYM command
FORMS /Compiler Directives /Compiler Directives
synonyms
FORMS /Introduction /Form Structure
syntax rules
SQL /Overview /Syntax Rules
sysproc
ENVIRONMENT /Commands /System Globals
ENVIRONMENT /Menus /Program Members
SYSTAT SAVE FILE
PQL PROCEDURES /SYSTAT Save File /SYSTAT Save File
system date map
SQL /SET, SHOW and CLEAR /Parameter List
SYSTEM family
ENVIRONMENT /Appendix /Login Procedures
ENVIRONMENT /Commands /Member References
SYSTEM function
VISUALPQL /Functions /Alphabetic List of All Functions
SYSTEM functions
FORMS /COMPUTE /Functions
system global variables
ENVIRONMENT /Menus /File Attributes
system globals
ENVIRONMENT /Commands /System Globals
system missing values
VISUALPQL /Variables /Missing Values
system procedure file
ENVIRONMENT /Menus /Program Members
SYSTEM SECURITY
DATABASE /Schema /SYSTEM SECURITY
SYSTEM SECURITY LEVEL
DATABASE /Schema /SYSTEM SECURITY
system tables
SQL /System Tables /System Tables
SYSTEM()
VISUALPQL /Database Access /Case Processing Commands
VISUALPQL /Database Access /Record Processing Commands
VISUALPQL /Database Access /Record Processing Commands