ADABAS D Reference

Top Level

Ordering the Manual

 

• Introduction

 

• Introduction

 

• Concepts

 

• Data Type

 

• Data Type

 

• Character String

 

• LONG Column

 

• Number

 

• Date Value

 

• Time Value

 

• Timestamp Value

 

• Boolean

 

• Parameter

 

• Parameter

 

• Table

 

• Table

 

• Column

 

• Column

 

• Domain

 

• Domain

 

• Index

 

• Index

 

• Synonym

 

• Synonym

 

• User and Usergroup

 

• User and Usergroup

 

• Privilege

 

• Privilege

 

• Database

 

• Database

 

• Distributed Database

 

• Distributed Database

 

• Transaction

 

• Transaction

 

• Subtransaction

 

• Subtransaction

 

• Session

 

• Session

 

• Data Integrity

 

• Data Integrity

 

• DB Procedure

 

• DB Procedure

 

• Trigger

 

• Trigger

 

• DB Function

 

• DB Function

 

• Snapshot Table

 

• Snapshot Table

 

• 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

 

• Specifying Values

 

• Date and Time Format

 

• Specifying a Key

 

• Specifying a Key

 

• <function spec

 

• <function spec

 

• <arithmetic function

 

• <trigonometric function

 

• <string function

 

• <date function

 

• <time function

 

• <extraction function

 

• <special function

 

• <conversion function

 

• <set function spec

 

• <set function spec

 

• <expression

 

• <expression

 

• <predicate

 

• <predicate

 

• <between predicate

 

• <bool predicate

 

• <comparison predicate

 

• <default predicate

 

• <exists predicate

 

• <in predicate

 

• <join predicate

 

• <like predicate

 

• <null predicate

 

• <quantified predicate

 

• <rowno predicate

 

• <sounds predicate

 

• <search condition

 

• <search condition

 

• SQL Statement

 

• SQL Statement

 

• Data Definition

 

• <create table statement

 

• <create table statement

 

• <column definition

 

• <constraint definition

 

• <referential constraint definition

 

• <key definition

 

• <unique definition

 

• <drop table statement

 

• <drop table statement

 

• <alter table statement

 

• <alter table statement

 

• <add definition

 

• <drop definition

 

• <alter definition

 

• <rename table statement

 

• <rename table statement

 

• <rename column statement

 

• <rename column statement

 

• <exists table statement

 

• <exists table statement

 

• <create domain statement

 

• <create domain statement

 

• <drop domain statement

 

• <drop domain statement

 

• <create synonym statement

 

• <create synonym statement

 

• <drop synonym statement

 

• <drop synonym statement

 

• <rename synonym statement

 

• <rename synonym statement

 

• <create snapshot statement

 

• <create snapshot statement

 

• <drop snapshot statement

 

• <drop snapshot statement

 

• <create snapshot log statement

 

• <create snapshot log statement

 

• <drop snapshot log statement

 

• <drop snapshot log statement

 

• <create view statement

 

• <create view statement

 

• <drop view statement

 

• <drop view statement

 

• <rename view statement

 

• <rename view statement

 

• <create index statement

 

• <create index statement

 

• <drop index statement

 

• <drop index statement

 

• <comment on statement

 

• <comment on statement

 

• Authorization

 

• <create user statement

 

• <create usergroup statement

 

• <drop user statement

 

• <drop usergroup statement

 

• <alter user statement

 

• <alter usergroup statement

 

• <grant user statement

 

• <grant usergroup statement

 

• <alter password statement

 

• <grant statement

 

• <revoke statement

 

• Data Manipulation

 

• Data Manipulation

 

• <insert statement

 

• <update statement

 

• <delete statement

 

• <refresh statement

 

• <clear snapshot log statement

 

• <next stamp 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

 

• <subquery

 

• Correlated Subquery

 

• <order clause

 

• <order clause

 

• <update clause

 

• <update clause

 

• <lock option

 

• <lock option

 

• <open cursor statement

 

• <open cursor statement

 

• <fetch statement

 

• <fetch statement

 

• <close statement

 

• <close statement

 

• <single select statement

 

• <single select statement

 

• <select direct statement: searched

 

• <select direct statement: searched

 

• <select direct statement: positioned

 

• <select direct statement: positioned

 

• <select ordered statement: searched

 

• <select ordered statement: searched

 

• <select ordered statement: positioned

 

• <select ordered statement: positioned

 

• <explain statement

 

• <explain statement

 

• Transactions

 

• Transactions

 

• <connect statement

 

• <commit statement

 

• <rollback statement

 

• <subtrans statement

 

• <lock statement

 

• <unlock statement

 

• <release statement

 

• System Tables

 

• System Tables

 

• Statistics

 

• Statistics

 

• <update statistics statement

 

• Statistical System Tables

 

• ADABAS Monitor

 

• ADABAS Monitor

 

• <monitor statement

 

• Restrictions

 

• Restrictions

 

• Compatibility with Former Versions

 

• Compatibility with Former Versions

 

• Syntax

 

• Syntax