Library > Products > Pervasive PSQL > Pervasive PSQL v9 SP2 (9.5) > SQL Engine Reference > SQL Access for COBOL Applications > Example of How to Execute a Sample XML File

Previous

SQL Engine Reference (v9 SP2 (9.5) revision 1)

SQL Engine Reference - Index

A - B - C - D - E - F - G - H - I - J - L - M - N - O - P - Q - R - S - T - U - V - W - X - Y - Z - Symbols

grammar supported

Aggregate functions

DECIMAL precision and

grammar supported

grammar supported

IN DICTIONARY keyword

WITH REPLACE keyword

alter-option (grammar element defined)

alter-option SQL grammar element definition

alter-option-list (grammar element defined)

alter-option-list SQL grammar element definition

AND bitwise operator

ANDed predicate

maximum in SQL statement

character translation

grammar supported

Approximate-numeric-literal

grammar supported

number in a parameter list for stored procedures 1 2

floating point comparison

grammar supported

as-or-semicolon SQL grammar element definition

attributes ignored by Pervasive PSQL

AUTOINC data type

AUTOINC(4) data type

AUTOINCREMENT data type

AVG aggregate function

before-or-after (grammar element defined)

before-or-after SQL grammar element definition

grammar supported

Between-predicate

grammar supported

BFLOAT data type 1 2

BFLOAT4 data type

BFLOAT8 data type

BIGINT data type

BINARY data type

0-padded if odd digits

default value not supported

Binary Large Objects

BIT data type 1 2

Bitwise operators

BLOB data type 1 2

default value not supported

Bound databases

IN DICTIONARY not permitted 1 2

Btrieve owner names See Owner names

Btrieve temporary file

cached_procedures setting

excluding stored procedures with DDL 1 2

excluding stored procedures with EXEC 1 2

excluding stored procedures with temporary tables 1 2

exclusions to caching stored procedures 1 2

procedures_cache setting

stored procedures 1 2

Cached_procedures setting

cached_procedures setting

excluding stored procedures with DDL 1 2

excluding stored procedures with EXEC 1 2

excluding stored procedures with temporary tables 1 2

exclusions to caching stored procedures 1 2

procedures_cache setting

stored procedures 1 2

calling a stored procedure

grammar supported

call-arguments SQL grammar element definition

grammar supported

grammar supported

CASE (grammar element defined)

case_value_expression (grammar element defined)

escape for wildcard characters

CHARACTER_LENGTH

CLOB data type 1 2

default value not supported

grammar supported

grammar supported

