ADABAS D Tutorial

Top Level

Ordering the Manual

 

• Introduction

 

• Introduction

 

• Fundamentals

 

• Fundamentals

 

• Example of a SELECT Statement

 

• Selecting Particular Columns

 

• Ordering Columns

 

• Selecting Particular Rows

 

• Ordering Rows

 

• Ordering According to More than One Column

 

• Eliminating Duplicate Rows

 

• Keeping Result Sets

 

• Introducing New Result Column Names

 

• Conditional Selection

 

• Conditional Selection

 

• Comparison Operations

 

• Multiple Conditions: AND, OR

 

• Multiple Conditions: AND, OR

 

• Parentheses with AND and OR

 

• Ranges of Values: BETWEEN x AND y

 

• Ranges of Values: BETWEEN x AND y

 

• Values in a Set: IN (x,y,z)

 

• Values in a Set: IN (x,y,z)

 

• Searching For Character Strings

 

• Searching For Character Strings

 

• Negative Conditions: NOT

 

• Negative Conditions: NOT

 

• NOT with NULL, LIKE, IN, BETWEEN

 

• NOT with NULL, LIKE, IN, BETWEEN

 

• Grouping Values: GROUP BY

 

• Grouping Values: GROUP BY

 

• Groups with Conditions: HAVING

 

• Groups with Conditions: HAVING

 

• Virtual Result Columns

 

• Expanding the Sample

 

• Arithmetic within the Result List

 

• Expressions with +, -, *, / , DIV, MOD

 

• Arithmetic Operations

 

• Trigonometric Functions

 

• Date and Time Calculations

 

• Evaluation Sequence

 

• Arithmetic in a Condition

 

• Columns with Set Functions

 

• Operations with Character Strings

 

• Operations with Character Strings

 

• Value Code Conversion

 

• Concatenating Two CHAR Columns

 

• Eliminating and Inserting Characters

 

• Shortening Values

 

• Displacing Values

 

• Creating Bar Charts

 

• Determining the Number of Characters

 

• Replacements in Character Strings

 

• Notational Checks

 

• Searching the Position of Character Strings

 

• Determining Minima and Maxima in Character Strings

 

• Subqueries

 

• IN, ALL, ANY, EXISTS

 

• Correlation

 

• Columns from Two and More Tables

 

• Information from Two Tables

 

• Information from Three Tables

 

• Outer Join

 

• Set Operations

 

• Set Operations

 

• UNION

 

• INTERSECT

 

• EXCEPT

 

• Data Definition and Entries

 

• Creating a Table

 

• Data Types in a Table

 

• Column Constraints

 

• Replicated Tables

 

• Inserting Rows

 

• Updating Rows

 

• Deleting Rows

 

• Relations between Tables

 

• Updating Column Definitions

 

• Short Names for a Table

 

• Creating Views

 

• Creating Snapshot Tables

 

• Creating an Index

 

• Creating Domains

 

• DB Procedures

 

• Triggers

 

• DB Functions

 

• Dropping Objects

 

• Transactions

 

• Accessing Single Rows

 

• Key Concept

 

• Direct Access Using a Key

 

• Position-based Access Using a Key

 

• Conditional Position-based Access

 

• Multiple Key

 

• Authorization

 

• User Classes

 

• The SYSDBA Installs DBAs

 

• The DBAs Install Additional Users

 

• Modifying and Removing User Profiles

 

• Catalog Information

 

• Catalog Information

 

• Tables

 

• Domains

 

• Constraints

 

• Views

 

• Synonyms

 

• Primary Keys

 

• Indexes

 

• Referential Integrity Constraints

 

• Privileges

 

• User Profiles

 

• Administrative Information

 

• Statistical Information

 

• The Tables Used

 

• The Tables Used