Documentation Changes

Documentation Changes

The following documentation updates have been made since the last release of this documen tation.

This guide has been appropriately revised with additions and updates that include the following:

• added ALTER AREA statement
• updated ALTER TABLE statement
• added ALTER DATABASE statement
• added CREATE AREA statement
• added CREATE DATABASE statement
• updated DECLARE CURSOR statement
• added DROP AREA statement
• added DROP DATABASE statement
• added SQL Databases section
• added SQL Areas section
• added UNSIGNED to the column definition options for ALTER TABLE
• added UNSIGNED to the column definition options for CREATE TABLE (see the CREATE TABLE column definition)
• added information about DBSQLPR-related message DB00248I (see DBSQLPR)
• added a performance enhancement comment to COUNT(*) (see Counting)
• added the REPLACE function (see Character Functions)
• added the POSSTR function (see Character Functions)
• converted the SQL-related DIAGOPTION 1,64 to a MUF startup option SQL_ALLOW_TIME_240000 (see the CA Datacom/DB Database and System Administration Guide)
• added a QUERYNO option to the Select-Statement
• updated a tables to include signed columns (see Data Type of the Column, Null Value, and Sign)
• updated a tables to include signed columns (see SQLDA (EXECUTE, FETCH, or OPEN Statement)