SIR Index		C

C

• C commas
  • VISUALPQL PROCEDURES /CSV Save File /4CSV Save File
  • VISUALPQL PROCEDURES /Quick Report /Syntax
• c picture
  • VISUALPQL /Reading and Writing Files /I/O List - Input Specification
• C reprinting
  • VISUALPQL PROCEDURES /Quick Report /Syntax
• CALL
  • ENVIRONMENT /Commands /Parameter Substitution
  • FORMS /CALL /9CALL
• CALL SCREEN
  • VISUALPQL /PQLForms /CALL SCREEN
• CALL;automatic
  • FORMS /CALL /9CALL
• CALL;PRINTBACK
  • ENVIRONMENT /Appendix /Login Procedures
• CALL;procedures
  • SQL /Control Commands /CALL
• CALL;user commands
  • FORMS /CALL /9CALL
• calling
  • FORMS /Using Forms /Flow of Control
• cancel command
  • FORMS /Using Forms /Accessing Records and Rows
• cancel updates
  • FORMS /Using Forms /Accessing Records and Rows
• CAPITAL function
  • VISUALPQL /Functions /List of Functions from A to Z
• capitalisation function
  • VISUALPQL /Functions /List of Functions from A to Z
• CAPITALIZE
  • FORMS /Field /DSPEDIT
  • FORMS /Field /PMTEDIT
• CASE
  • SQL /SET, SHOW and CLEAR /Parameter List
• CASE ID
  • DATABASE /Schema /CASE ID
• CASE IS
  • VISUALPQL /Database Access /CASE IS
  • VISUALPQL /Database Access /CASE IS
• case lock
  • FORMS /Concurrency /LOCK
• case processing
  • VISUALPQL /Database Access /PROCESS CASE
• case structured database
  • DATABASE /Introduction /Overview
• case;effect on aggregations
  • SQL /SELECT /GROUP BY
• CASE;effect on joins
  • SQL /SELECT /PATHS
• CASE;mode
  • SQL /SELECT /PATHS
• CASEID
  • VISUALPQL PROCEDURES /SIR Save File /16SIR Save File
• caseless database
  • DATABASE /Introduction /Overview
  • VISUALPQL PROCEDURES /SIR Save File /16SIR Save File
• CASELIM
  • SQL /SET, SHOW and CLEAR /Parameter List
• CASELIM;on SELECT
  • SQL /SELECT /Keywords
• CASELOCK
  • VISUALPQL /Database Access /Concurrent VisualPQL
• CASELOCK function
  • VISUALPQL /Functions /List of Functions from A to Z
• cases;records per case
  • DATABASE /Schema /RECS PER CASE
• cases;selecting a subset
  • DATABASE /Data /SIR FILE LIST
• CASWGT
  • VISUALPQL PROCEDURES /SPSS Save File /18SPSS Save File
• cat var function
  • VISUALPQL /Functions /List of Functions from A to Z
  • VISUALPQL /Functions /List of Functions from A to Z
• CAT VARS
  • DATABASE /Schema /CAT VARS
• CATEGORICAL
  • SQL /Tabfiles and Tables /Column Data types
• categorical variables
  • DATABASE /Introduction /Defining Variables
  • DATABASE /Schema /CAT VARS
  • DATABASE /Tuning and Efficiency /Disk Space
  • VISUALPQL PROCEDURES /Tabulate /Variable Types
• CATINT function
  • VISUALPQL /Functions /List of Functions from A to Z
• CATSTR function
  • VISUALPQL /Functions /List of Functions from A to Z
• cblevel
  • ENVIRONMENT /Commands /GCOMPUTE
• CCF
  • DATABASE /Backup /VERIFY FILE
• CDATE function
  • VISUALPQL /Functions /List of Functions from A to Z
  • SQL /SQL Functions /Standard Functions
  • FORMS /COMPUTE /Functions
• CEILING function
  • FORMS /COMPUTE /Functions
