What's New in Pervasive PSQL v9.0 - Table of Contents

Pervasive PSQL v9 SP2 (9.5) (code WHN_950, revision 1)  Books in this release

About This Manual

Who Should Read This Manual

Manual Organization

Conventions

What's New in Pervasive PSQL v9

List of New Features and Improvements

COBOL Support

SQL Enhanced Access

Shifted and Unshifted Sign Value for NUMERIC Data Types

Configuration Changes

I*net Data Server Removed

5.x Files Support Reduced

Configuration Settings Not Manually Adjustable

Configuration Settings With Modified Defaults

Configuration Settings With Modified Values

Configuration Settings Not Requiring an Engine Restart

Configuration Settings That Dynamically Increase

Windows 16-bit Client Configuration

File Size Support

Maximum File Size of 128 Gigabytes

File Segmentation

Automatic Upgrade of File Version

Installation

Improved Installation Modularity

Linux

Performance Equality with Windows

Client Use of idshosts File and PIDS Protocol Strings

Network Communications

Programming Interfaces

Btrieve API Improvements

Distributed Tuning Interface Improvements

Relational Interface Support

ALTER (rename)

ALTER TABLE Enhancements

Bitwise Operators

CASE Expression

DEFAULT Keyword

EXECUTE Statement

FROM Clause in UPDATE and DELETE Statements

Global Variables

Grouped View Support

Linked Duplicate Keys for CREATE TABLE

ODBC 3.5 Support

Promotion of Numeric Data Types

Scalar Functions

SELECT Statement

SET ANSI_PADDING

Subquery Expressions

System Stored Procedures

User Defined Functions

Utilities and Documentation

Pervasive PSQL Control Center

Command Line Interface Utilities

JavaHelp Documentation