SIR Index		L

L

• L debug command
  • VISUALPQL /The VisualPQL Debuggers /The Top Bar Menu
• L format
  • VISUALPQL PROCEDURES /CSV Save File /4CSV Save File
  • VISUALPQL PROCEDURES /Quick Report /Syntax
• l picture
  • VISUALPQL /Reading and Writing Files /I/O List - Input Specification
• LABEL
  • VISUALPQL /Graphical User Interface /LABEL
  • SQL /SET, SHOW and CLEAR /Parameter List
• label segmentation
  • VISUALPQL PROCEDURES /Tabulate /Print Formatting
  • VISUALPQL PROCEDURES /Tabulate /Other Options
• LABEL;FORMAT
  • SQL /SELECT /Column Formats
• Label;PQLForms
  • VISUALPQL /PQLForms /PQLForms General Clauses
• labels
  • DATABASE /Introduction /Variable Labels
• LABELS
  • DATABASE /Schema /SIR SCHEMA LIST
  • DATABASE /Data /SIR SPREADSHEET
• labels
  • VISUALPQL /Variables /VAR LABELS
  • VISUALPQL PROCEDURES /CSV Save File /4CSV Save File
  • VISUALPQL PROCEDURES /Quick Report /Syntax
  • VISUALPQL PROCEDURES /Tabulate /Print Formatting
• LABELS
  • FORMS /General Clauses /LABELS
• LABELS;ENTER INTO
  • SQL /Data Entry and Modification /ENTER INTO
• LABELS;PQLForms
  • VISUALPQL /PQLForms /PQLForms General Clauses
• LANGUAGE
  • VISUALPQL PROCEDURES /Tabulate /Other Options
• LAST
  • VISUALPQL /PQLForms /ABUTTON
  • SQL /SELECT /Aggregation
  • FORMS /CALL /ONRETURN
• LAST function
  • SQL /SQL Functions /Aggregation functions
• last record key
  • FORMS /Using Forms /Accessing Records and Rows
• last value function
  • VISUALPQL /Functions /List of Functions from A to Z
  • VISUALPQL /Functions /List of Functions from A to Z
• LAST;PQLForms
  • VISUALPQL /PQLForms /Using PQLForms
• LE
  • VISUALPQL /Control Flow /Logical Conditions
  • FORMS /COMPUTE /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
  • VISUALPQL /Execution Window /FIELD INPUT
  • VISUALPQL PROCEDURES /Quick Report /Syntax
  • VISUALPQL PROCEDURES /Quick Report /Syntax
  • SQL /DISPLAY /Headings and Footings
  • FORMS /Field /DSPEDIT
  • FORMS /Field /PMTEDIT
• left outer join
  • SQL /SELECT /Output
• LEN function
  • VISUALPQL /Functions /List of Functions from A to Z
  • SQL /SQL Functions /Standard Functions
  • FORMS /COMPUTE /Functions
• LENGTH
  • FORMS /Field /LENGTH
• length of string function
  • FORMS /COMPUTE /Functions
• level
  • VISUALPQL PROCEDURES /Full Report /BREAK LEVEL
• LG function
  • FORMS /COMPUTE /Functions
• LG10 function
  • VISUALPQL /Functions /List of Functions from A to Z
• LIBRARY
  • VISUALPQL /VisualPQL Programs and Routines /RETRIEVAL, PROGRAM, SUBROUTINE
• LIKE
  • SQL /SELECT /WHERE
  • FORMS /Using Forms /Search Mode
  • FORMS /COMPUTE /Conditions
• 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
  • VISUALPQL /Graphical User Interface /LINE
  • VISUALPQL PROCEDURES /Plot /11Plot
• LINE CHARACTER
  • VISUALPQL /Execution Window /LINE CHARACTER
• line debugger
  • VISUALPQL /The VisualPQL Debuggers /Interactive Line Mode Monitor
• 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 /GCOMPUTE
• lines
  • FORMS /AT, DRAW and TEXT /DRAW
• LINESET
  • FORMS /AT, DRAW and TEXT /TEXT
• LINETRACE
  • VISUALPQL /The VisualPQL Debuggers /Run Time Debugger
• linewid
  • ENVIRONMENT /Commands /GCOMPUTE