• cell contents error
  • VISUALPQL PROCEDURES /Tabulate /Error Processing
• cells
  • VISUALPQL PROCEDURES /Tabulate /
• CENTER
  • VISUALPQL PROCEDURES /Quick Report /Syntax
  • VISUALPQL PROCEDURES /Quick Report /Syntax
  • SQL /DISPLAY /Headings and Footings
  • FORMS /AT, DRAW and TEXT /DRAW
  • FORMS /AT, DRAW and TEXT /TEXT
• CENTER function
  • VISUALPQL /Functions /List of Functions from A to Z
• CENY
  • ENVIRONMENT /Commands /SCREEN OFF
  • SQL /Control Commands /Environment Parameters
• CENY parameter
  • ENVIRONMENT /Appendix /Login Procedures
  • FORMS /Running FORMS /15Running FORMS
• cgi
  • ENVIRONMENT /Appendix /Execution Parameters
• CGI WRITE
  • VISUALPQL /Reading and Writing Files /WRITE
• CGIBUFPN function
  • VISUALPQL /Functions /List of Functions from A to Z
• CGIBUFSV function
  • VISUALPQL /Functions /List of Functions from A to Z
• CGIVARPN function
  • VISUALPQL /Functions /List of Functions from A to Z
• CGIVARSV function
  • VISUALPQL /Functions /List of Functions from A to Z
• change CIR lock type
  • VISUALPQL /Functions /List of Functions from A to Z
  • VISUALPQL /Functions /List of Functions from A to Z
• changing record definition
  • DATABASE /Schema Modification /MODIFY SCHEMA
• CHAR function
  • VISUALPQL /Functions /List of Functions from A to Z
• CHARACTER
  • DATABASE /Schema /CHARACTER
  • VISUALPQL /Execution Window /BOX
  • VISUALPQL /Execution Window /FILL
  • VISUALPQL /Execution Window /SENSE MOUSE
  • SQL /Tabfiles and Tables /Column Data types
• character variables
  • DATABASE /Introduction /Defining Variables
• CHECK
  • DATABASE /Backup /VERIFY FILE
  • VISUALPQL /Graphical User Interface /CHECK
  • VISUALPQL /Graphical User Interface /Dialog Message Processing
• CHECK ITEM
  • VISUALPQL /Graphical User Interface /Dialog Control Commands
• CHECK MENUITEM
  • VISUALPQL /Graphical User Interface /CHECK MENUITEMUNCHECK MENUITEM
• CHECK OPTION;CREATE VIEW
  • SQL /Paths and Views /CREATE VIEW
• CHOICE
  • VISUALPQL /Graphical User Interface /CHOICE
  • VISUALPQL /Graphical User Interface /Dialog Message Processing
• chunk format error
  • VISUALPQL PROCEDURES /Tabulate /Error Processing
• CI
  • VISUALPQL PROCEDURES /Condescriptive /3Condescriptive
  • VISUALPQL PROCEDURES /Frequencies /8Frequencies
• CIF command
  • ENVIRONMENT /Commands /DO REPEAT
• CIF END
  • ENVIRONMENT /Commands /CIF FALSE | TRUE | TF
• CIF FALSE
  • ENVIRONMENT /Commands /CIF
• CIF TF
  • ENVIRONMENT /Commands /CIF
• CIF TRUE
  • ENVIRONMENT /Commands /CIF
• CIR
  • DATABASE /Introduction /Overview
  • DATABASE /Schema /SIR SCHEMA LIST
  • DATABASE /Schema /WRITE SCHEMA
• CIR/REC
  • FORMS /Using Forms /Status Area
• CIR;COMMON VARS
  • DATABASE /Schema /COMMON VARS
• CIR;counts
  • DATABASE /Schema /MAX REC COUNT
• CIR;updating
  • DATABASE /Schema /COMMON VARS
• CIRDATA
  • DATABASE /Backup /VERIFY FILE
