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

SQL Engine Reference - Index

---

Symbols

@@IDENTITY global variable 1

Example of 1

@@ROWCOUNT global variable 1

Example of 1

A

ABS 1

ACOS 1

ADD

grammar supported 1

Aggregate functions

AVG 1

COUNT 1

MAX 1

MIN 1

SUM 1

DECIMAL precision and 1

ALL

grammar supported 1

ALTER TABLE

grammar supported 1

IN DICTIONARY keyword 1

USING keyword 1

WITH REPLACE keyword 1

alter-option SQL grammar element definition 1

alter-option-list SQL grammar element definition 1

ANDed predicate

maximum in SQL statement 1

ANSI

character translation 1

ANY

grammar supported 1

API functions

ODBC supported 1

Approximate-numeric-literal

grammar supported 1

Arguments

number in a parameter list for stored procedures 1, 2

Arithmetic

floating point comparison 1

AS

grammar supported 1

ASCII 1

ASIN 1

as-or-semicolon SQL grammar element definition 1

ATAN 1

ATAN2 1

ATTRIB.DDF 1

attributes ignored by Pervasive.SQL V8 1

AUTOINCREMENT data type 1

AVG aggregate function 1

B

before-or-after SQL grammar element definition 1

BEGIN

grammar supported 1

Between-predicate

grammar supported 1

BFLOAT data type 1

BINARY data type

0-padded if odd digits 1

default value not supported 1

notes about 1

SELECT and 1

Binary Large Objects 1

BIT_LENGTH 1

BLOB data type 1

default value not supported 1

Bound databases

IN DICTIONARY not permitted 1, 2

Btrieve owner names See Owner names1

C

CALL

calling a stored procedure 1

grammar supported 1

call-arguments SQL grammar element definition 1

CASCADE

grammar supported 1

ON DELETE 1

CASE

grammar supported 1

CEILING 1

Changing

System Tables 1

CHAR 1

CHAR data type

notes about 1

CHAR_LENGTH 1

Character

escape for wildcard characters 1

translation

OEM to ANSI 1

CHARACTER_LENGTH 1

CLOB data type 1

default value not supported 1

CLOSE

grammar supported 1

Closing

open tables 1

Codes

data type 1

col-constraint SQL grammar element definition 1

collation-name SQL grammar element definition 1

Column

attributes

system table (X$Attrib) 1

definitions

changing 1

creating 1

maximum

in a database 1

name length 1

number 1

number allowed in a trigger 1

number in a select list 1

number in a table 1

size of 1

system table (X$Field) 1

column-constraint SQL grammar element definition 1

column-definition SQL grammar element definition 1

column-name SQL grammar element definition 1

Columns

number allowed in a trigger 1

Comma

as decimal separator

data display 1

data entry 1

COMMIT

grammar supported 1

commit-statement SQL grammar element definition 1

comparison-operator SQL grammar element definition 1

Compressing data files

with SQL 1

CONCAT 1

Concurrency 1

Connection

maximum number of connections 1

Connection strings

DSN 1

TRANSLATIONDLL 1

Constant values, expressing

date 1

string 1

time 1

timestamp 1

constraint-name SQL grammar element definition 1

CONVERT 1

Converting

data to other types 1

Correlated subquery 1, 2

Correlation-name

grammar supported 1

correlation-name SQL grammar element definition 1

COS 1

COT 1

COUNT aggregate function 1

COUNT( ), COUNT(*) functions

differences 1, 2

CREATE GROUP

grammar supported 1

CREATE INDEX

grammar supported 1

limitations 1

CREATE PROCEDURE

grammar supported 1

CREATE TABLE

file compression 1

grammar supported 1

IN DICTIONARY keyword 1

page size 1

USING keyword 1

WITH REPLACE keyword 1

CREATE TRIGGER

grammar supported 1

CREATE VIEW

grammar supported 1

Creating

groups 1

stored procedures 1

tables with legacy null support 1

users and groups 1

views 1

CURDATE 1

CURRENCY data type 1

Current Date

adding to an INSERT statement 1, 2

Current Time

adding to an INSERT statement 1, 2

CURRENT_DATE 1

CURRENT_TIME 1

CURRENT_TIME() 1

CURRENT_TIMESTAMP 1

Cursor

how to loop through 1

limits 1

type changed by TOP 1

cursor-name SQL grammar element definition 1

CURTIME 1

CURTIME() 1

D

Data

long, inserting or updating 1

Data control statements 1

Data definition statements 1

Data dictionaries

list of system tables 1

Data files

binary compatible cross-platform 1, 2

replacing existing 1, 2

system table (X$File) 1

Data manipulation

statements 1

Data Source Names

connection string keywords 1

clients 1

engine 1

Data types

AUTOINCREMENT 1

BFLOAT 1

BLOB 1

CLOB 1

codes 1

conversion 1

converting to other types 1

CURRENCY 1

DATE 1

