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		C

C

• C commas
  • PQL PROCEDURES /CSV Save File /CSV Save File
  • PQL PROCEDURES /Quick Report /Syntax
• c picture
  • VISUALPQL /Reading and Writing Files /I/O List - Input Specification
• C reprinting
  • PQL PROCEDURES /Quick Report /Syntax
• CALL
  • ENVIRONMENT /Commands /INCLUDE BUFFER | FILE | MEMBER
  • FORMS /CALL /CALL
• CALL SCREEN
  • VISUALPQL /PQLForms /CALL SCREEN
• CALL;automatic
  • FORMS /CALL /CALL
• CALL;PRINTBACK
  • ENVIRONMENT /Appendix /Execution Parameters
• CALL;procedures
  • SQL /Control Commands /CALL
• CALL;user commands
  • FORMS /CALL /CALL
• 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 /Alphabetic List of All Functions
• capitalisation function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• 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
• 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
• CASEFUNR
  • VISUALPQL /Database Access /PROCESS REC
• CASEID
  • PQL PROCEDURES /SIR Save File /SIR Save File
• caseless database
  • DATABASE /Introduction /Overview
  • PQL PROCEDURES /SIR Save File /SIR 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 /Alphabetic List of All Functions
• cases;records per case
  • DATABASE /Schema /RECS PER CASE
• cases;selecting a subset
  • DATABASE /Data /SIR FILE LIST
• CASWGT
  • PQL PROCEDURES /SPSS Save File /SPSS Save File
• cat var function
  • VISUALPQL /Functions /Alphabetic List of All Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• CAT VARS
  • DATABASE /Schema /CAT VARS
  • VISUALPQL /Variables /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
  • PQL PROCEDURES /Tabulate /Variable Types
  • VISUALPQL /Variables /CAT VARS
• CATINT function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• CATSTR function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• cblevel
  • ENVIRONMENT /Commands /System Globals
• CCF
  • DATABASE /Backup /VERIFY FILE
• CDATE function
  • FORMS /COMPUTE /Functions
  • SQL /SQL Functions /Standard Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• CEILING function
  • FORMS /COMPUTE /Functions
• cell contents error
  • PQL PROCEDURES /Tabulate /Error Processing
• cells
  • PQL PROCEDURES /Tabulate /Expressions
• CENTER
  • FORMS /AT, DRAW and TEXT /DRAW
  • FORMS /AT, DRAW and TEXT /TEXT
  • PQL PROCEDURES /Quick Report /Syntax
  • PQL PROCEDURES /Quick Report /Syntax
  • SQL /DISPLAY /Headings and Footings
• CENTER function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• CENY
  • ENVIRONMENT /Commands /SETCLEAR
  • SQL /Control Commands /Environment Parameters
• CENY parameter
  • ENVIRONMENT /Appendix /Execution Parameters
  • FORMS /Running FORMS /Running FORMS
• cgi
  • ENVIRONMENT /Appendix /Running from a web server
• CGI WRITE
  • VISUALPQL /Reading and Writing Files /WRITE
• CGIBUFPN function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• CGIBUFSV function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• CGIVARPN function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• CGIVARSV function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• change CIR lock type
  • VISUALPQL /Functions /Alphabetic List of All Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• CHAR function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• CHARACTER
  • SQL /Tabfiles and Tables /Column Data types
• character variables
  • DATABASE /Introduction /Defining Variables
  • DATABASE /Schema /CHARACTER
• CHARHEX format
  • VISUALPQL /Reading and Writing Files /I/O List - Output Specification
• CHARHEX function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• 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
  • PQL PROCEDURES /Tabulate /Error Processing
• CI
  • PQL PROCEDURES /Condescriptive /Condescriptive
  • PQL PROCEDURES /Frequencies /Frequencies
• CIF command
  • ENVIRONMENT /Commands /CIF
• CIF END
  • ENVIRONMENT /Commands /CIF END
• CIF FALSE
  • ENVIRONMENT /Commands /CIF FALSE | TRUE | TF
• CIF TF
  • ENVIRONMENT /Commands /CIF FALSE | TRUE | TF
• CIF TRUE
  • ENVIRONMENT /Commands /CIF FALSE | TRUE | TF