• CIRKEY
  • DATABASE /Backup /VERIFY FILE
• CIRLOCK
  • VISUALPQL /VisualPQL Programs and Routines /RETRIEVAL, PROGRAM, SUBROUTINE
• CIRLOCK function
  • VISUALPQL /Functions /List of Functions from A to Z
• CLEAR
  • ENVIRONMENT /Commands /SCREEN OFF
  • VISUALPQL /PQLForms /FORM
  • VISUALPQL /PQLForms /SCREEN
  • VISUALPQL /PQLForms /ABUTTON
  • VISUALPQL /The VisualPQL Debuggers /SET, CLEAR and SHOW
  • SQL /SET, SHOW and CLEAR /4SET, SHOW and CLEAR
  • FORMS /CALL /CLEAR
• CLEAR ALL
  • VISUALPQL /Graphical User Interface /Dialog Control Commands
• CLEAR BUFFER
  • VISUALPQL /Buffers /CLEAR BUFFER
• clear character
  • FORMS /General Clauses /CLEAR
• CLEAR clause
  • FORMS /General Clauses /CLEAR
• CLEAR DCONTROL
  • VISUALPQL /Graphical User Interface /DEDIT
• CLEAR MASTER
  • ENVIRONMENT /Commands /SCREEN OFF
• CLEAR SELECT ITEM
  • VISUALPQL /Graphical User Interface /Dialog Control Commands
• CLEAR;PQLForms
  • VISUALPQL /PQLForms /Using PQLForms
• CLOSE
  • VISUALPQL /Reading and Writing Files /CLOSE
• CLOSE TABLE
  • VISUALPQL /Accessing Tables /CLOSE TABLE
• CLOSETABLE
  • VISUALPQL /Accessing Tables /PROCESS ROWS
• CMP
  • FORMS /Running FORMS /15Running FORMS
• CMPTRIM
  • SQL /SET, SHOW and CLEAR /Parameter List
• CMPUPPER
  • SQL /SET, SHOW and CLEAR /Parameter List
• CNT function
  • VISUALPQL /Functions /List of Functions from A to Z
  • FORMS /COMPUTE /Functions
• CNTR function
  • VISUALPQL /Functions /List of Functions from A to Z
• co-ordinates;PQLForms
  • VISUALPQL /PQLForms /PQLForms General Clauses
• coefficient of variability
  • VISUALPQL PROCEDURES /Condescriptive /3Condescriptive
  • VISUALPQL PROCEDURES /Frequencies /8Frequencies
• COLCOUNT function
  • VISUALPQL /Functions /List of Functions from A to Z
• COLHEAD
  • VISUALPQL PROCEDURES /Quick Report /Syntax
  • SQL /SET, SHOW and CLEAR /Parameter List
• COLLABEL function
  • VISUALPQL /Functions /List of Functions from A to Z
• COLLAPSE
  • VISUALPQL PROCEDURES /Tabulate /Page Formatting
• COLLEN function
  • VISUALPQL /Functions /List of Functions from A to Z
• COLNAME function
  • VISUALPQL /Functions /List of Functions from A to Z
• Colours, Execution Window
  • ENVIRONMENT /Compatibility /Key Mapping
• COLTYPE function
  • VISUALPQL /Functions /List of Functions from A to Z
• column break
  • VISUALPQL PROCEDURES /Quick Report /12Quick Report
• column data types
  • SQL /Tabfiles and Tables /Column Data types
• column formats
  • SQL /SELECT /Column Formats
• column headings
  • VISUALPQL PROCEDURES /Quick Report /Syntax
  • VISUALPQL PROCEDURES /Tabulate /Variable Modifiers
  • SQL /SET, SHOW and CLEAR /Parameter List
• column reprinting headings
  • VISUALPQL PROCEDURES /Quick Report /Syntax
• column separation
  • SQL /SET, SHOW and CLEAR /Parameter List