• LIST
  • VISUALPQL /Database Access /PROCESS CASE
  • VISUALPQL /Graphical User Interface /LIST
  • VISUALPQL /Graphical User Interface /Dialog Message Processing
  • VISUALPQL /Execution Window /MENU
  • VISUALPQL /The VisualPQL Debuggers /Interactive Debugger Commands
• LIST DATABASE
  • DATABASE /Schema /SET DATABASE
• 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 /15Running FORMS
• listing data
  • DATABASE /Data /SIR FILE LIST
• listing schema
  • DATABASE /Schema /SIR SCHEMA LIST
• Lists of Variables
  • VISUALPQL /Variables /Variable Lists
• LN function
  • VISUALPQL /Functions /List of Functions from A to Z
  • FORMS /COMPUTE /Functions
• LO
  • VISUALPQL /Variables /RECODE
• load factor
  • DATABASE /Backup /RELOAD FILE
• LOADING
  • ENVIRONMENT /Commands /SCREEN OFF
  • DATABASE /Data /ADD REC
  • 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
  • VISUALPQL /Execution Window /RESTORE TEMPLATE
  • VISUALPQL /Execution Window /STORE TEMPLATE
• local variables
  • VISUALPQL /Introduction /Variables
  • VISUALPQL /Variables /3Variables
• Local Variables
  • VISUALPQL /Variables /Database Variables
• locating records
  • FORMS /Using Forms /Accessing Records and Rows
• LOCK
  • DATABASE /Schema /RECORD SCHEMA
  • DATABASE /Schema Modification /MODIFY SCHEMA
  • VISUALPQL /VisualPQL Programs and Routines /RETRIEVAL, PROGRAM, SUBROUTINE
  • VISUALPQL /Database Access /CASE IS
  • VISUALPQL /Database Access /PROCESS CASE
  • VISUALPQL /Database Access /RECORD IS
  • VISUALPQL /Database Access /PROCESS REC
  • FORMS /Field /LOOKUP
  • FORMS /CALL /LOCK
  • FORMS /LOOKUP /Syntax
• LOCK =
  • VISUALPQL /Database Access /Concurrent VisualPQL
• lock types
  • ENVIRONMENT /Concurrency / Running Master
  • VISUALPQL /VisualPQL Programs and Routines /RETRIEVAL, PROGRAM, SUBROUTINE
• locked records
  • FORMS /CALL /9CALL
• locking
  • FORMS /Concurrency /Locking
• locking record types
  • DATABASE /Schema Modification /MODIFY SCHEMA
• Log
  • DATABASE /Data /Batch Data Input Specifications
• log base 10 function
  • VISUALPQL /Functions /List of Functions from A to Z
• LOG function
  • VISUALPQL /Functions /List of Functions from A to Z
  • FORMS /COMPUTE /Functions
• LOG10 function
  • VISUALPQL /Functions /List of Functions from A to Z
  • FORMS /COMPUTE /Functions
• LOGALL
  • DATABASE /Data /ADD REC
• logarithm function
  • VISUALPQL /Functions /List of Functions from A to Z
  • FORMS /COMPUTE /Functions
  • FORMS /COMPUTE /Functions
  • FORMS /COMPUTE /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 /Running in Batch
• LONG
  • DATABASE /Schema /SIR SCHEMA LIST
• 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
  • VISUALPQL /Functions /List of Functions from A to Z
  • SQL /SQL Functions /Standard Functions
  • FORMS /COMPUTE /Functions
• LOWERCASE
  • FORMS /Field /DSPEDIT
  • FORMS /Field /PMTEDIT
• lowercase
  • FORMS /COMPUTE /Functions
• LOWEST
  • VISUALPQL /Variables /RECODE
  • SQL /Tabfiles and Tables /Column Options
• LRECL
  • VISUALPQL /Reading and Writing Files /OPEN
  • VISUALPQL PROCEDURES /SAS Save File /14SAS Save File
  • VISUALPQL PROCEDURES /SAS Save File /14SAS Save File
  • VISUALPQL PROCEDURES /WRITE RECORDS /21WRITE RECORDS
• LST function
  • VISUALPQL /Functions /List of Functions from A to Z
• LSTR function
  • VISUALPQL /Functions /List of Functions from A to Z
• LT
  • VISUALPQL /Control Flow /Logical Conditions
  • FORMS /COMPUTE /Conditions
• LT operator
  • SQL /SELECT /WHERE
• LTEE
  • FORMS /AT, DRAW and TEXT /DRAW