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		L

L

• L format
  • PQL PROCEDURES /CSV Save File /CSV Save File
  • PQL PROCEDURES /Quick Report /Syntax
• l picture
  • VISUALPQL /Reading and Writing Files /I/O List - Input Specification
• label
  • DATABASE /Introduction /Variable Label
  • SQL /SET, SHOW and CLEAR /Parameter List
  • VISUALPQL /Graphical User Interface /LABEL
• label segmentation
  • PQL PROCEDURES /Tabulate /Print Formatting
  • PQL PROCEDURES /Tabulate /Other Options
• LABEL;FORMAT
  • SQL /SELECT /Column Formats
• Label;PQLForms
  • VISUALPQL /PQLForms /PQLForms General Clauses
• LABELS
  • DATABASE /Data /SIR SPREADSHEET
  • DATABASE /Schema /SIR SCHEMA LIST
  • ENVIRONMENT /Commands /Input Flow Control
  • FORMS /General Clauses /LABELS
  • PQL PROCEDURES /CSV Save File /CSV Save File
  • PQL PROCEDURES /Quick Report /Syntax
  • PQL PROCEDURES /Tabulate /Print Formatting
  • VISUALPQL /Control Flow /JUMP
  • VISUALPQL /Variables /VAR LABEL
• LABELS;ENTER INTO
  • SQL /Data Entry and Modification /ENTER INTO
• LABELS;PQLForms
  • VISUALPQL /PQLForms /PQLForms General Clauses
• LANGUAGE
  • PQL PROCEDURES /Tabulate /Other Options
• LAST
  • FORMS /CALL /ONRETURN
  • SQL /SELECT /Aggregation
  • VISUALPQL /PQLForms /ABUTTON
• LAST function
  • SQL /SQL Functions /Aggregation functions
• last record key
  • FORMS /Using Forms /Accessing Records and Rows
• last value function
  • VISUALPQL /Functions /Alphabetic List of All Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• LAST;PQLForms
  • VISUALPQL /PQLForms /Using PQLForms
• LE
  • FORMS /COMPUTE /Conditions
  • VISUALPQL /Control Flow /Logical Conditions
• LE operator
  • SQL /SELECT /WHERE
• LEADING
  • FORMS /Field /DSPEDIT
  • FORMS /Field /PMTEDIT
• leading zeros
  • SQL /SET, SHOW and CLEAR /Parameter List
• leaving data
  • FORMS /Using Forms /Accessing Records and Rows
• LEFT
  • FORMS /Field /DSPEDIT
  • FORMS /Field /PMTEDIT
  • PQL PROCEDURES /Quick Report /Syntax
  • PQL PROCEDURES /Quick Report /Syntax
  • SQL /DISPLAY /Headings and Footings
• left outer join
  • SQL /SELECT /Output
• LEN function
  • FORMS /COMPUTE /Functions
  • SQL /SQL Functions /Standard Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• LENGTH
  • FORMS /Field /LENGTH
• length of string function
  • FORMS /COMPUTE /Functions
• level
  • PQL PROCEDURES /Full Report /BREAK LEVEL
• LG function
  • FORMS /COMPUTE /Functions
• LG10 function
  • VISUALPQL /Functions /Alphabetic List of All Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• LIBRARY
  • VISUALPQL /VisualPQL Programs and Routines /RETRIEVAL, PROGRAM, SUBROUTINE
• LIKE
  • FORMS /COMPUTE /Conditions
  • FORMS /Using Forms /Search Mode
  • SQL /SELECT /WHERE
• limits;case
  • SQL /SET, SHOW and CLEAR /Parameter List
• limits;records processed
  • SQL /SET, SHOW and CLEAR /Parameter List
• limits;rows selected
  • SQL /SET, SHOW and CLEAR /Parameter List
• LINE
  • PQL PROCEDURES /Plot /Plot
  • VISUALPQL /Graphical User Interface /LINE
• line spacing
  • SQL /SET, SHOW and CLEAR /Parameter List
  • SQL /SET, SHOW and CLEAR /Parameter List
• line width
  • SQL /SET, SHOW and CLEAR /Parameter List
• linecnt
  • ENVIRONMENT /Commands /System Globals
• lines
  • FORMS /AT, DRAW and TEXT /DRAW
• LINES function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• LINESET
  • FORMS /AT, DRAW and TEXT /TEXT
• linewid
  • ENVIRONMENT /Commands /System Globals
• LIST
  • VISUALPQL /Database Access /PROCESS CASE
  • VISUALPQL /Graphical User Interface /Dialog Message Processing
  • VISUALPQL /Graphical User Interface /LIST
• list data
  • ENVIRONMENT /Menus /List File
• LIST DATABASE
  • DATABASE /Schema /SET DATABASE
• list file
  • ENVIRONMENT /Menus /List File
• LIST STATS
  • DATABASE /Backup /LIST STATS
• LIST STATS;sample
  • DATABASE /Tuning and Efficiency /Size Estimating