DECIMAL 1

extended 1

FLOAT 1

INTEGER 1

lengths and ranges 1

limitations in stored procedures 1

limitations in triggers 1

LOGICAL 1

LSTRING 1

MONEY 1

NUMERIC 1

NUMERICSA 1

NUMERICSTS 1

REAL 1

STRING 1

supported 1

that cannot be indexed 1

TIME 1

TIMESTAMP 1

UNSIGNED BINARY 1

WSTRING 1

WZSTRING 1

ZSTRING 1

DATABASE 1

Database

maximum

number of columns 1

name

valid characters 1

Databases

joining multiple 1

data-type SQL grammar element definition 1

data-type-name SQL grammar element definition 1

Date

adding in INSERT statements 1

format supported 1, 2

functions supported 1

inserting current 1, 2

inserting or updating column values 1, 2

literal format 1, 2

literal values 1

TIMESTAMP data type

why not to use 1

Date arithmetic

grammar supported 1, 2

DATE data type 1

Date-literal

grammar supported 1

Daylight savings, see Time1

DAYNAME 1

DAYOFMONTH 1

DAYOFYEAR 1

db-name SQL grammar element definition 1

DBQ

entry in odbc.ini

length of 1

DCOMPRESS 1

DDFs

changing data definitions without affecting data files 1

DECIMAL data type 1

precision of SUM() function result 1

Decimal separator

comma

display only 1

comma as 1, 2

DECLARE

grammar supported 1

DECLARE CURSOR

grammar supported 1

DEFAULT 1

example of use in CREATE TABLE 1

in CREATE TABLE 1

in UPDATE 1, 2

Default values, see Values, default1

default-value SQL grammar element definition 1

Definitions

index

Btrieve indexes and 1, 2, 3

DEGREES 1

DELETE

grammar supported 1, 2

Delete

rule 1

cascade 1

restrict 1

Deleting

view 1

Delimited identifier

in SQL Statements 1

Delimiter

SQL statement in PCC 1

DEPEND.DDF 1

Disabling security 1

Disjointed index, definition of 1

DISTINCT 1

grammar supported 1

in subquery 1

Double quote

matching data that contains a 1

DROP INDEX

grammar supported 1

DROP PROCEDURE

grammar supported 1

DROP TABLE

grammar supported 1

IN DICTIONARY keyword 1

DROP TRIGGER

grammar supported 1

DROP VIEW

grammar supported 1

DSN

connection strings 1

Dynamic cursors

SET ROWCOUNT and 1

type changed by TOP 1

E

Enabling

security 1

END

grammar supported 1

Escape character 1

Exact-numeric-literal

grammar supported 1

EXISTS

grammar supported 1

EXP 1

Expression

in stored procedures 1

subquery on left side of 1

expression SQL grammar element definition 1

expression-or-subquery SQL grammar element definition 1

Extended data types 1

EXTRACT 1

F

FETCH

grammar supported 1

fetch-orientation SQL grammar element definition 1

FIELD.DDF 1

Field.ddf 1

File

compression, specifying with SQL 1

File.ddf

FILE.DDF 1

Files

location of temporary 1

FLOAT data type 1

comparing values 1

FLOOR 1

FOREIGN KEY

cannot ALTER column 1

grammar supported 1

Format

literal values

date 1

string 1

time 1

timestamp 1

Formats, literal

date 1, 2

string 1

time 1, 2

timestamp 1, 2

Functions

aggregate

AVG 1

COUNT 1

MAX 1

MIN 1

SUM 1, 2

categories

logical 1

conversion 1

date 1

inserting value 1

numeric 1

string 1

system 1

time

inserting current 1

inserting value 1

G

Global variables 1

@@IDENTITY 1

@@ROWCOUNT 1

Grammar Element Definitions 1

GRANT

grammar supported 1

Granting

rights 1

Greater than (>) operator 1

Group

creating a 1

GROUP BY

grammar supported 1

with a HAVING clause 1

Grouped views 1

group-name SQL grammar element definition 1

H

HAVING

in a GROUP BY expression 1

HOUR 1

How

to loop through a cursor 1

I

IDENTITY global variable. See @@IDENTITY1

IF 1

grammar supported 1

nesting limit 1

IF (with SELECT)

grammar supported 1

IFNULL 1

IN

grammar supported 1

IN DICTIONARY keyword 1, 2, 3, 4

not permitted on bound databases 1, 2

Index

creating 1

data types that cannot be indexed 1

definitions, SQL

Btrieve indexes and 1, 2, 3

disjointed, definition of 1

dropping named 1

maximum indexed nullable columns 1

name

maximum length of 1

optimizations 1

Index.ddf 1

INDEX.DDF 1

index-definition SQL grammar element definition 1

Indexes

existing Btrieve and relational definitions 1, 2, 3

existing used when possible 1, 2, 3

system tables

X$Field 1

X$Index 1

index-name SQL grammar element definition 1