• column width
  • SQL /SET, SHOW and CLEAR /Parameter List
  • SQL /SET, SHOW and CLEAR /Parameter List
• COLUMN;DISPLAY
  • SQL /DISPLAY /Formatting Commands
• columns
  • VISUALPQL PROCEDURES /Tabulate /
• Columns;PQLForms
  • VISUALPQL /PQLForms /PQLForms General Clauses
• COLVALN function
  • VISUALPQL /Functions /List of Functions from A to Z
• COLVALS function
  • VISUALPQL /Functions /List of Functions from A to Z
• comma
  • VISUALPQL PROCEDURES /CSV Save File /4CSV Save File
  • VISUALPQL PROCEDURES /Quick Report /Syntax
• COMMA
  • FORMS /Field /DSPEDIT
  • FORMS /Field /DSPEDIT
• COMMA function
  • VISUALPQL /Functions /List of Functions from A to Z
• Commands
  • ENVIRONMENT /Commands /Form Properties
• COMMANDS
  • ENVIRONMENT /Commands /ERROR LIMIT
• Commands
  • ENVIRONMENT /Commands /WARNING LIMIT
• commands
  • FORMS /CALL /9CALL
• commands;keys
  • FORMS /Using Forms /Keys and Commands
• commands;overview
  • FORMS /Introduction /Commands
  • FORMS /Using Forms /Entering Commands
• COMMANDS;PRINTBACK
  • ENVIRONMENT /Appendix /Login Procedures
• commands;symbols
  • FORMS /Using Forms /Keys and Commands
• comment
  • ENVIRONMENT /Commands /4Commands
• comments
  • FORMS /Introduction /Form Structure
  • FORMS /Compiler Directives /4Compiler Directives
• COMMON
  • FORMS /GENERATE /Syntax
• common information record
  • DATABASE /Introduction /Overview
• COMMON SECURITY
  • DATABASE /Schema /COMMON SECURITY
• common variables;format
  • DATABASE /Schema /COMMON VARS
• COMMON VARS
  • DATABASE /Schema /COMMON VARS
• COMPANY
  • GETTING STARTED /Introduction /COMPANY Database
• compare floating point
  • VISUALPQL /Functions /List of Functions from A to Z
• compilation errors
  • VISUALPQL /The VisualPQL Debuggers /14The VisualPQL Debuggers
• COMPILE
  • FORMS /Running FORMS /15Running FORMS
• COMPILE_ONLY
  • SQL /Data Entry and Modification /INSERT INTO
• COMPILE_ONLY;DELETE FROM
  • SQL /Data Entry and Modification /DELETE FROM
• COMPILE_ONLY;SELECT
  • SQL /SELECT /Keywords
• COMPUTE
  • DATABASE /Schema /COMPUTE
  • DATABASE /Data /UPDATE REC
  • VISUALPQL /Variables /COMPUTE
  • FORMS /Screens /FINAL
  • FORMS /Screens /INITIAL
  • FORMS /COMPUTE /11COMPUTE
• COMPUTE;FINAL
  • FORMS /Field /FINAL
• computed variables
  • DATABASE /Schema /COMPUTE
• concatenating strings
  • VISUALPQL PROCEDURES /Quick Report /Syntax
• concatenating strings
  • VISUALPQL /Variables /Expressions
• concurrent operation
  • FORMS /Concurrency /16Concurrency
• concurrent operation;read locks
  • FORMS /Concurrency /Locking
• concurrent programs
  • ENVIRONMENT /Concurrency / Running Master
• concurrent read lock
  • ENVIRONMENT /Concurrency / Running Master
• concurrent VisualPQL
  • VISUALPQL /Database Access /Concurrent VisualPQL
• concurrent write lock
  • ENVIRONMENT /Concurrency / Running Master
• CONDENSE
  • ENVIRONMENT /Commands /Procedure References
• CONDESCRIPTIVE
  • VISUALPQL PROCEDURES /Condescriptive /3Condescriptive