• CIR
  • DATABASE /Introduction /Overview
  • DATABASE /Schema /SIR SCHEMA LIST
  • DATABASE /Schema /WRITE SCHEMA
  • DATABASE /Schema /COMMON VARS
• CIR/REC
  • FORMS /Using Forms /Status Area
• CIR;counts
  • DATABASE /Schema /MAX REC COUNT
• CIRDATA
  • DATABASE /Backup /VERIFY FILE
• CIRKEY
  • DATABASE /Backup /VERIFY FILE
• CIRLOCK
  • VISUALPQL /VisualPQL Programs and Routines /RETRIEVAL, PROGRAM, SUBROUTINE
• CIRLOCK function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• CLEAR
  • ENVIRONMENT /Commands /SETCLEAR
  • FORMS /CALL /CLEAR
  • SQL /SET, SHOW and CLEAR /SET, SHOW and CLEAR
  • VISUALPQL /PQLForms /FORM
  • VISUALPQL /PQLForms /SCREEN
  • VISUALPQL /PQLForms /ABUTTON
• CLEAR ALL
  • VISUALPQL /Graphical User Interface /Dialog Control Commands
• CLEAR BOOLEANS
  • DATABASE /Schema /Modifying Database Definitions
• CLEAR BUFFER
  • VISUALPQL /Buffers /CLEAR BUFFER
• clear character
  • FORMS /General Clauses /CLEAR
• CLEAR clause
  • FORMS /General Clauses /CLEAR
• CLEAR COMPUTES
  • DATABASE /Schema /Modifying Database Definitions
• CLEAR DCONTROL
  • VISUALPQL /Graphical User Interface /DEDIT
• CLEAR MASTER
  • ENVIRONMENT /Commands /SETCLEAR
• CLEAR OUTPUT
  • ENVIRONMENT /Commands /SETCLEAR
• CLEAR OUTPUT WINDOW
  • VISUALPQL /Graphical User Interface /WINDOW CLEAR
• CLEAR RECODES
  • DATABASE /Schema /Modifying Database Definitions
• CLEAR SELECT ITEM
  • VISUALPQL /Graphical User Interface /Dialog Control Commands
• CLEAR VALUE LABELS
  • DATABASE /Schema /Modifying Database Definitions
• CLEAR VAR DOC
  • DATABASE /Schema /Modifying Database Definitions
• CLEAR VAR LABEL
  • DATABASE /Schema /Modifying Database Definitions
• CLEAR;PQLForms
  • VISUALPQL /PQLForms /Using PQLForms
• Client AutoKill
  • VISUALPQL /Functions /Alphabetic List of All Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• CLIPAPP function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• CLIPGET function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• CLIPLINE function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• CLIPSET function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• CLOSE
  • VISUALPQL /Reading and Writing Files /CLOSE
• CLOSE TABLE
  • VISUALPQL /Accessing Tables /CLOSE TABLE
• CLOSETABLE
  • VISUALPQL /Accessing Tables /PROCESS ROWS
• CMP
  • FORMS /Running FORMS /Running FORMS
• CMPTRIM
  • SQL /SET, SHOW and CLEAR /Parameter List
• CMPUPPER
  • SQL /SET, SHOW and CLEAR /Parameter List
• CNT function
  • FORMS /COMPUTE /Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• CNTR function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• co-ordinates;PQLForms
  • VISUALPQL /PQLForms /PQLForms General Clauses
• coefficient of variability
  • PQL PROCEDURES /Condescriptive /Condescriptive
  • PQL PROCEDURES /Frequencies /Frequencies
• COLCOUNT function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• COLHEAD
  • PQL PROCEDURES /Quick Report /Syntax
  • SQL /SET, SHOW and CLEAR /Parameter List
• COLLABEL function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• COLLAPSE
  • PQL PROCEDURES /Tabulate /Page Formatting
• COLLEN function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• COLNAME function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• COLTYPE function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• column break
  • PQL PROCEDURES /Quick Report /Quick Report
• column data types
  • SQL /Tabfiles and Tables /Column Data types
• column formats
  • SQL /SELECT /Column Formats