index-segment-definition SQL grammar element definition 1

Infinity

representation 1

In-predicate

grammar supported 1

INSERT

default values and 1

grammar supported 1

Inserting

current time, current date and timestamp 1, 2, 3

insert-values SQL grammar element definition 1

ins-upd-del SQL grammar element definition 1

INTEGER data type 1

Invalid row-count in subquery

returned if SELECT within UPDATE returns multiple rows 1

J

JOIN

grammar supported 1

Join

Cartesian 1

cross-database 1

LEFT OUTER 1

maximum tables in a 1

multi-database 1

RIGHT OUTER 1

TOP clause in a 1

two-way LEFT OUTER JOIN 1

join-definition SQL grammar element definition 1

L

label-name SQL grammar element definition 1

LCASE 1

LEAVE

grammar supported 1

LEFT 1

LEFT OUTER JOIN

and vendor strings 1

syntax 1

LENGTH 1

Length

maximum for column name 1

of path name in USING 1, 2

Less than (<) operator 1

LIKE

syntax and usage 1

LIKE predicates

on LONGVARBINARY 1

on LONGVARCHAR 1

Limitations

columns, number of 1

of LONGVARBINARY 1

of LONGVARBINARY in INSERT statements 1

of LONGVARCHAR 1

of LONGVARCHAR in INSERT statements 1

of LONGVARCHAR in UNION statements 1

Limits

cursors 1

maximum ANDed predicates in SQL statement 1

maximum size of quoted string in SQL statement 1

of Pervasive ODBC Engine interface 1

SQL variables and parameters 1

stored procedures 1

arguments in a parameter list 1, 2

procedure name 1

size 1, 2

variable name 1

triggers

number of columns 1, 2

when using long data 1

literal SQL grammar element definition 1

Literal values

date 1

string 1

entering data longer than max 1

time 1

timestamp 1

Locale

setting time zone 1

Locale-specific behavior

comma as decimal separator

data display 1

data entry 1

LOCATE 1

Locking

table 1

LOG 1

LOG10 1

LOGICAL data type 1

Logical functions supported 1

Long data

inserting or updating 1

limits when using 1

LONGVARBINARY

limitation 1

limitations in INSERT statements 1

notes about 1

using SQLGetData 1

LONGVARCHAR

limitations 1

limitations in INSERT statements 1

limitations in UNION statements 1

notes about 1

using SQLGetData 1

LOOP

grammar supported 1

LSTRING data type 1

LTRIM 1

M

Master user 1

MAX aggregate function 1

Maximum

column name length 1

length of view name 1

MIN aggregate function 1

MINUTE 1

MOD 1

Modifying

data

statements for 1

MONEY data type 1

MONTH 1

MONTHNAME 1

N

Named databases

and file names 1, 2

Names

maximum length 1

Nesting limits

IF 1

Non-correlated subquery 1

NOT

grammar supported 1

NOT NULL

default values and 1

NOW 1

NULL 1

attempted insert into NOT NULL column with default value 1

cannot make column nullable 1

inserted by UPDATE if subquery returns no rows 1

Null

support

creating tables with legacy 1

setting for table creation 1

Nullable columns

default value for 1

maximum number of indexed 1

NULLIF 1

NUMERIC data type 1

Numeric functions supported 1

NUMERICSA data type 1

NUMERICSTS data type 1

O

OCTET_LENGTH 1

ODBC

API

conformance 1

exceptions to conformance 1

security 1

ODBC API

functions

supported 1

Odbc.ini

DBQ entry length 1

OEM to ANSI

character translation 1

connection string 1

ON DELETE 1

ON UPDATE 1

ONLY

grammar supported 1

Operators

greater than 1

less than 1

Optimizations

index usage 1

restriction 1

SQL Relational Database Engine 1

subquery on left side of expression 1

ORDER BY

SET ROWCOUNT and 1

TOP and 1

order-by-expression SQL grammar element definition 1

outer-join-definition SQL grammar element definition 1

outer-join-type SQL grammar element definition 1

Owner names 1

in secured databases 1

specifying in SQL 1

P

Padding

in BINARY columns 1

in CHAR columns 1

in LONGVARBINARY columns 1

in LONGVARCHAR columns 1

in VARCHAR columns 1

Page

sizes

specifying with SQL 1

PAGESIZE 1

Parameter List

number of arguments for stored procedures 1, 2

parameter SQL grammar element definition 1

parameter-name SQL grammar element definition 1

parameter-type SQL grammar element definition 1

parameter-type-name SQL grammar element definition 1

Password

for Master user 1

table 1

password SQL grammar element definition 1

Path name

length in USING 1, 2

Pattern matching

with LIKE 1

Performance

SQL Relational Database Engine 1

temporary tables 1

Permissions. See Rights1

Pervasive Control Center

OEM characters and 1

Pervasive ODBC Engine interface

data types supported 1

limits of 1

SQL conformance 1

