SIR Index		I

I

• I data type
  • DATABASE /Schema /DATA LIST
• I format
  • DATABASE /Introduction /Variable Formats
  • VISUALPQL /Reading and Writing Files /I/O List - Input Specification
  • VISUALPQL /Reading and Writing Files /I/O List - Output Specification
• I/O specifications
  • VISUALPQL /Reading and Writing Files /I/O List - Input Specification
  • VISUALPQL /Reading and Writing Files /I/O List - Output Specification
• IB format
  • VISUALPQL /Reading and Writing Files /I/O List - Input Specification
• ICHAR function
  • VISUALPQL /Functions /List of Functions from A to Z
• IDENT BY
  • SQL /Control Commands /CONNECT TABFILE
• IDENTIFIED BY
  • SQL /Tabfiles and Tables /CREATE TABFILE
• IDSTATUS function
  • VISUALPQL /Functions /List of Functions from A to Z
• IF
  • DATABASE /Schema /IF
  • VISUALPQL /Control Flow /IF, IFNOT
  • FORMS /Screens /FINAL
  • FORMS /Screens /INITIAL
  • FORMS /Field /LOOKUP
  • FORMS /LOOKUP /Syntax
  • FORMS /COMPUTE /11COMPUTE
• IF;CALL
  • VISUALPQL /PQLForms /CALL SCREEN
  • FORMS /CALL /IF
• IF;FIELD
  • VISUALPQL /PQLForms /FIELD
  • FORMS /Field /IF
• IF;FINAL
  • FORMS /Field /FINAL
• IFCOND
  • ENVIRONMENT /Commands /Input Flow Control
• IFFAMILY
  • ENVIRONMENT /Commands /CIF END
• IFGLOBAL
  • ENVIRONMENT /Commands /CIF END
• IFMEMBER
  • ENVIRONMENT /Commands /CIF END
• IFNOT
  • VISUALPQL /Control Flow /IF, IFNOT
• IFNOTFAMILY
  • ENVIRONMENT /Commands /CIF END
• IFNOTGLOBAL
  • ENVIRONMENT /Commands /CIF END
• IFNOTMEMBER
  • ENVIRONMENT /Commands /CIF END
• IFNOTTHEN
  • VISUALPQL /Control Flow /IFTHEN
• IFTHEN
  • VISUALPQL /Control Flow /IFTHEN
• IMAGE
  • VISUALPQL /Graphical User Interface /IMAGE
• implicit variables
  • VISUALPQL /Introduction /Variables
  • VISUALPQL /Variables /Implicit Variables
• IMPORT
  • DATABASE /Backup /IMPORT
• IN
  • SQL /Control Commands /Execution Statement
  • FORMS /Field /LOOKUP
  • FORMS /LOOKUP /Syntax
• IN operator
  • SQL /SELECT /WHERE
• IN parameter
  • ENVIRONMENT /Appendix /Login Procedures
• INCLUDE
  • ENVIRONMENT /Commands /Parameter Substitution
  • VISUALPQL /Variables /DEFINE PROCEDURE VARIABLES
  • VISUALPQL /PQLForms /GENERATE
  • VISUALPQL PROCEDURES /Overview /Procedure Table
  • SQL /DISPLAY /EXCLUDE and INCLUDE
• include
  • FORMS /Introduction /Form Structure
• INCLUDE
  • FORMS /Compiler Directives /4Compiler Directives
  • FORMS /FORM /USERS
  • FORMS /GENERATE /Syntax
• INCLUDE EXTERNAL VARIABLE
  • VISUALPQL /Variables /INCLUDE EXTERNAL VARIABLE BLOCK
• increment
  • VISUALPQL /Database Access /PROCESS CASE
• index name
  • DATABASE /Schema /CREATE DBINDEX
• index variable function
  • VISUALPQL /Functions /List of Functions from A to Z
• index;block
  • DATABASE /Tuning and Efficiency /Loading Factor
• index;database
  • DATABASE /Tuning and Efficiency /Disk Space
• INDEXED BY
  • DATABASE /Data /SIR SPREADSHEET
  • VISUALPQL /Database Access /PROCESS REC
  • VISUALPQL /Accessing Tables /PROCESS ROWS
  • VISUALPQL /Accessing Tables /ROW IS
