What's New in Pervasive.SQL v9.0 - Index

Numerics - A - B - C - D - E - F - G - I - K - L - N - O - P - R - S - U - W - Symbols

---

Numerics

16-bit clients

configuring

2 GB file segments

configuration property

A

ALTER (rename)

ALTER TABLE

move a column

rename a column

B

Bitwise operators

Bulk Data utility 1 2

C

CASE as expression

CASE expression

CAST scalar function

Client requester

configuring Windows 16-bit

Clients

configuring Windows 16-bit

COALESCE as expression

COALESCE scalar function

COBOL

DBCobolNumeric setting

occurs support

partial redefines support

sign value for positive NUMERIC data types

SQL enhanced access

variable record layouts

Column names in ORDER BY with UNION

Control Center

Pervasive.SQL 1 2

CREATE FUNCTION

D

Data type precedence

DBCobolNumeric setting

DECIMAL data types

precision

scale

DEFAULT keyword

DELETE

FROM clause

E

EXECUTE statement

Expressions

data type precedence

operator precedence

subquery

F

Features

list of new and improved

File

segmentation

size

limiting to 2 GB

support for 128 GB

version

automatic upgrade

File version

automatic upgrade

FROM clause in UPDATE and DELETE statements

Functions

user defined

G

Global variables

@@SPID

Grouped view

in SELECT list

I

I*net data server

conversion of PIDS string

environment configuration

idshosts file

possible application changes to use

Idshosts file

configuring for Linux

use IDS configuration property

Import data

See Bulk Data utility

Importing data

See Bulk Data utility

Improvements

in current release

ISNULL scalar function

K

Keys

duplicate

L

LINKDUP keyword

Linked duplicate keys

for CREATE TABLE

N

New features

NULL as expression

NUMERIC

sign value for positive data type

NUMERIC data type

shifted and unshifted sign value for

NUMERIC data types

promotion of

O

ODBC

conformance

support for 3.5

ODBC 3.5

support for

Operator precedence

ORDER BY with UNION

column names in

P

PCC 1 2

Pervasive.SQL Control Center 1 2

PIDS strings

conversion of

Precedence

data type

operator

Precision

of DECIMAL data types

Procedures

system stored

PvCloseDatabase() 1 2

PvConnectServer()

error messages

PvCreateDatabase() 1 2

PvOpenDatabase() 1 2

R

Redefines

See COBOL

S

Scalar functions

CAST

COALESCE

ISNULL

Scale

of DECIMAL data types

Segment

file segment property

SET ANSI_PADDING

Shift

value for positive NUMERIC data types

Sign value

for positive NUMERIC data types

shifted and unshifted for NUMERIC data type

SQL

enhanced access for COBOL 1 2

Subquery as expression

Subquery expressions

System procedures

System stored procedures

U

UNION

column names in ORDER BY

UNION in subquery

UPDATE

FROM clause

User defined functions

User-defined functions

W

What is new in the current release

Symbols

@@SPID