Pervasive.SQL 7

status code 59 1

PI 1

POSITION 1

positional-argument SQL grammar element definition 1

POWER 1

Precedence

TOP vs. SET ROWCOUNT 1, 2

Precision

SUM result on DECIMAL data 1

precision SQL grammar element definition 1

Predicate

in stored procedures 1

predicate SQL grammar element definition 1

PRIMARY KEY

cannot ALTER column 1

grammar supported 1

PRINT

grammar supported 1

PROC.DDF 1

procedure-name SQL grammar element definition 1

Procedures

creating 1

proc-expr SQL grammar element definition 1

proc-search-condition SQL grammar element definition 1

proc-stmt SQL grammar element definition 1

PUBLIC

grammar supported 1

public-or-user-group-name SQL grammar element definition 1

Q

QUARTER 1

Query

setting timeout via ODBC 1, 2

query-specification SQL grammar element definition 1

Quotation mark, representing single 1

Quoted string in SQL statement

maximum size 1

Quotes

matching data that contains 1

R

RADIANS 1

RAND 1

Ranges

data types 1

REAL data type 1

Real Infinity

representation 1

referencing-alias SQL grammar element definition 1

Referential integrity

delete rules 1

update rules 1

X$Relate system table 1

referential-actions SQL grammar element definition 1

referential-delete-action SQL grammar element definition 1

referential-update-action SQL grammar element definition 1

Regional settings

comma as decimal separator

data display 1

data entry 1

RELATE.DDF 1

Relational index definitions

Btrieve indexes and 1, 2, 3

Relational security 1

RELEASE SAVEPOINT

grammar supported 1

release-statement SQL grammar element definition 1

REPLACE 1

Replacing data files 1, 2

REPLICATE 1

Replication

SET TIME ZONE and 1

Reserved words 1

~See also Words to avoid1

ABORT 1

ABSOLUTE 1

ACCELERATED 1

ACTION 1

ADD 1

AFTER 1

ALL 1

ALTER 1

AND 1

ANY 1

AS 1

ASC 1

ATOMIC 1

AUTHORIZATION 1

AVG 1

BEFORE 1

BEGIN/BEGINS 1

BETWEEN 1

BINARYNULL 1

BIND 1

BLANK 1

BY 1

CALL 1

CASCADE 1

CASE 1

CHAIN 1

CHARACTER 1

CHECK 1

CLOSE 1

COBOL 1

COLLATE 1

COLUMN 1

COMMIT 1

COMMITTED 1

CONDITION 1

CONSTRAINT 1

CONTINUE 1

CONVERT 1

COUNT 1

CREATE 1

CREATETAB 1

CROSS 1

CS 1

CURDATE 1

CURRENT 1

CURSOR 1

CURTIME 1

D 1

DATABASE 1

DCOMPRESS 1

DECIMALSEPARATORCOMMA 1

DECLARE 1

DEFAULT 1

DELETE 1

DESC 1

DIAGNOSTICS 1

DICTIONARY 1

DISTINCT 1

DO 1

DROP 1

EACH 1

ELSE 1

ELSEIF 1

END 1

ESCAPE 1

EX 1

EXCLUSIVE 1

EXEC 1

EXECUTE 1

EXISTS 1

EXTERNAL 1

FETCH 1

FIRST 1

FN 1

FOR 1

FOREIGN 1

FROM 1

FULL 1

GRANT 1

GROUP 1

HANDLER 1

HAVING 1

HOUR 1

IDENTITY 1

IF 1

IN 1

INCLUDE 1

INDEX 1

INNER 1

INOUT 1

INSERT 1

INTERNAL 1

INTO 1

IS 1

ISOLATION 1

JOIN 1

KEY 1

LANGUAGE 1

LAST 1

LEAVE 1

LEFT 1

LEGACYOWNERNAME 1

LENGTH 1

LEVEL 1

LIKE 1

LOGICAL 1

LOGIN 1

LOOP 1

LOWER 1

MAX 1

MILLISECOND 1

MIN 1

MINUTE 1

MODIFIABLE 1

MODIFY 1

MODULE 1

MONEY 1

MONTH 1

NEW 1

NEXT 1

NO 1

NORMAL 1

NOT 1

NOTFOUND 1

NOW 1

NULL 1

OF 1

OFF 1

OLD 1

ON 1

ONLY 1

OPEN 1

OPENMODE 1

OPTION 1

OR 1

ORDER 1

OUT 1

OUTER 1

OWNER 1

OWNERACCESS 1

PAGESIZE 1

PREALLOCATE 1

PREPARE 1

PRIMARY 1

PRINT 1

PRIOR 1

PRIVILEGES 1

PROCEDURE 1

PUBLIC 1

RANGE 1

READ 1

READONLY 1

REFERENCES 1

REFERENCING 1

RELATIVE 1

RELEASE 1

REPEAT 1

REPEATABLE 1

REPLACE 1