• conditional breaks
  • VISUALPQL PROCEDURES /Full Report /Conditional Break
• confidence interval
  • VISUALPQL PROCEDURES /Condescriptive /3Condescriptive
  • VISUALPQL PROCEDURES /Frequencies /8Frequencies
• Configure ODBC
  • ENVIRONMENT /ODBC /WDL
• CONNECT DATABASE
  • DATABASE /Schema /CONNECT DATABASE
• CONNECT DATABASE, PQL
  • VISUALPQL /Database Access /PQL CONNECT DATABASE
• CONNECT ODBC
  • VISUALPQL /ODBC Client /CONNECT
• CONNECT TABFILE
  • DATABASE /Tabfiles and Tables /CONNECT TABFILE
• connect tabfile
  • VISUALPQL /Accessing Tables /PQL CONNECT TABFILE
• CONNECT TO
  • VISUALPQL PROCEDURES /Full Report /CONNECT TO
• CONNECT;DATABASE
  • SQL /Control Commands /CONNECT DATABASE
• CONNECT;TABFILE
  • SQL /Control Commands /CONNECT TABFILE
• consistency checks
  • DATABASE /Introduction /Variable Quality Control
• CONSOL
  • VISUALPQL PROCEDURES /Overview /Common keywords
• constants
  • VISUALPQL /Variables /Expressions
  • SQL /Overview /Syntax Rules
• CONSTRAINTS UNIQUE
  • SQL /Tabfiles and Tables /CREATE TABLE
• continuation character
  • SQL /SET, SHOW and CLEAR /Parameter List
  • FORMS /Introduction /Form Structure
• continuation lines
  • VISUALPQL /Introduction /VisualPQL Syntax
• CONTINUE
  • SQL /SET, SHOW and CLEAR /Parameter List
• CONTINUOUS
  • VISUALPQL PROCEDURES /Frequencies /8Frequencies
• continuous variables
  • VISUALPQL PROCEDURES /Tabulate /Variable Types
• Control Commands;list
  • SQL /Control Commands /5Control Commands
• Control Flow
  • VISUALPQL /Control Flow /4Control Flow
• CONTROL modifier
  • VISUALPQL PROCEDURES /Tabulate /Variable Modifiers
• control statement file
  • VISUALPQL PROCEDURES /SAS Save File /14SAS Save File
• control variables
  • VISUALPQL PROCEDURES /Tabulate /Variable Types
• CONTROL VARS
  • DATABASE /Schema /CONTROL VARS
  • VISUALPQL /Variables /CONTROL VARS
• coordinate system
  • FORMS /General Clauses /AT
• COPY DIFFERENCE FILE
  • ENVIRONMENT /Commands /ATTRIBUTE
• correlation
  • VISUALPQL PROCEDURES /Plot /11Plot
• corruption flag
  • DATABASE /Backup /VERIFY FILE
• COS function
  • VISUALPQL /Functions /List of Functions from A to Z
  • FORMS /COMPUTE /Functions
• cosine function
  • VISUALPQL /Functions /List of Functions from A to Z
  • FORMS /COMPUTE /Functions
• COUNT
  • VISUALPQL /Database Access /Case Processing Commands
  • VISUALPQL /Database Access /PROCESS CASE
  • VISUALPQL /Accessing Tables /PROCESS ROWS
  • VISUALPQL /Functions /List of Functions from A to Z
• count
  • VISUALPQL PROCEDURES /Condescriptive /3Condescriptive
  • VISUALPQL PROCEDURES /Frequencies /8Frequencies
• COUNT
  • VISUALPQL PROCEDURES /Tabulate /Statistics
  • SQL /SELECT /Aggregation
• count
  • SQL /SELECT /GROUP BY
• COUNT function
  • SQL /SQL Functions /Aggregation functions
• COUNT function
  • FORMS /COMPUTE /Functions
