![]() |
![]() |
![]() |
![]() |
![]() |
Master Contents
Documentation
SQL Reference
- Introduction
- About this Manual
- Reading SQL Syntax Diagrams
- Key to Syntax Diagrams
- Reading Standard Compliance Tables
- Introduction to SQL Standards
- Mimer SQL Database Objects
- The Data Dictionary
- Databanks
- Idents
- Schemas
- Tables
- Primary Keys and Indexes
- Stored Procedures
- Synonyms
- Shadows
- Triggers
- Sequences
- Precompiled Statements
- Mimer SQL Character Sets
- Collations
- Data Integrity
- Privileges
- Collations and Linguistic Sorting
- SQL Syntax Elements
- Separators
- Special Characters
- Identifiers
- Data Types in SQL Statements
- Literals
- Operators and Values
- Operators
- Value Specifications
- Default Values
- Assignments
- Comparisons
- Result Data Types
- Functions
- Set Functions
- Expressions and Predicates
- Expressions
- CASE Expression
- CAST Specification
- User-Defined Function
- Predicates
- Search Conditions and Joins
- Search Conditions
- Joined Tables
- INNER JOINs
- OUTER JOINs
- CROSS JOINs
- Standard Compliance
- The SELECT Expression
- SQL Statement Descriptions
- Usage Modes
- ALLOCATE CURSOR
- ALLOCATE DESCRIPTOR
- ALTER DATABANK
- ALTER DATABANK RESTORE
- ALTER DATABASE
- ALTER FUNCTION
- ALTER IDENT
- ALTER PROCEDURE
- ALTER ROUTINE
- ALTER SEQUENCE
- ALTER SHADOW
- ALTER STATEMENT
- ALTER TABLE
- CALL
- CASE
- CLOSE
- COMMENT
- COMMIT
- COMPOUND STATEMENT
- CONNECT
- CREATE BACKUP
- CREATE COLLATION
- CREATE DATABANK
- CREATE DOMAIN
- CREATE FUNCTION
- CREATE IDENT
- CREATE INDEX
- CREATE MODULE
- CREATE PROCEDURE
- CREATE SCHEMA
- CREATE SEQUENCE
- CREATE SHADOW
- CREATE STATEMENT
- CREATE SYNONYM
- CREATE TABLE
- CREATE TRIGGER
- CREATE VIEW
- DEALLOCATE DESCRIPTOR
- DEALLOCATE PREPARE
- DECLARE CONDITION
- DECLARE CURSOR
- DECLARE HANDLER
- DECLARE SECTION
- DECLARE VARIABLE
- DELETE
- DELETE CURRENT
- DELETE STATISTICS
- DESCRIBE
- DISCONNECT
- DROP
- ENTER
- EXECUTE
- EXECUTE IMMEDIATE
- EXECUTE STATEMENT
- EXPLAIN
- FETCH
- FOR
- GET DESCRIPTOR
- GET DIAGNOSTICS
- GRANT ACCESS PRIVILEGE
- GRANT OBJECT PRIVILEGE
- GRANT SYSTEM PRIVILEGE
- IF
- INSERT
- ITERATE
- LEAVE
- LEAVE (PROGRAM ident)
- LOOP
- OPEN
- PREPARE
- REPEAT
- RESIGNAL
- RETURN
- REVOKE ACCESS PRIVILEGE
- REVOKE OBJECT PRIVILEGE
- REVOKE SYSTEM PRIVILEGE
- ROLLBACK
- SELECT
- SELECT INTO
- SET
- SET CONNECTION
- SET DATABANK
- SET DATABASE
- SET DESCRIPTOR
- SET SESSION
- SET SHADOW
- SET TRANSACTION
- SIGNAL
- START
- UPDATE
- UPDATE CURRENT
- UPDATE STATISTICS
- WHENEVER
- WHILE
- Data Dictionary Views
- INFORMATION_SCHEMA
- Appendix A Reserved Words
- Appendix B Character Sets
- Appendix C Limits
- Appendix D Deprecated Features
- Indicator Variables
- Operators
- Statements
- Program Idents
- Functions
- Datetime Scalar Functions
- Data Dictionary Views
- Host Variable Types
- SQL Data Types
- Appendix E Return Status and Conditions
- SQLSTATE Return Codes
- SQLCODE Return Codes
- Appendix F SQL-2016 Compliance
- Features Outside Core Supported by Mimer SQL
- Appendix G Compatibility Functions
- Appendix H Languages
- Appendix I Type Precedence Lists
Programmer's
- Introduction
- About this Manual
- Database APIs
- Mimer SQL and the ODBC API
- The Mimer ODBC Driver
- Required Files
- Unicode and ANSI Interfaces
- Mimer Specific Descriptor Fields
- Operating Systems
- Declarations
- Initializing the ODBC Environment
- Error Handling
- Transaction Processing
- Executing a Command
- Repeating - Prepared Execution
- Result Set Processing
- Updating Data
- Mimer SQL and the JDBC API
- The Mimer JDBC Driver
- Embedded SQL
- General Principles for Embedding SQL Statements
- Processing ESQL
- Essential Program Structure
- Linking Applications
- Connecting to a Database
- Communicating with the Application Program
- Accessing Data
- Dynamic SQL
- Handling Errors and Exceptions
- Mimer SQL C API
- Architecture
- Array Operations
- Transactions
- Data Types
- Error Handling
- Memory Management
- Header Files Provided
- Mimer API Examples
- Mimer API Specification
- Mimer SQL Real-Time
- Real-Time Users Guide
- Real-Time Error Handling
- Real-Time API Specification
- Idents and Privileges
- Mimer SQL Idents
- Database Privileges
- Transaction Handling and Database Security
- Transaction Principles
- Transactions and Logging
- Protecting Against Data Loss
- Transaction Control Statements
- Distributed Transactions
- Terms and Abbreviations
- How Does it Work?
- Handling failures
- Mimer SQL Support For Microsoft DTC on Windows
- Mimer SQL Support for Java Enterprise Edition
- Mimer SQL Stored Procedures
- About Routines
- Syntactic Components of a Routine Definition
- Modules
- SQL Constructs in Routines
- Manipulating Data
- Result Set Procedures
- Managing Exception Conditions
- Access Rights
- Using DROP and REVOKE
- The Mimer SQL PSM Debugger
- Triggers
- Creating a Trigger
- Trigger Time
- Trigger Event
- Trigger Action
- Comments on Triggers
- Using DROP and REVOKE
- Spatial Data
- Geographical Data
- Coordinate System Data
- Appendix A Host Language Dependent Aspects
- ESQL in C/C++ Programs
- ESQL in COBOL Programs
- ESQL in FORTRAN Programs
- Appendix B Return Codes
- SQLSTATE Return Codes
- Native Mimer SQL Return Codes
- Appendix C Deprecated Features
- INCLUDE SQLCA
- SQLDA
- VARCHAR(size)
- SET TRANSACTION
- DBERM4
User's
- Introduction
- About this Manual
- Basic Concepts of Mimer SQL
- Tables
- Primary Keys and Indexes
- Data Integrity
- Sequences
- Synonyms
- Databanks
- Shadows
- Mimer SQL Character Sets
- Collations and Linguistic Sorting
- Stored Procedures
- Idents
- Schemas
- Access Rights and Privileges
- The Data Dictionary
- Mimer SQL Statements
- Retrieving Data
- Simple Retrieval
- Result Order
- Table Names
- Setting Column Labels
- Eliminating Duplicate Values
- Selecting Specific Rows
- Retrieving Computed Values
- Using Scalar Functions
- Using the CASE Expression
- Using the CAST Specification
- Datetime Arithmetic and Functions
- Using Set Functions
- Grouped Set Functions - the GROUP BY Clause
- Selecting Groups - the HAVING Clause
- Ordering the Result Table
- Retrieving Data From More Than One Table
- Handling Null Values
- Conceptual Description of the Selection Process
- Collations
- Character Sets and Collations
- Using Collations
- Using Collations - Examples
- Working With Data
- Inserting Data
- Updating Tables
- Deleting Rows from Tables
- Calling Procedures
- Updatable Views
- Managing Transactions
- Transaction Principles
- Logging Transactions
- Handling Transactions
- Creating a Database
- Creating Idents and Schemas
- Creating Databanks
- Creating Tables
- Creating Sequences
- Creating Domains
- Creating Functions, Procedures, Triggers and Modules
- Creating Views
- Creating Secondary Indexes
- Creating Synonyms
- Commenting Objects
- Altering Databanks, Tables and Idents
- Dropping Objects from the Database
- Defining Privileges
- Ident Structure
- Granting Privileges
- Revoking Privileges
- Mimer BSQL
- Running BSQL
- BSQL Commands
- Variables in BSQL
- BSQL and Multiple Connections
- Transaction Handling in Mimer BSQL
- LOBs in BSQL
- Errors in BSQL
- Error Messages
- Appendix A Mimer SQL Explain
- Appendix B The Example Environment
- The EXLOAD program
- The MIMER_STORE Schema
- Procedures
- Views
- Triggers
- Idents
- The MIMER_STORE_MUSIC Schema
- The MIMER_STORE_BOOK Schema
- The MIMER_STORE Schema Revisited
- The MIMER_STORE_WEB Schema
- Synonyms
- Appendix C Deprecated Features
- BSQL Commands
System Management
- Introduction
- About this Manual
- System Management Responsibilities
- The Database Environment
- The Data Dictionary
- Idents
- Schemas
- Databanks
- Databank Options
- Locating Databank Files
- Organizing Databank Files
- Altering Databank Locations
- Accessing Databank Files
- Databank File Deletion
- Transaction Control
- Database Security
- Data Integrity
- Creating a Mimer SQL Database
- Registering the Database
- The Local Database
- Accessing a Database Remotely
- Mimer SQL License Key
- MIMLICENSE - Managing the license key
- SDBGEN - Generating the System Databanks
- Establishing the Ident and Data Structure
- Managing Database Connections
- Executing SQL Statements
- Managing a Database Server
- Database Server Memory Areas
- Threads
- Database Server System Requirements
- MIMCONTROL - Controlling the Database Server
- MIMINFO - System Information
- Database Server Log
- Several Installations on One Machine
- Backing-up and Restoring Data
- Database Consistency
- Databank Backups
- Backing-up Databanks
- Restoring a Databank
- Audit trail with READLOG
- Databank Check Functionality
- DBC - Databank Check
- Result File Contents
- Internal Databank Check
- Databank Open Function
- DBOPEN - Databank Open functionality
- Functions
- Loading and Unloading Data and Definitions
- MIMLOAD - Data Load and Unload
- LOAD - Loading Data
- UNLOAD - Unloading Data
- Replication
- MIMREPADM - Replication Administration
- REPSERVER - Replicating the Data
- MIMSYNC - Synchronizing Tables
- Mimer SQL Shadowing
- About Databank Shadowing
- Levels of Data Protection
- Creating and Managing Shadows
- SQL Shadowing Commands - an Example Session
- Shadowing System Databanks
- Data Protection Strategy
- Configuring Your System
- Performance Aspects of Shadowing
- Troubleshooting
- Database Statistics
- Authorization
- The SQL Statistics Statements
- When to Use the SQL Statistics Statements
- SQL Monitoring on the Database Server
- Authorization
- Appendix A Executing in Single-user Mode
- File Protection in Single- and Multi-user Mode
- Specifying Single-user Mode Access
- Accessing in Single-user Mode
- The SINGLEDEFS Parameter File
- Appendix B The SQLHOSTS File on VMS and Linux
- The SQLHOSTS File
- Appendix C The MULTIDEFS File on VMS and UNIX
- The MULTIDEFS Parameter File
- MULTIDEFS Parameters
- Appendix D Linux Specifics
- Man Pages
- Automatic Database Start and Stop
- MIMTCP -Database TCP/IP connect dispatcher
- Services setup
- Networking Setup
- Environment Variables
- Linux Commands
- Linux Link Libraries
- Appendix E Data Dictionary Tables
- Summary of Data Dictionary Tables
- Appendix F Deprecated Features
- Export/Import
- Load/Unload
- Readlog from UTIL
- Backup/Restore from UTIL
- Statistics from UTIL
- Shadowing Management from UTIL
![]() Mimer Information Technology AB Phone: +46 18 780 92 00 info@mimer.com |
![]() |
![]() |
![]() |
![]() |
![]() |