REPLICATION 1

RESIGNAL 1

RESTRICT 1

RETURN 1

RETURNS 1

REVOKE 1

RIGHT 1

ROLLBACK 1

ROW 1

ROWCOUNT 1

SAVEPOINT 1

SCHEMA 1

SCROLL 1

SECURITY 1

SEG 1

SELECT 1

SERIALIZABLE 1

SET 1

SIGNAL 1

SIZE 1

SOME 1

SQLERROR 1

SQLEXCEPTIONS 1

SQLSTATE 1

SQLWARNINGS 1

SSP_EXPR 1

SSP_PRED 1

START 1

STATEMENT 1

STRINGNULL 1

SUM 1

SVBEGIN 1

SVEND 1

T 1

TABLE 1

THEN 1

THRESHOLD 1

TO 1

TOP 1

TRANSACTION 1

TRIGGER 1

TRIGGERSTAMPMISC 1

TRUENULLCREATE 1

TS 1

TYPE 1

UNCOMMITTED 1

UNDO 1

UNION 1

UNIQUE 1

UNTIL 1

UPDATABLE 1

UPDATE 1

UPPER 1

USER 1

USING 1

VALUE, VALUES 1

VERIFY 1

VIEW 1

WHEN 1

WHERE 1

WHILE 1

WITH 1

WORK 1

WRITE 1

YEAR 1

ZSTRING 1

RESTRICT

grammar supported 1

ON DELETE 1

result SQL grammar element definition 1

Results

returning partial set 1, 2

Retrieving data

about 1

RETURNS

example of in CREATE PROCEDURE 1

REVOKE

grammar supported 1

Revoking rights 1

RI. See Referential integrity1

RIGHT 1

Rights

granting 1

revoking 1

RIGHTS.DDF 1

ROLLBACK WORK

grammar supported 1

rollback-statement SQL grammar element definition 1

ROUND 1

ROWCOUNT (SET) 1

ROWCOUNT global variable. See @@ROWCOUNT1

Rows

limiting number returned 1, 2

limits 1

Rowset size

specifying 1

RTRIM 1

S

SAVEPOINT

grammar supported 1

savepoint-name SQL grammar element definition 1

Scalar functions 1

ABS 1

ACOS 1

ASCII 1

ASIN 1

ATAN 1

ATAN2 1

BIT_LENGTH 1

categories

conversion 1

date 1

numeric 1

string 1

system 1

time 1

CEILING 1

CHAR 1

CHAR_LENGTH 1

CHARACTER_LENGTH 1

CONCAT 1

CONVERT 1

COS 1

COT 1

CURDATE 1

CURRENT_DATE 1

CURRENT_TIME 1

CURRENT_TIMESTAMP 1

CURTIME 1

DATABASE 1

DAYNAME 1

DAYOFMONTH 1

DAYOFYEAR 1

DEGREES 1

EXP 1

EXTRACT 1

FLOOR 1

HOUR 1

IF 1

IFNULL 1

ignore fractional seconds in TIMESTAMP 1

LCASE or LOWER 1

LEFT 1

LENGTH 1

LOCATE 1

LOG 1

LOG10 1

LTRIM 1

MINUTE 1

MOD 1

MONTH 1

MONTHNAME 1

NOW 1

NULL 1

NULLIF 1

OCTET_LENGTH 1

PI 1

POSITION 1

POWER 1

QUARTER 1

RADIANS 1

RAND 1

REPLACE 1

REPLICATE 1

RIGHT 1

ROUND 1

RTRIM 1

SECOND 1

SIGN 1

SIN 1

SPACE 1

SQRT 1

STUFF 1

SUBSTRING 1

TAN 1

TIMESTAMPADD 1

TIMESTAMPDIFF 1

TRUNCATE 1

UCASE or UPPER 1

USER 1

WEEK 1

YEAR 1

scalar-function SQL grammar element definition 1

scale SQL grammar element definition 1

search-condition SQL grammar element definition 1

SECOND 1

Secured databases

with Btrieve Owner Names 1

Security

enabling and disabling 1

owner names 1, 2

password of Master user 1

relational 1

SET OWNER 1

setting 1

system tables

rights (X$Rights) 1

users (X$User) 1

SELECT

grammar supported 1

maximum number of columns 1

TOP clause 1

SELECT (with INTO)

grammar supported 1

select-item SQL grammar element definition 1

select-list SQL grammar element definition 1

Separator

comma as decimal

data display 1

data entry 1

SET DECIMALSEPARATORCOMMA 1

Set Function

grammar supported in SELECT statements 1

SET OWNER 1

SET PASSWORD

grammar supported 1

SET ROWCOUNT 1

SET SECURITY

grammar supported 1

SET TIME ZONE 1

SET TRUENULLCREATE

grammar supported 1

SET VARIABLE

grammar supported 1

set-function SQL grammar element definition 1

SIGN 1

SIGNAL

grammar supported 1