• column headings
  • PQL PROCEDURES /Quick Report /Syntax
  • PQL PROCEDURES /Tabulate /Variable Modifiers
  • SQL /SET, SHOW and CLEAR /Parameter List
• column reprinting headings
  • PQL 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
  • PQL PROCEDURES /Tabulate /Expressions
• Columns;PQLForms
  • VISUALPQL /PQLForms /PQLForms General Clauses
• COLVALN function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• COLVALS function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• COMBO
  • VISUALPQL /Graphical User Interface /COMBO
• COMMA
  • FORMS /Field /DSPEDIT
  • FORMS /Field /DSPEDIT
  • PQL PROCEDURES /CSV Save File /CSV Save File
  • PQL PROCEDURES /Quick Report /Syntax
• COMMA function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• command labels
  • ENVIRONMENT /Commands /Input Flow Control
• Commands
  • ENVIRONMENT /Commands /Commands
  • ENVIRONMENT /Commands /PRINT BACK
  • ENVIRONMENT /Commands /Commands
  • FORMS /CALL /CALL
• commands;keys
  • FORMS /Using Forms /Keys and Commands
• commands;overview
  • FORMS /Introduction /Commands
  • FORMS /Using Forms /Entering Commands
• COMMANDS;PRINTBACK
  • ENVIRONMENT /Appendix /Execution Parameters
• commands;symbols
  • FORMS /Using Forms /Keys and Commands
• comment
  • ENVIRONMENT /Commands /Comments and Remarks
• comments
  • FORMS /Compiler Directives /Compiler Directives
  • FORMS /Introduction /Form Structure
• COMMON
  • DATABASE /Backup /EXPORT
  • DATABASE /Schema /WRITE SCHEMA
  • FORMS /GENERATE /Syntax
• common information record
  • DATABASE /Introduction /Overview
• COMMON SECURITY
  • DATABASE /Schema /COMMON SECURITY
• COMMON VARS
  • DATABASE /Schema /COMMON VARS
• COMPANY
  • GETTING STARTED /Introduction /COMPANY Database
• compare floating point
  • VISUALPQL /Functions /Alphabetic List of All Functions
• Comparing procfiles
  • ENVIRONMENT /Menus /Compare Procfiles
• compilation errors
  • VISUALPQL /The VisualPQL Debugger /The VisualPQL Debugger
• COMPILE
  • FORMS /Running FORMS /Running 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 /Data /UPDATE REC
  • DATABASE /Schema /COMPUTE
  • FORMS /COMPUTE /COMPUTE
  • FORMS /Screens /FINAL
  • FORMS /Screens /INITIAL
  • VISUALPQL /Variables /COMPUTE
• COMPUTE;FINAL
  • FORMS /Field /FINAL
• computed variables
  • DATABASE /Schema /COMPUTE
• concatenating strings
  • PQL PROCEDURES /Quick Report /Syntax
• concatenating strings
  • VISUALPQL /Variables /Expressions
• concurrent operation
  • FORMS /Concurrency /Concurrency
• concurrent operation;read locks
  • FORMS /Concurrency /Locking
• concurrent programs
  • ENVIRONMENT /Concurrency / Record Locking
• concurrent read lock
  • ENVIRONMENT /Concurrency / Record Locking
• concurrent VisualPQL
  • VISUALPQL /Database Access /Concurrent VisualPQL
• concurrent write lock
  • ENVIRONMENT /Concurrency / Record Locking
• CONDENSE
  • ENVIRONMENT /Commands /CONDENSE
• CONDESCRIPTIVE
  • PQL PROCEDURES /Condescriptive /Condescriptive
• conditional breaks
  • PQL PROCEDURES /Full Report /Conditional Break
• confidence interval
  • PQL PROCEDURES /Condescriptive /Condescriptive
  • PQL PROCEDURES /Frequencies /Frequencies
• Configure ODBC
  • ENVIRONMENT /ODBC /ODBC
• 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
  • VISUALPQL /Accessing Tables /PQL CONNECT TABFILE
• CONNECT TO
  • PQL 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
  • PQL PROCEDURES /Overview /Common keywords
• constants
  • SQL /Overview /Syntax Rules
  • VISUALPQL /Variables /Expressions
