Additional SQL:2003 features supported in NexusDB SQL

 

Feature ID

 

Feature description

 

B128

Routine language SQL

F033

ALTER TABLE statement: DROP COLUMN clause

F052

Intervals and datetime arithmetic

F171

Multiple schemas per user

F191

Referential delete actions

F222

INSERT statement: DEFAULT VALUES clause

F271

Compound character literals

F281

LIKE enhancements

F291

UNIQUE predicate

F302

INTERSECT table operator

F302-01

INTERSECT DISTINCT table operator

F302-02

INTERSECT ALL table operator

F304

EXCEPT ALL table operator

F381

Extended schema manipulation

F381-01

ALTER TABLE statement: ALTER COLUMN clause

F381-02

ALTER TABLE statement: ADD CONSTRAINT clause

F381-03

ALTER TABLE statement: DROP CONSTRAINT clause

F391

Long identifiers

F401

Extended joined table

F401-01

NATURAL JOIN

F401-02

FULL OUTER JOIN

F401-04

CROSS JOIN

F421

National character

F491

Constraint management

F531

Temporary tables

F561

Full value expressions

F571

Truth value tests

F591

Derived tables

F671

Subqueries in CHECK constraints

F672

Retrospective check constraints

F692

Enhanced collation support

F701

Referential update actions

F741

Referential MATCH types

T031

BOOLEAN data type

T041

Basic LOB data type support

T041-01

BLOB data type

T041-02

CLOB data type

T041-03

POSITION, LENGTH, LOWER, TRIM, UPPER, and SUBSTRING functions

for LOB data types

T041-04

Concatenation of LOB data types

T071

BIGINT data type

T171

LIKE clause in table definition

T172

AS subquery clause in table definition

T191

Referential action RESTRICT

T201

Comparable data types for referential constraints

T211

Basic trigger capability

T211-01

Triggers activated on UPDATE, INSERT, or DELETE of one base table.

T211-02

BEFORE triggers

T211-03

AFTER triggers

T211-04

FOR EACH ROW triggers

T211-05

Ability to specify a search condition that shall be True before the trigger is invoked.

T241

START TRANSACTION statement

T326

Table functions

T351

Bracketed SQL comments (/*...*/ comments)

T441

ABS and MOD functions

T501

Enhanced EXISTS predicate

T551

Optional key words for default syntax

T591

UNIQUE constraints of possibly null columns

T621

Enhanced numeric functions

T651

SQL-schema statements in SQL routines

T653

SQL-schema statements in external routines

P002

Computational completeness

P002-01

<compound statement>

P002-04

<SQL variable declaration>

P002-05

<assignment statement>

P002-07

<if statement>

P002-08

<iterate statement>

P002-09

<leave statement>

P002-11

<repeat statement>

P002-12

<while statement>

P002-14

<signal statement>