ADABAS D Reference/ANSI

Top Level

Ordering the Manual

 

• Introduction

 

• Introduction

 

• Concepts

 

• Data Type

 

• Data Type

 

• Character String

 

• Number

 

• Parameter

 

• Parameter

 

• Table

 

• Table

 

• Column

 

• Column

 

• User and Usergroup

 

• User and Usergroup

 

• Privilege

 

• Privilege

 

• Database

 

• Database

 

• Distributed Database

 

• Distributed Database

 

• Transaction

 

• Transaction

 

• Session

 

• Session

 

• Data Integrity

 

• Data Integrity

 

• Backup and Recovery Concept

 

• Backup and Recovery Concept

 

• SQLMODE

 

• SQLMODE

 

• Code Tables

 

• Code Tables

 

• Common Elements

 

• <character

 

• <literal

 

• <token

 

• Names

 

• <column spec

 

• <parameter spec

 

• Specifying Values

 

• <set function spec

 

• <expression

 

• <predicate

 

• <predicate

 

• <between predicate

 

• <comparison predicate

 

• <exists predicate

 

• <in predicate

 

• <join predicate

 

• <like predicate

 

• <null predicate

 

• <quantified predicate

 

• <search condition

 

• <search condition

 

• SQL Statement

 

• SQL Statement

 

• Data Definition

 

• <create schema statement

 

• <create schema statement

 

• <create table statement

 

• <column definition

 

• <constraint definition

 

• <referential constraint definition

 

• <key definition

 

• <unique definition

 

• <create view statement

 

• <create view statement

 

• Authorization

 

• <grant statement

 

• Data Manipulation

 

• Data Manipulation

 

• <insert statement

 

• <update statement

 

• <delete statement

 

• Data Retrieval

 

• Data Retrieval

 

• <query statement

 

• <query statement

 

• <query expression

 

• <query spec

 

• <table expression

 

• <table expression

 

• <from clause

 

• <where clause

 

• <group clause

 

• <having clause

 

• <subquery

 

• Correlated Subquery

 

• <order clause

 

• <order clause

 

• <open cursor statement

 

• <open cursor statement

 

• <fetch statement

 

• <fetch statement

 

• <close statement

 

• <close statement

 

• <single select statement

 

• <single select statement

 

• Transactions

 

• Transactions

 

• <connect statement

 

• <commit statement

 

• <rollback statement

 

• <release statement

 

• Restrictions

 

• Restrictions

 

• Differences

 

• Differences

 

• SQLSTATEs

 

• SQLSTATEs

 

• Syntax

 

• Syntax