• CONSTRAINTS UNIQUE
  • SQL /Tabfiles and Tables /CREATE TABLE
• continuation character
  • FORMS /Introduction /Form Structure
  • SQL /SET, SHOW and CLEAR /Parameter List
• continuation lines
  • VISUALPQL /Introduction /VisualPQL Syntax
• CONTINUE
  • SQL /SET, SHOW and CLEAR /Parameter List
• CONTINUOUS
  • PQL PROCEDURES /Frequencies /Frequencies
• continuous variables
  • PQL PROCEDURES /Tabulate /Variable Types
• Control Commands;list
  • SQL /Control Commands /Control Commands
• Control Flow
  • VISUALPQL /Control Flow /Control Flow
• CONTROL modifier
  • PQL PROCEDURES /Tabulate /Variable Modifiers
• control variables
  • PQL 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 /COPY DIFFERENCE FILE
• Copy file function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• correlation
  • PQL PROCEDURES /Plot /Plot
• corruption flag
  • DATABASE /Backup /VERIFY FILE
• COS function
  • FORMS /COMPUTE /Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• cosine function
  • FORMS /COMPUTE /Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• count
  • PQL PROCEDURES /Condescriptive /Condescriptive
  • PQL PROCEDURES /Frequencies /Frequencies
  • PQL PROCEDURES /Tabulate /Statistics
  • SQL /SELECT /Aggregation
  • SQL /SELECT /GROUP BY
  • VISUALPQL /Database Access /Case Processing Commands
  • VISUALPQL /Database Access /PROCESS CASE
  • VISUALPQL /Functions /Alphabetic List of All Functions
  • VISUALPQL /Accessing Tables /PROCESS ROWS
• COUNT function
  • SQL /SQL Functions /Aggregation functions
• COUNT function
  • FORMS /COMPUTE /Functions
• count journal restore
  • DATABASE /Backup /JOURNAL RESTORE
• COUNT;SUBTOTAL
  • SQL /DISPLAY /SUBTOTAL
• COUNT;TOTAL
  • SQL /DISPLAY /TOTAL
• cptime
  • ENVIRONMENT /Commands /System Globals
• CPYFILE function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• 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 /Schema
  • DATABASE /Schema /CREATE DATABASE
• CREATE DBINDEX
  • DATABASE /Schema /CREATE DBINDEX
• CREATE FAMILY
  • ENVIRONMENT /Commands /CREATE FAMILY
• CREATE INDEX
  • DATABASE /Tabfiles and Tables /CREATE INDEX
  • SQL /Tabfiles and Tables /CREATE INDEX
• CREATE PROCFILE
  • ENVIRONMENT /Commands /CREATE PROCFILE
• Create Records
  • DATABASE /Schema /Schema
• 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
• CRYPTKEY
  • VISUALPQL /Functions /Alphabetic List of All Functions
• CSS
  • PQL PROCEDURES /Tabulate /Statistics
• CSV
  • DATABASE /Backup /EXPORT
  • DATABASE /Data /ADD REC
  • DATABASE /Data /EVICT REC
  • DATABASE /Data /READ INPUT DATA
  • DATABASE /Data /REPLACE REC
  • DATABASE /Data /UPDATE REC
  • DATABASE /Data /SIR FILE DUMP
  • DATABASE /Data /SIR SPREADSHEET
• CSV SAVE FILE
  • PQL PROCEDURES /CSV Save File /CSV Save File
• CTIME function
  • FORMS /COMPUTE /Functions
  • SQL /SQL Functions /Standard Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• CURDIR function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• CURREC function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• Current Directory
  • VISUALPQL /Functions /Alphabetic List of All Functions
• Current Record Type
  • VISUALPQL /Functions /Alphabetic List of All Functions
• custom field help key
  • FORMS /Using Forms /Entering Data
• CV
  • PQL PROCEDURES /Condescriptive /Condescriptive
  • PQL PROCEDURES /Frequencies /Frequencies
  • PQL PROCEDURES /Tabulate /Statistics
• CVERR
  • PQL PROCEDURES /Tabulate /Statistics
• CW lock
  • FORMS /Concurrency /Locking