SIN 1

Single quote

matching data that contains a 1

Single quote, representing 1

Size

of data page, specifying 1

Sort order in keys

string 1

SPACE 1

Spacing

in BINARY columns 1

in CHAR columns 1

in LONGVARBINARY columns 1

in LONGVARCHAR columns 1

in VARCHAR columns 1

Special characters 1

SQL

description and purpose 1

extensions to standards 1

list of statements 1

maximum length of statement 1

maximum size of quoted string in statement 1

reserved words 1

security 1

statement delimiter

changing in PCC 1

statements

data control 1

data definition 1

data manipulation 1

delimited identifiers 1

types of 1

system tables. See System tables1

variables

limits 1

parameters 1

SQL Data Manager

OEM characters and 1

SQL grammar element definition

alter-option 1

alter-option-list 1

as-or-semicolon 1

before-or-after 1

call-arguments 1

col-constraint 1

collation-name 1

column-constraint 1

column-definition 1

column-name 1

commit-statement 1

comparison-operator 1

constraint-name 1

correlation-name 1

cursor-name 1

data-type 1

data-type-name 1

db-name 1

default-value 1

expression 1

expression-or-subquery 1

fetch-orientation 1

group-name 1

index-definition 1

index-name 1

index-segment-definition 1

insert-values 1

ins-upd-del 1

join-definition 1

label-name 1

literal 1

order-by-expression 1

outer-join-definition 1

outer-join-type 1

parameter 1

parameter-name 1

parameter-type 1

parameter-type-name 1

password 1

positional-argument 1

precision 1

predicate 1

procedure-name 1

proc-expr 1

proc-search-condition 1

proc-stmt 1

public-or-user-group-name 1

query-specification 1

referencing-alias 1

referential-actions 1

referential-delete-action 1

referential-update-action 1

release-statement 1

result 1

rollback-statement 1

savepoint-name 1

scalar-function 1

scale 1

search-condition 1

select-item 1

select-list 1

set-function 1

sqlstate-value 1

table-constraint 1

table-constraint-definition 1

table-element 1

table-expression 1

table-name 1

table-privilege 1

table-reference 1

transaction-statement 1

trigger-name 1

user-group-name 1

user-name 1

user-password 1

value 1

value-list 1

values-clause 1

variable-name 1

view-name 1

SQL Grammar Elements 1

SQL Relational Database Engine

optimizations 1

performance 1

restriction optimization 1

temporary files, location 1

SQL_QUERY_TIMEOUT

SQLSetConnectOption 1

SQLSetStmtOption 1

SQLAllocConnect 1

SQLAllocEnv 1

SQLAllocStmt 1

SQLBindCol 1

SQLBindParameter 1

SQLBrowseConnect 1

SQLCancel 1

SQLColAttributes 1

SQLColumnPrivileges 1

SQLColumns 1

SQLConnect 1

SQLDataSources 1

SQLDescribeCol 1

SQLDescribeParam 1

SQLDisconnect 1

SQLDriverConnect 1

SQLDrivers 1

SQLError 1

SQLExecDirect 1

SQLExecute 1

SQLExtendedFetch 1

SQLFetch 1

SQLForeignKeys 1

SQLFreeConnect 1

SQLFreeEnv 1

SQLFreeStmt 1, 2

SQLGetConnectOption 1, 2

SQLGetCursorName 1

SQLGetData 1

with LONGVARBINARY 1

with LONGVARCHAR 1

SQLGetFunctions 1

SQLGetInfo 1, 2

SQLGetStmtOption 1, 2

SQLGetTypeInfo 1, 2

SQLMoreResults 1, 2

SQLNativeSql 1

SQLNumParams 1

SQLNumResultCols 1

SQLParamData 1

SQLPrepare 1

SQLPrimaryKeys 1

SQLProcedureColumns 1

SQLProcedures 1

SQLPutData 1

SQLRowCount 1

SQLSetConnectOption 1, 2

SQLSetCursorName 1

SQLSetPos 1

SQLSetStmtOption 1, 2

SQLSpecialColumns 1, 2

SQLSTATE

grammar supported 1

sqlstate-value SQL grammar element definition 1

SQLStatistics 1

SQLTablePrivileges 1

SQLTables 1

SQLTransact 1

SQRT 1

START TRANSACTION

grammar supported 1

Statement delimiter, changing 1

Statements

maximum per connection 1

Static cursor

type changed by TOP 1

Status Codes

59 1

Stored procedures

calling 1

creating 1

data type limitations 1

dropping 1, 2

executing 1

expressions 1

limits 1

max. number of columns 1, 2

number of arguments in a parameter list 1, 2

total size 1, 2

predicates 1

system table (X$Proc) 1

use of variables as select items 1

using 1

String

functions supported 1

literal values 1

Maximum size of quoted string in SQL statement 1

STRING data type 1

Structured Query Language. See SQL1

STUFF 1

Subquery