• indexes, unique
  • SQL /Tabfiles and Tables /CREATE INDEX
• INFILE
  • ENVIRONMENT /Appendix /Login Procedures
• INFORMATION BOX
  • VISUALPQL /Graphical User Interface /Other GUI Commands
• init
  • FORMS /Using Forms /Status Area
• INITIAL
  • VISUALPQL /Graphical User Interface /INITIAL
  • VISUALPQL /Graphical User Interface /Dialog Message Processing
  • VISUALPQL /PQLForms /SCREEN
  • FORMS /Screens /INITIAL
• INITIAL BLOCK
  • VISUALPQL PROCEDURES /Full Report /INITIAL BLOCK
• INITIAL COMPUTE
  • FORMS /Field /INITIAL
  • FORMS /CALL /INITIAL
• INITIAL IF
  • FORMS /CALL /INITIAL
• inner join
  • SQL /SELECT /Output
• INPUT
  • DATABASE /Data /ADD REC
  • SQL /SET, SHOW and CLEAR /Parameter List
• Input data
  • DATABASE /Data /Batch Data Input Specifications
• INPUT FORMAT
  • DATABASE /Schema /INPUT FORMAT
• input formats
  • VISUALPQL /Reading and Writing Files /I/O List - Input Specification
• input function
  • VISUALPQL /Functions /List of Functions from A to Z
  • VISUALPQL /Functions /List of Functions from A to Z
• INSERT
  • VISUALPQL /Execution Window /FIELD INPUT
  • FORMS /Field /INSERT | OVERSTRIKE
• INSERT DCONTROL
  • VISUALPQL /Graphical User Interface /DEDIT
• INSERT INTO
  • SQL /Data Entry and Modification /INSERT INTO
• INSERT INTO;SELECT
  • SQL /Data Entry and Modification /INSERT INTO
• INSERT ITEM
  • VISUALPQL /Graphical User Interface /Dialog Control Commands
• INSERT LINE INTO BUFFER
  • VISUALPQL /Buffers /INSERT LINE INTO BUFFER
• insert mode
  • FORMS /Using Forms /Entering Data
• INSERT TEXT
  • VISUALPQL /Graphical User Interface /Dialog Control Commands
• INT function
  • SQL /SQL Functions /Standard Functions
  • FORMS /COMPUTE /Functions
• INTEGER
  • VISUALPQL /Introduction /Variables
  • VISUALPQL /Variables /INTEGER
  • VISUALPQL PROCEDURES /Frequencies /8Frequencies
  • FORMS /FORM /
  • FORMS /Field /DSPTYPE
  • FORMS /Field /TYPE
• integer function
  • VISUALPQL /Functions /List of Functions from A to Z
• Integer Ranges
  • VISUALPQL /Introduction /Variables
• integer variables
  • DATABASE /Introduction /Defining Variables
  • DATABASE /Schema /INTEGER
• Integer variables
  • VISUALPQL /Variables /INTEGER
• INTEGER*n
  • DATABASE /Schema /INTEGER
• internal variable formats
  • DATABASE /Introduction /Variable Formats
• internals
  • DATABASE /Tuning and Efficiency /Database Internal Structure
• internet
  • ENVIRONMENT /Appendix /Execution Parameters
• INTERSECTION
  • FORMS /AT, DRAW and TEXT /DRAW
• INTERVALS
  • VISUALPQL PROCEDURES /Descriptive /6Descriptive
  • VISUALPQL PROCEDURES /Frequencies /8Frequencies
• INVERSE
  • FORMS /General Clauses /video_options
• inverse video
  • FORMS /General Clauses /video_options
• inverted list
  • FORMS /CALL /9CALL
• IOSTAT
  • VISUALPQL /Reading and Writing Files /OPEN
  • VISUALPQL /Reading and Writing Files /READ
  • VISUALPQL /Accessing Tables /PQL CONNECT TABFILE
  • VISUALPQL /Accessing Tables /PQL DISCONNECT TABFILE
• IOSTAT =
  • VISUALPQL /Reading and Writing Files /WRITE
• ISDNUMBER
  • VISUALPQL PROCEDURES /Tabulate /Statistics
• ITEMIZE FILE
  • DATABASE /Backup /ITEMIZE FILE