• LIST STATS;size estimating
  • DATABASE /Tuning and Efficiency /Size Estimating
• LISTFILE
  • DATABASE /Data /ADD REC
• LISTING
  • FORMS /Running FORMS /Running FORMS
• listing data
  • DATABASE /Data /SIR FILE LIST
• listing schema
  • DATABASE /Schema /SIR SCHEMA LIST
• Lists of Variables
  • VISUALPQL /Variables /Variable Lists
• LN function
  • FORMS /COMPUTE /Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• LO
  • VISUALPQL /Variables /RECODE
• load factor
  • DATABASE /Backup /RELOAD FILE
• LOADING
  • DATABASE /Data /ADD REC
  • ENVIRONMENT /Commands /SETCLEAR
  • VISUALPQL /VisualPQL Programs and Routines /RETRIEVAL, PROGRAM, SUBROUTINE
• loading factor
  • DATABASE /Tuning and Efficiency /Disk Space
  • DATABASE /Tuning and Efficiency /Loading Factor
• LOADMAP
  • VISUALPQL /VisualPQL Programs and Routines /RETRIEVAL, PROGRAM, SUBROUTINE
• local variables
  • VISUALPQL /Introduction /Variables
  • VISUALPQL /Variables /Variables
  • VISUALPQL /Variables /Database Variables
• locating records
  • FORMS /Using Forms /Accessing Records and Rows
• LOCK
  • DATABASE /Schema /RECORD SCHEMA
  • DATABASE /Schema /WRITE SCHEMA
  • FORMS /CALL /LOCK
  • FORMS /Field /LOOKUP
  • FORMS /LOOKUP /Syntax
  • VISUALPQL /Database Access /CASE IS
  • VISUALPQL /Database Access /PROCESS CASE
  • VISUALPQL /Database Access /RECORD IS
  • VISUALPQL /Database Access /PROCESS REC
  • VISUALPQL /VisualPQL Programs and Routines /RETRIEVAL, PROGRAM, SUBROUTINE
• LOCK =
  • VISUALPQL /Database Access /Concurrent VisualPQL
• lock types
  • ENVIRONMENT /Concurrency / Record Locking
  • VISUALPQL /VisualPQL Programs and Routines /RETRIEVAL, PROGRAM, SUBROUTINE
• locked records
  • FORMS /CALL /CALL
• locking
  • FORMS /Concurrency /Locking
• locking record types
  • DATABASE /Schema /RECORD SCHEMA
• Log
  • DATABASE /Data /Batch Data Input Specifications
• log base 10 function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• LOG function
  • FORMS /COMPUTE /Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• LOG10 function
  • FORMS /COMPUTE /Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• LOGALL
  • DATABASE /Data /ADD REC
  • DATABASE /Data /READ INPUT DATA
  • DATABASE /Data /REPLACE REC
  • DATABASE /Data /UPDATE REC
• logarithm function
  • FORMS /COMPUTE /Functions
  • FORMS /COMPUTE /Functions
  • FORMS /COMPUTE /Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• LOGFILE
  • DATABASE /Data /ADD REC
• LOGFILE format
  • DATABASE /Data /Batch Data Input Specifications
• logical block
  • DATABASE /Tuning and Efficiency /Block Organisation
• logical operations
  • VISUALPQL /Control Flow /Logical Conditions
• logical operators
  • SQL /SELECT /WHERE
• logical values
  • VISUALPQL /Control Flow /Compound Conditions
• login procedure
  • ENVIRONMENT /Appendix /Login Procedures
• LONG
  • DATABASE /Schema /SIR SCHEMA LIST
• LONGLAB
  • PQL PROCEDURES /SPSS Save File /SPSS Save File
• LOOKUP
  • VISUALPQL /Database Access /LOOKUP
• LOOKUP;FIELD
  • FORMS /Field /LOOKUP
• LOOP
  • VISUALPQL /Control Flow /LOOP
• LOWER
  • SQL /DISPLAY /PRINT and WRITE
  • SQL /SET, SHOW and CLEAR /Parameter List
• lower & upper case
  • SQL /SET, SHOW and CLEAR /Parameter List
• LOWER function
  • FORMS /COMPUTE /Functions
  • SQL /SQL Functions /Standard Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• lowercase
  • FORMS /COMPUTE /Functions
  • FORMS /Field /DSPEDIT
  • FORMS /Field /PMTEDIT
• LOWEST
  • SQL /Tabfiles and Tables /Column Options
  • VISUALPQL /Variables /RECODE
• LRECL
  • PQL PROCEDURES /SAS Save File /SAS Save File
  • PQL PROCEDURES /WRITE RECORDS /WRITE RECORDS
  • VISUALPQL /Reading and Writing Files /OPEN
• LST function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• LSTR function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• LT
  • FORMS /COMPUTE /Conditions
  • VISUALPQL /Control Flow /Logical Conditions
• LT operator
  • SQL /SELECT /WHERE
• LTEE
  • FORMS /AT, DRAW and TEXT /DRAW