SQL/MX 3.5 Release Technical Update
Overview_technote
Database Compatibility
DATE TYPE2
Functions modified for DC_DATE
DATE_FORMAT SET SESSION DEFAULT
DC DATE
ODBC and JDBC support for DATE TYPE2
Number
VARCHAR2
VARCHAR 2_Connectivity
TO_Date Function
Materialized Views
CREATE MATERIALIZED VIEW
ALTER MATERIALIZE VIEW
DROP MATERIALIZED VIEW
MERGE Statement
MERGE
MERGE Semantics
PL/MX
Database Services
User Management
CREATE USER
DROP USER
CREATE PRIVILEGE GROUP
ALTER PRIVILEGE GROUP
GIVE PRIVILEGE GROUP
DROP PRIVILEGE GROUP
Schema Level Privileges
GRANT and REVOKE changes
GRANT Statement
Syntax Description of GRANT
Considerations for GRANT
REVOKE Statement
Syntax Description of REVOKE
Considerations for REVOKE
MXOAS enhancement to listen on Configurable IP Addresses
AF_UNIX Protocol Support
Table Size Specifications
Metadata tables
System Schema Tables
DATABASE_USERS table
DATABASE_USERS_EXT TABLE
PRIVILEGE_GROUPS TABLE
PRIVILEGE_GROUP_GRANTS TABLE
PRIVILEGE_GROUP_MEMBERSHIP tables
SYSTEM_DBS_SCHEMA Tables
ALL_DATABASES Tables
DATABASE_CPUS TABLES
DATABASE_DS Table
DATABASE_PRIVILEGE_GROUPS Tables
DATABASE_VOLUMES Table
DBS_SERVICES
DBS_GLOBALS TABLE
DBS_PLATFORM_USERS TABLES
DBS_SFG_GROUPS Tables
DBS_VOLUMES table
DEFINITION_SCHEMA_VERSION_3500 Tables
COL_GROUP_PRIVILEGES table
ROUTINES table
TBL_GROUP_PRIVILEGES Table
SCH_PRIVILEGES Table
SCH_GROUP_PRIVILEGES Table
Attributes
Websites (NonStop)
Support and other resources
Accessing Hewlett Packard Enterprise Support
Accessing updates
Customer self repair
Remote support
Warranty and regulatory information
Regulatory information
Documentation feedback
SQL/MX Functions Compatible with Oracle
Search
Overview_technote
Database Compatibility
Database Compatibility
DATE TYPE2
Functions modified for DC_DATE
DATE_FORMAT SET SESSION DEFAULT
DC DATE
ODBC and JDBC support for DATE TYPE2
Number
VARCHAR2
VARCHAR 2_Connectivity
TO_Date Function
Materialized Views
CREATE MATERIALIZED VIEW
ALTER MATERIALIZE VIEW
DROP MATERIALIZED VIEW
MERGE Statement
MERGE
MERGE Semantics
PL/MX
Database Services
User Management
User Management
CREATE USER
DROP USER
CREATE PRIVILEGE GROUP
ALTER PRIVILEGE GROUP
GIVE PRIVILEGE GROUP
DROP PRIVILEGE GROUP
Schema Level Privileges
GRANT and REVOKE changes
GRANT and REVOKE changes
GRANT Statement
Syntax Description of GRANT
Considerations for GRANT
REVOKE Statement
Syntax Description of REVOKE
Considerations for REVOKE
MXOAS enhancement to listen on Configurable IP Addresses
AF_UNIX Protocol Support
Table Size Specifications
Metadata tables
Metadata tables
System Schema Tables
DATABASE_USERS table
DATABASE_USERS_EXT TABLE
PRIVILEGE_GROUPS TABLE
PRIVILEGE_GROUP_GRANTS TABLE
PRIVILEGE_GROUP_MEMBERSHIP tables
SYSTEM_DBS_SCHEMA Tables
ALL_DATABASES Tables
DATABASE_CPUS TABLES
DATABASE_DS Table
DATABASE_PRIVILEGE_GROUPS Tables
DATABASE_VOLUMES Table
DBS_SERVICES
DBS_GLOBALS TABLE
DBS_PLATFORM_USERS TABLES
DBS_SFG_GROUPS Tables
DBS_VOLUMES table
DEFINITION_SCHEMA_VERSION_3500 Tables
COL_GROUP_PRIVILEGES table
ROUTINES table
TBL_GROUP_PRIVILEGES Table
SCH_PRIVILEGES Table
SCH_GROUP_PRIVILEGES Table
Attributes
Websites (NonStop)
Support and other resources
Support and other resources
Accessing Hewlett Packard Enterprise Support
Accessing updates
Customer self repair
Remote support
Warranty and regulatory information
Regulatory information
Documentation feedback
SQL/MX Functions Compatible with Oracle
Version