correlated 1, 2

eliminating duplicate rows with DISTINCT 1

grammar supported 1

improved performance of 1

non-correlated 1

SUBSTRING 1

SUM aggregate function 1

and precision of DECIMAL type 1

Supported data types 1

Supported ODBC APIs

in Pervasive.SQL 2000 1

System

clock 1

locale setting 1

SQL functions supported 1

time 1

System tables 1

updating 1

X$Attrib 1

X$Depend 1

X$Field 1

X$File 1

X$Index 1

X$Proc 1

X$Relate 1

X$Rights 1

X$Trigger 1

X$User 1

X$View 1

T

Table

closing in an SQL statement 1

creating 1

creating with legacy null support 1

deleting 1

locking 1

maximum number of columns 1

maximum number of rows 1

modifying 1

password 1

system tables 1

updating system tables 1

Table name

maximum length 1

table-constraint SQL grammar element definition 1

table-constraint-definition SQL grammar element definition 1

table-element SQL grammar element definition 1

table-expression SQL grammar element definition 1

table-name SQL grammar element definition 1

table-privilege SQL grammar element definition 1

table-reference SQL grammar element definition 1

TAN 1

TEMP environment variable

SQL Relational Database Engine

temporary files and 1

Temporary files

SQL Relational Database Engine

location of 1

Temporary tables

performance 1

Time

adding in INSERT statements 1, 2

format supported 1, 2

functions supported 1

inserting current 1, 2

inserting or updating column values 1, 2

literal format 1, 2

literal values 1

local vs UTC 1

TIMESTAMP type, why not to use 1

TIME data type 1

Time zone

setting 1

Time-literal

grammar supported 1, 2

Timeout

query, setting via ODBC 1, 2

Timestamp

adding to an INSERT statement 1, 2

format supported 1, 2

inserting current 1

inserting or updating column values 1, 2

literal format 1, 2

literal values 1

TIMESTAMP data type 1

inappropriate for many purposes 1

interpretation of literal values 1

TIMESTAMPADD 1

TIMESTAMPDIFF 1

Timestamp-literal

grammar supported 1, 2

TMP environment variable

SQL Relational Database Engine

temporary files and 1

TOP

with SELECT 1

Transactions

defining 1

transaction-statement SQL grammar element definition 1

TRANSLATIONDLL connection string 1

TRIGGER.DDF 1

trigger-name SQL grammar element definition 1

Triggers

calling 1

creating 1

data type limitations 1

dependencies

system table (X$Depend) 1

dropping 1

executing 1

number of columns allowed 1, 2

system table (X$Trigger) 1

TRUENULLCREATE 1

TRUNCATE 1

Type conversion 1

U

UCASE 1

Unicode data types 1

Unicode key types 1

UNION

grammar supported 1

limitations 1

UNIQUE

grammar supported 1

Universal Time See Time1

UNSIGNED BINARY data type 1

UPDATE

fails if subquery returns multiple rows 1

grammar supported 1

Update

rule 1

UPDATE (positioned)

grammar supported 1

Updating

system tables 1

UPPER 1

USER 1

grammar supported 1

User

Master 1

User name

maximum length 1

USER.DDF 1

user-group-name SQL grammar element definition 1

user-name SQL grammar element definition 1

user-password SQL grammar element definition 1

Users and user groups. See Security1

USING keyword 1, 2

length of path name 1, 2

UTC Time See Time1

V

Valid Value Range

data types 1

Value

default 1

value SQL grammar element definition 1

value-list SQL grammar element definition 1

Values

default

not supported for BLOB, CLOB, or BINARY 1

values-clause SQL grammar element definition 1

VARCHAR data type

notes about 1

Variable

for adding current date 1

for adding current time 1

for adding timestamp 1

variable-name SQL grammar element definition 1

Variables

Global. See Global variables1

use as select item in stored procedure 1

Vendor Strings

embedded 1

in LEFT OUTER JOIN statements 1

View

TOP clause in a 1

VIEW.DDF 1

view-name SQL grammar element definition 1

Views

creating 1

database 1

deleting 1

grouped 1

system table (X$View) 1

W

W32BTXLT 1

WEEK 1

WHERE

clause 1

WHILE

grammar supported 1

Wildcard characters

any number of characters 1

escape character 1

single character 1

WITH REPLACE keyword 1, 2

Words to avoid 1

ABSOLUTE 1

ACTION 1

ADD 1

ALL 1

ALLOCATE 1

ALTER 1

AND 1

ANY 1

ARE 1

AS 1

ASC 1

ASSERTION 1

AT 1

AUTHORIZATION 1

AVG 1

BEGIN 1

BETWEEN 1

BIT 1

BIT_LENGTH 1

BOTH 1

BY 1

CASCADE 1

CASCADED 1

CASE 1

CAST 1

CATALOG 1

CHAR 1

CHAR_LENGTH 1

CHARACTER 1

CHARACTER_LENGTH 1