• COUNT;SUBTOTAL
  • SQL /DISPLAY /SUBTOTAL
• COUNT;TOTAL
  • SQL /DISPLAY /TOTAL
• cptime
  • ENVIRONMENT /Commands /GCOMPUTE
• CR lock
  • FORMS /Concurrency /Locking
• CREATE
  • DATABASE /Schema /CONNECT DATABASE
• CREATE PATH
  • SQL /Paths and Views /CREATE PATH
• CREATE BUFFER
  • VISUALPQL /Buffers /CREATE BUFFER
• CREATE DATABASE
  • DATABASE /Schema /CREATE DATABASE
• CREATE DBINDEX
  • DATABASE /Schema /CREATE DBINDEX
• CREATE FAMILY
  • ENVIRONMENT /Commands /CONDENSE
• CREATE INDEX
  • DATABASE /Tabfiles and Tables /CREATE INDEX
  • SQL /Tabfiles and Tables /CREATE INDEX
• CREATE TABFILE
  • DATABASE /Tabfiles and Tables /CREATE TABFILE
  • SQL /Tabfiles and Tables /CREATE TABFILE
• CREATE TABFILE;FILENAME
  • DATABASE /Tabfiles and Tables /CREATE TABFILE
• CREATE TABFILE;IDENTIFIED BY
  • DATABASE /Tabfiles and Tables /CREATE TABFILE
• CREATE TABLE
  • SQL /Tabfiles and Tables /CREATE TABLE
• CREATE VIEW
  • SQL /Paths and Views /CREATE VIEW
• CREATE VIEW;AS SELECT
  • SQL /Paths and Views /CREATE VIEW
• CREATE VIEW;FROM
  • SQL /Paths and Views /CREATE VIEW
• CREATE VIEW;GROUP BY
  • SQL /Paths and Views /CREATE VIEW
• CREATE VIEW;GROUP BY HAVING
  • SQL /Paths and Views /CREATE VIEW
• CREATE VIEW;OUTER join
  • SQL /Paths and Views /CREATE VIEW
• CREATE VIEW;WHERE
  • SQL /Paths and Views /CREATE VIEW
• CREATE VIEW;WITH CHECK
  • SQL /Paths and Views /CREATE VIEW
• CREATE;ATTRIBUTE
  • SQL /Control Commands /CREATE ATTRIBUTE
• CREATE;SYNONYM
  • SQL /Control Commands /CREATE SYNONYM
• creating records
  • FORMS /Using Forms /Accessing Records and Rows
• CRWARN
  • VISUALPQL /VisualPQL Programs and Routines /RETRIEVAL, PROGRAM, SUBROUTINE
  • VISUALPQL /Variables /Implicit Variables
• CSS
  • VISUALPQL PROCEDURES /Tabulate /Statistics
• CSV
  • DATABASE /Data /SIR SPREADSHEET
• CSV SAVE FILE
  • VISUALPQL PROCEDURES /CSV Save File /4CSV Save File
• CTIME function
  • VISUALPQL /Functions /List of Functions from A to Z
  • SQL /SQL Functions /Standard Functions
  • FORMS /COMPUTE /Functions
• CURDIR function
  • VISUALPQL /Functions /List of Functions from A to Z
• Current Directory
  • VISUALPQL /Functions /List of Functions from A to Z
• CURSOR
  • VISUALPQL /Execution Window /CURSOR
• CURSOR POSITION
  • VISUALPQL /Execution Window /CURSOR POSITION
• custom field help key
  • FORMS /Using Forms /Entering Data
• CV
  • VISUALPQL PROCEDURES /Condescriptive /3Condescriptive
  • VISUALPQL PROCEDURES /Frequencies /8Frequencies
  • VISUALPQL PROCEDURES /Tabulate /Statistics
• CVERR
  • VISUALPQL PROCEDURES /Tabulate /Statistics
• CW lock
  • FORMS /Concurrency /Locking