COALESCE ( (grammar element defined)

DBCobolNumeric setting

Schema Executor

executing sample XML file

sign value for positive NUMERIC data types

SQL access for applications

SQL enhanced access

Schema Executor

use of ALTER TABLE statement

use of CREATE INDEX

use of CREATE INDEX IN DICTIONARY

use of CREATE TRIGGER

use of DROP TABLE

use of INSERT INTO

col-constraint (grammar element defined) 1 2

col-constraint SQL grammar element definition

collation-name (grammar element defined) 1 2

collation-name SQL grammar element definition

system table (X$Attrib)

number allowed in a trigger

number in a select list

number in a table

system table (X$Field)

column-constraint (grammar element defined) 1 2

column-constraint SQL grammar element definition

column-definition (grammar element defined) 1 2

column-definition SQL grammar element definition

column-name (grammar element defined) 1 2

column-name SQL grammar element definition

number allowed in a trigger

as decimal separator

data display 1 2

grammar supported

commit-statement SQL grammar element definition

comparison-operator (grammar element defined)

comparison-operator SQL grammar element definition

Compressing data files

maximum number of connections

Connection strings

Constant values, expressing

constraint-name (grammar element defined) 1 2

constraint-name SQL grammar element definition

truncating DATETIME milliseconds

data to other types

Correlated subquery 1 2

Correlation-name

grammar supported

correlation-name SQL grammar element definition

COUNT aggregate function

COUNT( ), COUNT(*) functions

differences 1 2

CREATE FUNCTION

grammar supported

grammar supported

grammar supported

CREATE INDEX IN DICTIONARY

CREATE PROCEDURE

grammar supported

and temporary tables

file compression

grammar supported

IN DICTIONARY keyword

WITH REPLACE keyword

CREATE TABLE syntax

and temporary tables

grammar supported

using CREATE USER

using GRANT LOGIN

grammar supported

grammar supported

stored procedures

tables with legacy null support

user-defined functions

users and groups

CURRENCY data type 1 2 3

adding to an INSERT statement 1 2

adding to an INSERT statement 1 2

CURRENT_TIMESTAMP

how to loop through

type changed by TOP

cursor-name SQL grammar element definition

long, inserting or updating

Data control statements

Data definition language

Data definition statements

Data dictionaries

list of system tables

binary compatible cross-platform 1 2

replacing existing 1 2

system table (X$File)

Data manipulation

Data Source Names

connection string keywords

SQL_BIT(-7) 1 2

SQL_DECIMAL(3) 1 2 3 4

SQL_DOUBLE(8) 1 2

SQL_INTEGER(4) 1 2 3

SQL_LONGVARBINARY(-4)

SQL_LONGVARCHAR(-1)

SQL_NUMERIC(2) 1 2 3

SQL_REAL(7) 1 2

SQL_SMALLINT(5) 1 2 3

SQL_TIMESTAMP(11)

SQL_TINYINT(-6) 1 2

SQL_VARCHAR(12)

UNIQUEIDENTIFIER 1 2 3 4

UNSIGNED(1) BINARY

UNSIGNED(2) BINARY

UNSIGNED(4) BINARY

UNSIGNED(8) BINARY

converting to other types

lengths and ranges

limitations in stored procedures

limitations in triggers

limitations in user-defined functions

not supported by relational interface

that cannot be indexed

UNSIGNED BINARY

data-type (grammar element defined) 1 2

data-type SQL grammar element definition

data-type-name SQL grammar element definition

in which temporary tables are stored

fully qualified restriction

joining multiple

adding in INSERT statements

format supported 1 2

functions supported

inserting current 1 2

inserting or updating column values 1 2

literal format 1 2

TIMESTAMP data type

Date arithmetic

grammar supported 1 2

DATE data type 1 2 3

grammar supported

DATEADD scalar function

DATEDIFF scalar function

DATENAME scalar function

DATEPART scalar function

truncating milliseconds with CONVERT

DATETIME data type

Daylight savings, see Time

db-name SQL grammar element definition

DBCobolNumeric setting

changing data definitions without affecting data files

creating stored procedure

creating trigger

creating user-defined function

deleting stored procedure

deleting trigger

deleting user-defined function

exclusion to caching stored procedure 1 2

modifying table

DECIMAL data type 1 2 3

precision of SUM() function result

Decimal separator

display only 1 2

grammar supported

grammar supported

example of use in CREATE TABLE 1 2

Default values, see Values, default

default-value-expression (grammar element defined) 1 2

Btrieve indexes and 1 2 3 4

grammar supported 1 2

Delimited identifier

in SQL Statements

for identifiers in SQL statements

SQL statement in PCC

Disabling security

Disjointed index, definition of

grammar supported

DOUBLE data type

matching data that contains a

delimiter for identifiers in SQL statements

grammar supported

grammar supported

grammar supported

grammar supported

IN DICTIONARY keyword

grammar supported

grammar supported

connection strings

Dynamic cursors

SET ROWCOUNT and

type changed by TOP

grammar supported

Escape character

Exact-numeric-literal

grammar supported

to ODBC API support

SQLSpecialColumns

Exclusive OR bitwise operator

exclusion to caching stored procedure 1 2

exclusion to caching stored procedure 1 2

grammar supported

in stored procedures

subquery on left side of

expression (grammar element defined)

expression-or-subquery (grammar element defined)

expression-or-subquery SQL grammar element definition

Expressions as Default Values for Date-Time Columns

Supported Data Types and Constraints

Extended data types

grammar supported

fetch-orientation (grammar element defined)

fetch-orientation SQL grammar element definition

compression, specifying with SQL

location of temporary

FLOAT data type

comparing values

FLOAT(4) data type

FLOAT(8) data type

cannot ALTER column

grammar supported

Formats, literal

inserting value

inserting current

inserting value

Global variables

Grammar element definitions

alter-option-list

before-or-after

case_value_expression

col-constraint 1 2

collation-name 1 2

column-constraint 1 2

column-definition 1 2

column-name 1 2

comparison-operator

constraint-name 1 2

default-value-expression 1 2

expression-or-subquery

fetch-orientation

join-definition

order-by-expression

outer-join-definition

outer-join-type

parameter-type-name

proc-search-condition

query-specification

referencing-alias

referential-actions 1 2

referential-delete-action 1 2

referential-update-action 1 2

scalar-function

search-condition

select-list 1 2

subquery-expression

table-constraint 1 2 3 4

table-constraint-definition 1 2

table-element 1 2

table-reference 1 2

transaction-statement

Grammar Element Definitions

creating a user with GRANT LOGIN

grammar supported

Greater than (>) operator

grammar supported

with a HAVING clause

group-name SQL grammar element definition

in a GROUP BY expression

to loop through a cursor

delimited in SQL statements

IDENTITY data type

IDENTITY global variable. See @@IDENTITY

grammar supported

IF (with SELECT)

grammar supported

grammar supported

IN DICTIONARY keyword 1 2 3 4

not permitted on bound databases 1 2

In-memory temporary file

grammar supported

data types that cannot be indexed

definitions, SQL

Btrieve indexes and 1 2 3 4

disjointed, definition of

maximum indexed nullable columns

maximum length of

index-definition SQL grammar element definition

index-name SQL grammar element definition 1 2

index-segment-definition SQL grammar element definition

existing Btrieve and relational definitions 1 2 3 4

existing used when possible 1 2 3 4

ins-upd-del (grammar element defined)

ins-upd-del SQL grammar element definition

default values and

grammar supported

insert-values SQL grammar element definition

current time, current date and timestamp 1 2 3

INTEGER data type 1 2

INTEGER(1) data type

INTEGER(2) data type

INTEGER(4) data type

INTEGER(8) data type

Invalid row-count in subquery

returned if SELECT within UPDATE returns multiple rows

maximum tables in a

TOP clause in a

two-way LEFT OUTER JOIN

grammar supported

join type (grammar element defined)

join-definition (grammar element defined)

join-definition SQL grammar element definition

label-name SQL grammar element definition

grammar supported

LEFT OUTER JOIN

and vendor strings

maximum for column name

of path name in USING 1 2

Less than (<) operator

syntax and usage

LIKE predicates

on LONGVARBINARY

columns, number of

of LONGVARBINARY

of LONGVARBINARY in INSERT statements

of LONGVARCHAR in INSERT statements

of LONGVARCHAR in UNION statements

maximum ANDed predicates in SQL statement

maximum size of quoted string in SQL statement

of Pervasive ODBC Engine interface

SQL variables and parameters

stored procedures

arguments in a parameter list 1 2

number of columns 1 2

when using long data

literal (grammar element defined) 1 2

literal SQL grammar element definition

entering data longer than max

setting time zone

Locale-specific behavior

comma as decimal separator

data display 1 2

LOGICAL data type

Logical functions supported

inserting or updating

limits when using

limitations in INSERT statements

using SQLGetData

LONGVARBINARY data type

limitations in INSERT statements

limitations in UNION statements

using SQLGetData

LONGVARCHAR data type

grammar supported

LSTRING data type

MAX aggregate function

column name length

length of view name

Schema Executor

truncating from DATETIME

MIN aggregate function

MONEY data type

fully qualified name of database object

Named databases

and file names 1 2

NEWID scalar function

Non-correlated subquery

grammar supported

NOT bitwise operator

default values and

creating tables with legacy

setting for table creation 1 2

attempted insert into NOT NULL column with default value

cannot make column nullable

inserted by UPDATE if subquery returns no rows

Nullable columns

default value for

maximum number of indexed

NUMERIC data type 1 2 3

sign value for positive data type

Numeric functions supported

NUMERICSA data type 1 2 3

NUMERICSTS data type 1 2 3

fully qualified restriction

character translation

connection string

On-disk temporary file

grammar supported

bitwise AND (&)

bitwise Exclusive OR (^)

bitwise NOT (~)

truth table for bitwise operations

SQL Relational Database Engine

subquery on left side of expression

OR bitwise operator

SET ROWCOUNT and

order-by-expression (grammar element defined)

order-by-expression SQL grammar element definition

outer-join-definition (grammar element defined)

outer-join-definition SQL grammar element definition

outer-join-type (grammar element defined)

outer-join-type SQL grammar element definition

in secured databases

specifying in SQL

in BINARY columns

in CHAR columns

in LONGVARBINARY columns

in LONGVARCHAR columns

in VARCHAR columns

specifying with SQL

parameter (grammar element defined)

number of arguments for stored procedures 1 2

parameter SQL grammar element definition

parameter-name SQL grammar element definition

parameter-type (grammar element defined)

parameter-type SQL grammar element definition

parameter-type-name (grammar element defined)

parameter-type-name SQL grammar element definition

for Master user

password SQL grammar element definition

length in USING 1 2

Pattern matching

SQL Relational Database Engine

temporary tables

Permissions. See Rights

Pervasive Control Center

OEM characters and

Pervasive ODBC Engine interface

data types supported

positional-argument SQL grammar element definition

TOP vs. SET ROWCOUNT 1 2

SUM result on DECIMAL data

precision SQL grammar element definition

in stored procedures

predicate (grammar element defined)

predicate SQL grammar element definition

cannot ALTER column

grammar supported

grammar supported

proc-expr (grammar element defined)

proc-expr SQL grammar element definition

proc-search-condition (grammar element defined)

proc-search-condition SQL grammar element definition

proc-stmt (grammar element defined)

proc-stmt SQL grammar element definition

cached_procedures setting

caching of stored procedure 1 2

exclusions to caching of stored procedure 1 2

procedures_cache setting

procedure-name (grammar element defined)

procedure-name SQL grammar element definition

Procedures_cache setting

psp_column_attributes

psp_column_rights

psp_help_trigger

psp_stored_procedures

psp_table_rights

grammar supported

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

Push down filter

See table filter

query-specification (grammar element defined)

query-specification SQL grammar element definition 1 2

Quotation mark, representing single

Quoted string in SQL statement

matching data that contains

REAL data type 1 2

referencing-alias (grammar element defined)

referencing-alias SQL grammar element definition

Referential integrity

delete rules 1 2

X$Relate system table

referential-actions (grammar element defined) 1 2

referential-actions SQL grammar element definition

referential-delete-action (grammar element defined) 1 2

referential-delete-action SQL grammar element definition

referential-update-action (grammar element defined) 1 2

referential-update-action SQL grammar element definition

Regional settings

comma as decimal separator

data display 1 2

Relational index definitions

Btrieve indexes and 1 2 3 4

Relational interface

data types not supported

Relational security

RELEASE SAVEPOINT

grammar supported

release-statement SQL grammar element definition

Replacing data files 1 2

SET TIME ZONE and

~See also Words to avoid

DECIMALSEPARATORCOMMA

LEGACYOWNERNAME

TRIGGERSTAMPMISC