CHECK 1

CLOSE 1

COALESCE 1

COLLATE 1

COLLATION 1

COLUMN 1

COMMIT 1

CONNECT 1

CONNECTION 1

CONSTRAINT 1

CONSTRAINTS 1

CONTINUE 1

CONVERT 1

CORRESPONDING 1

COUNT 1

CREATE 1

CROSS 1

CURRENT 1

CURRENT_DATE 1

CURRENT_TIME 1

CURRENT_TIMESTAMP 1

CURRENT_USER 1

CURSOR 1

DATE 1

DAY 1

DEALLOCATE 1

DEC 1

DECIMAL 1

DECLARE 1

DEFAULT 1

DEFERRABLE 1

DEFERRED 1

DELETE 1

DESC 1

DESCRIBE 1

DESCRIPTOR 1

DIAGNOSTICS 1

DISCONNECT 1

DISTINCT 1

DOMAIN 1

DOUBLE 1

DROP 1

ELSE 1

END 1

END-EXEC 1

ESCAPE 1

EXCEPT 1

EXCEPTION 1

EXEC 1

EXECUTE 1

EXISTS 1

EXTERNAL 1

EXTRACT 1

FALSE 1

FETCH 1

FIRST 1

FLOAT 1

FOR 1

FOREIGN 1

FOUND 1

FROM 1

FULL 1

GET 1

GLOBAL 1

GO 1

GOTO 1

GRANT 1

GROUP 1

HAVING 1

HOUR 1

IDENTITY 1

IMMEDIATE 1

IN 1

INDICATOR 1

INITIALLY 1

INNER 1

INPUT 1

INSENSITIVE 1

INSERT 1

INT 1

INTEGER 1

INTERSECT 1

INTERVAL 1

INTO 1

IS 1

ISOLATION 1

JOIN 1

KEY 1

LANGUAGE 1

LAST 1

LEADING 1

LEFT 1

LEVEL 1

LIKE 1

LOCAL 1

LOWER 1

MASK 1

MATCH 1

MAX 1

MIN 1

MINUTE 1

MODULE 1

MONTH 1

NAMES 1

NATIONAL 1

NATURAL 1

NCHAR 1

NEXT 1

NO 1

NOT 1

NULL 1

NULLIF 1

NUMERIC 1

OCTET_LENGTH 1

OF 1

ON 1

ONLY 1

OPEN 1

OPTION 1

OR 1

ORDER 1

OUTER 1

OUTPUT 1

OVERLAPS 1

PAD 1

PARTIAL 1

POSITION 1

PRECISION 1

PREPARE 1

PRESERVE 1

PRIMARY 1

PRIOR 1

PRIVILEGES 1

PROCEDURE 1

PUBLIC 1

READ 1

REAL 1

REFERENCES 1

RELATIVE 1

RESTRICT 1

REVOKE 1

RIGHT 1

ROLLBACK 1

ROWS 1

SCHEMA 1

SCROLL 1

SECOND 1

SECTION 1

SELECT 1

SESSION 1

SESSION_USER 1

SET 1

SIZE 1

SMALLINT 1

SOME 1

SPACE 1

SQL 1

SQLCODE 1

SQLERROR 1

SQLSTATE 1

SUBSTRING 1

SUM 1

SYSTEM_USER 1

TABLE 1

TEMPORARY 1

THEN 1

TIME 1

TIMESTAMP 1

TIMEZONE_HOUR 1

TIMEZONE_MINUTE 1

TO 1

TRAILING 1

TRANSACTION 1

TRANSLATE 1

TRANSLATION 1

TRIM 1

TRUE 1

UNION 1

UNIQUE 1

UNKNOWN 1

UPDATE 1

UPPER 1

USAGE 1

USER 1

USING 1

VALUE 1

VALUES 1

VARCHAR 1

VARYING 1

VIEW 1

WHEN 1

WHENEVER 1

WHERE 1

WITH 1

WORK 1

WRITE 1

YEAR 1

ZONE 1

Words, reserved 1

WSTRING data type (Unicode) 1

WZSTRING data type (Unicode) 1

X

X$Attrib 1

X$Attrib system table 1

X$Depend 1

X$Depend system table 1

X$Field 1

X$Field system table 1

X$File 1

X$File system table 1

X$Index 1

X$Index system table 1, 2

X$Proc 1

X$Proc system table 1

X$Relate 1

X$Relate system table 1

X$Rights 1

X$Rights system table 1

X$Trigger 1

X$Trigger system table 1

X$User 1

X$User system table 1

X$View 1

X$View system table 1

Y

YEAR 1

Z

Zone

setting time 1

ZSTRING data type 1

Pervasive Software, Inc. http://www.pervasive.com Voice: (512) 231-6000 Fax: (512) 231-6597 Pervasive Sales Support Documentation Feedback Contact Technical Support Pervasive DevTalk Forums Pervasive DeveloperZone