SAP XRPM and SAP PPM Library
  •  MaxDB Library

 Backup

Choose the appropriate example for you:

Complete Data Backup to a File

Complete Data Backup to a Tape

Incremental Data Backup to a File

Log Backup to a Pipe

Displaying the Backup Status

Activating Automatic Log Backup

Backups with Backup Tools from Other Providers

  • MaxDB Library
    • Installation
      • Installation Manual
        • Using the Installation Manager
          • Installing/Upgrading on UNIX/Linux
          • Installing/Upgrading on Microsoft Windows
          • Creating a Database Instance Afterwards
          • Creating the Demo Database Instance DEMODB
          • Uninstallation
          • Deleting a Database Instance
        • Installation, Upgrade and Uninstallation on the Command Line
          • Installing and Updating the Database Software
            • Installing/Updating Software on UNIX
              • Unpacking the Software on UNIX
              • Interactive Installations/Update on UNIX
              • Background Installations/Updates on UNIX
            • Installing/Updating Software on Linux
              • Installations/Updates with SDBINST
              • Installations/Updates with the Red Hat Package Manager
            • Installing/Updating Software on Microsoft Windows
              • Unpacking the Software on Microsoft Windows
              • Interactive Installations/Updates on Microsoft Windows
              • Background Installations/Updates on Microsoft Windows
          • Uninstalling the Database Software
            • Uninstalling with SDBUNINST on UNIX, Linux and Microsoft Windows
            • Uninstalling with the Red Hat Package Manager
          • Upgrading Database Instances and Their Server Software
            • Selection of the Upgrade Strategy
              • Patch Installation with SDBUPD
              • Patch Installation with SDBINST and Follow-Up Actions
              • In-Place Migration with SDBUPD
              • In-Place Migration with SDBINST and Follow-Up Actions
              • Upgrading with APO Extract/Load
        • Connecting Backup Tools from Other Providers
          • Block Diagram: Backing Up and Restoring
          • Block Diagram: Importing and Exporting Data
          • Connecting to a Backint for Oracle Interface
            • Restrictions for Using Backint for Oracle with Versions Smaller
            • How the MaxDB Adapter Program Works
            • Configuring the Backint for Oracle Connection
              • Creating the Parameter File for the MaxDB Adapter Program
                • Example of a Parameter File for the MaxDB Adapter Program
              • Creating the Configuration File for Backint for MaxDB
                • Example of a Configuration File for Backint for MaxDB
              • Exporting Environment Variables for the External Backup Tool
              • Setting the Environment Variable BSI_ENV
              • Setting Non-Tool-Specific Environment Variables for the Database
                • Setting TEMP or TMP
                • Setting DBM_TTO_SUCCESS and DBM_TTO_FAILURE
          • Connecting to a Backint for MaxDB Interface
            • Restrictions for Using Backint for MaxDB for Versions Smaller th
          • Connecting to TSM
            • Restrictions for Using TSM for Versions Smaller than 7.5
            • Restrictions for Parallel Backups and Restores with TSM for Vers
            • Configuring the TSM Connection
              • Setting the Environment Variables ADINT and ADA_OPT
          • Connecting to NetWorker
            • Restrictions for Using NetWorker for Versions Smaller than 7.5
            • Restrictions for Parallel Backups and Restores Using NetWorker f
            • Configuring the NetWorker Connection
              • Setting the Environment Variable NSR_ENV
              • Creating the Configuration File for NetWorker
                • Example of a Configuration File for NetWorker
          • Connecting to VERITAS NetBackup
        • Installing the Synchronization Manager
        • Installing MaxDB PHP Extension
          • Creating and Installing the MaxDB PHP Extension on Linux
            • Testing the MaxDB PHP Extension (Linux)
          • Installing the Max DB PHP Library (Microsoft Windows)
            • Testing the PHP Library (Microsoft Windows)
        • Configuring Web SQL / WebDAV
        • Troubleshooting
          • Errors in the Execution of the Program SDBINST
          • Errors in the Execution of the SDBUPD Program
            • Case 1: No Database Instances Exist Yet
            • Case 2: Downgrading Dependent Software
            • Case 3: Downgrade for Independent Software
        • Details
          • Directories
            • Directory Structure Within SAP Systems
            • Directory Structure Outside SAP Systems
          • Component Groups
          • Installation Profiles
          • Software Components
          • Logging
          • Displaying Installed Software Components
          • Overview of Options for the SDBINST Program
          • Overview of Options for the Program SDBUNINST
          • Overview of Options for the SDBUPD Program
    • Basic Information
      • Concepts of the Database System
        • Software Information
          • SAP DB and MaxDB
          • Documentation
          • Demo Database
            • Objects in the Schema HOTEL
          • Download
          • Version Notation
          • Supported Operating Systems and Architectures
          • Open Source Development of the Database Software
          • Support
          • Tracking Problem Messages with Web PTS
        • Overview of the Database System
          • SQL
          • Transactions
            • Logging Data Changes
              • History Management
              • Example: Restart
              • Example: Consistent View
            • Locks for Database Objects
              • Shared Lock
              • Exclusive Lock
              • Optimistic Lock
              • Phenomena
              • Parallel Locks
              • Isolation Level
          • Data Storage
            • Working Memory Areas
            • Volumes (Permanent Storage)
            • Savepoint
            • Logical Access Structures
              • B* Trees for Tables with LONG Columns
              • B* Trees for Tables with Indexes
              • Rebalancing
              • Example: SELECT Statement
              • Example: INSERT Statement
              • Example: DELETE Statement
              • Example: UPDATE Statement
            • Converter
        • Database Tools
        • Interfaces
        • Technical System Landscape
          • Network Communication
          • Architecture of the Database Tools
          • Architecture of the Interfaces
          • Data Encryption
          • Example: System Landscape with MaxDB Database Instance
          • Example: SAP System Landscape with Two MaxDB Database Instances
          • Process Structure
            • Overview of Processes
            • Overview of Services
            • Overview of Tasks
            • Overview of the Task States
            • Task Switching
            • Load Balancing
            • Overview of Special Threads
        • Creating and Configuring a Database Instance
          • Planning the Database Instance
          • Technical Restrictions
          • Template for Database Instances
          • Conventions for Database Names
          • Database Parameters
            • General Database Parameters
            • Special Database Parameters
            • Support Database Parameters
            • liveCache Database Parameters
            • Properties of Database Parameters
          • Automatic Start
            • Example: Start Script for a Database Instance (Linux)
          • Log Settings
          • Configuration Files
          • Database Design
            • Database Design Tips
        • Administration
          • Regular Administration Tasks
          • Automating Administration Tasks
            • Overview of Database Event Categories
          • Users, Authentication and Authorizations
            • Database System Administrator (SYSDBA User)
            • Database Manager Operator (DBM Operator)
            • Database User
            • Server Authorizations for the DBM Server
            • Conventions for User Names and Passwords
            • Authentication
            • Special Operating System Users and Groups (UNIX/Linux)
              • <sdb_user> (Special Operating System User)
              • <sdba_group> (Special Operating System Group)
              • Support Group (Special Operating System Group)
          • Backing Up and Restoring
            • Backup Templates and Data Carriers
              • Notes on the Different Types of Data Carriers
            • Backing Up Data
            • Backing Up Log Entries
              • Archiving Backup Files
            • Restoring the Database Instance
            • Example: Backing Up and Restoring
            • Backing Up and Restoring Data with Remote Computers
            • Using Backup Tools from Other Providers
            • Freezing the Data Area (Snapshot)
          • Exporting and Importing
          • Replication and High Availability
            • Database Copy
              • Compatible Processor Architectures for Database Copies
            • Standby Database
              • Setting Up a Standby Instance
              • Updating the Standby Instance
              • Starting the Standby Instance as an Active Instance
            • Hot Standby
              • System Requirements for a Hot Standby System
              • Architecture of a Hot Standby System
              • Synchronizing Master and Standby Instances
              • Behavior of the Hot Standby System when Errors Occur
            • Synchronization
        • Monitoring
        • Performance
          • Analyzing Performance Bottlenecks
          • Automatic Transformation of SQL Statements
          • SQL Optimizer
            • How the SQL Optimizer Operates
              • Search Conditions
                • Equality Condition
                • Range Condition
                • IN Condition
                • LIKE Condition
                • Restrictions for UPDATE Statements
              • Cost Determination
              • SQL Optimizer Statistics
              • Search Strategies
                • Sequential Search
                • Search Conditions for Key Columns
                • Search Conditions for Indexed Columns
                • Search Conditions Linked with OR
                • Postponement of the Search to the FETCH Time
                • Joins
                  • JOIN_SEARCH_LEVEL Database Parameter
                • List of All Search Strategies
                  • CATALOG KEY ACCESS
                  • CATALOG SCAN
                  • CATALOG SCAN USING USER EQUAL CONDITION
                  • DIFFERENT STRATEGIES FOR OR TERMS
                  • EQUAL CONDITION FOR INDEX
                  • EQUAL CONDITION FOR KEY
                  • IN CONDITION FOR INDEX
                  • IN CONDITION FOR KEY
                  • INDEX SCAN
                  • JOIN VIA INDEXED COLUMN
                  • JOIN VIA KEY COLUMN
                  • JOIN VIA KEY RANGE
                  • JOIN VIA MULTIPLE INDEXED COLUMNS
                  • JOIN VIA MULTIPLE°KEY°COLUMNS
                  • JOIN VIA RANGE OF MULTIPLE INDEXED COL.
                  • JOIN VIA RANGE OF MULTIPLE KEY COLUMNS
                  • NO RESULT SET POSSIBLE
                  • NO STRATEGY NOW (ONLY AT EXECUTION TIME)
                  • RANGE CONDITION FOR INDEX
                  • RANGE CONDITION FOR KEY
                  • SUBQ CONDITION FOR INDEX
                  • SUBQ CONDITION FOR KEY
                  • TABLE SCAN
            • Troubleshooting
              • EXPLAIN Statement
                • EXPLAIN Statement for Joins
                • EXPLAIN Statement for Complicated SELECT Statements
                • EXPLAIN Statement for SELECT Statements with Subqueries
                • STRATEGY Column
        • Troubleshooting
          • Typical Error Situations
          • Log Files
          • Traces
          • Checking Database Structures
            • Fixing Errors in the Data Structure
            • Example: Error in the Data Structure
        • Developing Database Applications
      • Glossary
        • A
        • Administration
        • After Image
        • Application Data
        • Architecture
        • ASCII
        • Authentication
        • Authorization
        • AUTOCOMMIT Mode
        • Automatic Log Backup
        • Automatic Start
        • Automation
        • B
        • B* Tree
        • Backint for MaxDB
        • Backup
        • Backup File
        • Backup History
        • Backup ID
        • Backup Medium
        • Backup Template
        • Backup Tool
        • Backup Type
        • Before Image
        • BLOB
        • C
        • Cache
        • Catalog Cache
        • Checkpoint
        • CLOB
        • Code Attribute
        • Column
        • Command Mode
        • Command Monitor
        • COMMIT
        • Communication Server
        • Complete Data Backup
        • Component Group
        • Configuration
        • Configuration Directory
        • Configuration File
        • Consistent View
        • Constraint
        • Control Structure
        • Converter
        • Costs
        • Critical Section
        • Cursor
        • D
        • Data Access
        • Data Area
        • Data Backup
        • Data Cache
        • Data Carrier
        • Data integrity
        • Data Record
        • Data Type
        • Data Volume
        • Data Writer
        • Database
        • Database Administrator (DBA User)
        • Database Analyzer
        • Database Application
        • Database Catalog
        • Database Connection
        • Database Copy
        • Database Design
        • Database File
        • Database Function
        • Database ID
        • Database Instance
        • Database Manager
        • Database Manager Operator (DBM Operator)
        • Database Name
        • Database Object
        • Database Parameters
        • Database Procedure
        • Database Session
        • Database Structure
        • Database System
        • Database System Administrator (SYSDBA User)
        • Database Tool
        • Database Trace
        • Database User
        • DBA
        • DBA Planning Calendar
        • DBADMIN
        • DBM Command
        • DBM Operator
        • DBM Operator Properties
        • DBM Option
        • DBM Server
        • DBMCLI
        • DBMGUI
        • DDL Statement
        • Default Parameter File
        • Demo Database
        • Development
        • Directory Structure
        • Documentation
        • Variables in the Documentation
        • Domain
        • Download
        • E
        • Encryption
        • Environment Variable
        • Error Message
        • Event
        • Event Dispatcher
        • Example
        • Exclusive Lock
        • Execution Plan
        • EXPLAIN Statement
        • Exporting
        • External Backup Tool
        • F
        • FBM (Free Block Management)
        • File Class
        • File Directory
        • File ID
        • Foreign Key
        • G
        • Garbage Collector
        • H
        • High Availability
        • History File
        • Hit Rate
        • Homogenous System Copy
        • Hot Standby
        • I
        • I/O Buffer Cache
        • Importing
        • Incremental Data Backup
        • Index
        • Indexed Column
        • Initialization
        • Installation
        • Installation Manager
        • Installation Profile
        • Interactive Log Backup
        • Interface
        • Internal Database Files
        • Inversion List
        • Inverted Column
        • Isolation Level
        • J
        • Java
        • JDBC
        • Join
        • K
        • Kernel
        • Kernel Log
        • Kernel Variant
        • Keyword
        • KNLDIAG
        • L
        • Language Support (MapChar Sets)
        • Leaf Page
        • liveCache (SAP liveCache Technology)
        • Load Balancing
        • Loader
        • Loader Server
        • Loading
        • LOB
        • Lock
        • Lock List
        • Log Area
        • Log Backup
        • Log Entry
        • Log File
        • Log Mode
        • Log Page
        • Log Queue
        • Log Reader
        • Log Segment
        • Log Setting
        • Log Volume
        • Log Writer
        • Logging
        • LONG Value
        • M
        • Mailing List
        • Mapchar Set
        • Master Instance
        • MaxDB
        • Merge
        • Message Server
        • Migration
        • Monitoring
        • Multi-Processor Configuration
        • N
        • Naming Conventions
        • Network
        • O
        • ODBC
        • OLTP (MaxDB)
        • OMS
        • OMS heap
        • OMS Version
        • Open Source Development
        • Operating System User
        • Operating Mode
        • Operational State
        • Optimistic Lock
        • Optimizer
        • Overwrite Mode for the Log Area
        • Owner
        • P
        • Page
        • Page Chain
        • Pager
        • Parallel Backup
        • Parameter
        • Parameter File
        • Parameters in SQL Statements
        • Performance
        • Perl
        • PHP
        • Port
        • Precompiler
        • Predicate
        • Prepared Statement
        • Primary Key
        • Privilege
        • Process
        • Programming Interface
        • PTS (Problem Tracking System)
        • Python
        • Q
        • Query Tool
        • R
        • Raw Device
        • Reader-Writer Lock
        • Redo List
        • Redo Log Entry
        • Redo Log File
        • Redo Log Management
        • Redo Log Manager
        • Redo Task
        • Region
        • Reorganization
        • Replication
        • Replication Table
        • Replication Unit
        • Reserved Word
        • RESOURCE User
        • Resource Monitor
        • Restart
        • Restart Information
        • Restoring
        • Restriction
        • Role
        • ROLL FORWARD
        • ROLLBACK
        • Row
        • Run Directory
        • S
        • SAP DB
        • Savepoint
        • Scheduler
        • Schema
        • Script Mode
        • sdb
        • sdba
        • Search Strategy
        • Secondary Key
        • Selectivity
        • Separator
        • Sequence
        • Sequence Cache
        • Server Authorization
        • Server Task
        • Service
        • Service Database Instance
        • Service Session
        • Session Mode
        • Shared Lock
        • Shared Memory
        • Shared SQL
        • Snapshot
        • Software Component
        • Special Thread
        • SQL
        • SQL Mode
        • SQL Optimizer
        • SQL Session
        • SQL Statement
        • SQL Studio
        • SQL Tutorial
        • SQLCLI
        • SQLDBC
        • SSL/TLS
        • STANDARD User
        • Standby Database
        • Standby Instance
        • Start
        • Statistics
        • Stored Procedure
        • Strategy
        • Subtransaction
        • Support
        • Synchronization
        • Synchronization Manager
        • Synchronization User
        • Synonym
        • Syntax Notation
        • SYSDBA User
        • System Breakdown
        • System Copy
        • System Requirements
        • System Table
        • System Trigger
        • T
        • Table
        • Table ID
        • Table Name
        • Task
        • Task State
        • Template for a Database Instance
        • Thread
        • Timeout
        • Timer Task
        • Tool
        • Trace
        • Trace Writer Task
        • Transaction
        • Transaction File
        • Transaction List
        • Triggers
        • Troubleshooting
        • Tutorial
        • U
        • Undo Log Entry
        • Undo Log File
        • Unicode
        • Unloading
        • Update
        • Upgrade
        • User
        • User Group
        • User Kernel Thread
        • User Key
        • User Task
        • User-Defined Function
        • Utility Task
        • V
        • Variable
        • Version
        • View
        • View Table
        • Virtual Computer
        • VMAKE
        • Volume
        • vserver
        • vtrace
        • W
        • Web DBM
        • Web Server
        • Web Server Manager
        • Web SQL
        • Web Tool
        • WebDAV
        • Working Memory
        • X
        • X Server
        • XCONS (Database Console)
        • XUSER
        • Y
        • Z
        • Deutsche Sortierung - Glossar
      • SQL Reference Manual
        • Data definition
          • Ensuring Data Integrity
          • CREATE TABLE Statement (create_table_statement)
            • Column Definition (column_definition)
              • Data Type (data_type)
                • CHAR[ACTER]
                • VARCHAR
                • LONG[VARCHAR]
                • Code Attribute
                • BOOLEAN
                • FIXED
                • FLOAT
                • INT[EGER]
                • SMALLINT
                • DATE (Date Value)
                • TIME (Time Value)
                • TIMESTAMP (Time Stamp Value)
                • NULL Value
                • Special NULL value
                • Number
                • Character String
              • Column Attributes (column_attributes)
              • Memory Requirements of a Column Value According to Data Type
            • CONSTRAINT Definition (constraint_definition)
            • Referential CONSTRAINT Definition (referential_constraint_defini
            • Key definition
            • UNIQUE Definition (unique_definition)
          • DROP TABLE statement
          • ALTER TABLE Statement (alter_table_statement)
            • ADD Definition (add_definition)
            • ALTER Definition (alter_definition)
            • COLUMN Change Definition (column_change_definition)
            • DROP definition
            • MODIFY Definition (modify_definition)
          • RENAME TABLE statement
          • RENAME COLUMN Statement (rename_column_statement)
          • EXISTS TABLE Statement (exists_table_statement)
          • CREATE SCHEMA Statement (create_schema_statement)
          • RENAME SCHEMA Statement (rename_schema_statement)
          • DROP SCHEMA Statement (drop_schema_statement)
          • CREATE DOMAIN Statement (create_domain_statement)
          • DROP DOMAIN Statement (drop_domain_statement)
          • CREATE SEQUENCE Statement (create_sequence_statement)
          • DROP SEQUENCE statement)
          • CREATE SYNONYM Statement (create_synonym_statement)
          • DROP SYNONYM Statement (drop_synonym_statement)
          • RENAME SYNONYM Statement (rename_synonym_statement)
          • CREATE VIEW Statement (create_view_statement)
            • INSERT/UPDATE/DELETE Privilege for Owners of View Tables
            • Updateable Join View Table
          • DROP VIEW Statement (drop_view_statement)
          • RENAME VIEW Statement (rename_view_statement)
          • CREATE INDEX Statement (create_index_statement)
          • DROP INDEX statement
          • ALTER INDEX Statement (alter_index_statement)
          • RENAME INDEX Statement (rename_index_statement)
          • CREATE DBPROC[EDURE] Statement (create_dbproc_statement)
            • Routine (routine)
            • General CASE Statement (searched_case_statement)
            • Simple CASE Statement (simple_case_statement)
          • DROP DBPROC[EDURE] Statement (drop_dbproc_statement)
          • CREATE SYSTEM TRIGGER Statement (create_system_trigger_statement
          • DROP SYSTEM TRIGGER Statement (drop_system_trigger_statement)
          • CREATE FUNCTION Statement (create_function_statement)
          • DROP FUNCTION Statement (drop_function_statement)
          • CREATE TRIGGER Statement (create_trigger_statement)
          • DROP TRIGGER statement
          • COMMENT ON Statement (comment_on_statement)
        • Authorization
          • CREATE USER Statement (create_user_statement)
          • CREATE USERGROUP Statement (create_usergroup_statement)
          • DROP USER Statement (drop_user_statement)
          • DROP USERGROUP Statement (drop_usergroup_statement)
          • ALTER USER Statement (alter_user_statement)
          • ALTER USER GROUP Statement (alter_usergroup_statement)
          • RENAME USER statement
          • RENAME USERGROUP Statement (rename_usergroup_statement)
          • GRANT USER Statement (grant_user_statement)
          • GRANT USERGROUP Statement (grant_usergroup_statement)
          • ALTER PASSWORD Statement
          • CREATE ROLE statement
          • DROP ROLE statement
          • GRANT Statement
          • REVOKE Statement (revoke_statement)
        • Data Manipulation
          • INSERT Statement (insert_statement)
            • Data Type of the Target Column and Inserted Value
            • Join View Table, QUERY Expression, CONSTRAINT Definition, Trigge
          • UPDATE Statement (update_statement)
          • DELETE Statement (delete_statement)
          • NEXT STAMP Statement (next_stamp_statement)
          • CALL statement
        • Data query
          • QUERY Statement (query_statement)
            • DECLARE CURSOR statement (declare_cursor_statement)
            • Recursive DECLARE CURSOR Statement
            • SELECT Statement (select_statement)
            • QUERY Expression (query_expression)
            • Table Expression (table_expression)
            • Subquery (subquery)
            • ORDER Clause (order_clause)
            • UPDATE Clause (update_clause)
            • LOCK Option (lock_option)
          • FETCH Statement (fetch_statement)
          • CLOSE Statement (close_statement)
          • SINGLE SELECT statement (single_select_statement)
          • EXPLAIN Statement (explain_statement)
        • Transactions
          • CONNECT Statement (connect_statement)
          • SET Statement (set_statement)
          • COMMIT Statement (commit_statement)
          • ROLLBACK Statement (rollback_statement)
          • SUBTRANS Statement (subtrans_statement)
          • INNER TRANSACTION Statement (inner_transaction_statement)
          • SQL SAVEPOINT Statements (savepoint/rollback_to_/release_savepoi
          • LOCK Statement (lock_statement)
          • UNLOCK Statement (unlock_statement)
          • RELEASE Statement (release_statement)
        • Statistics
          • UPDATE STATISTICS Statement (update_statistics_statement)
          • MONITOR statement
        • SQL Statements: Overview
          • Comment (sql_comment)
        • Frequently Used Syntax Elements: Overview
          • CASCADE Option (cascade_option)
          • Character
          • Column Specification (column spec)
          • DEFAULT Specification (default_spec)
          • DELETE Rule (delete_rule)
          • DISTINCT function (distinct spec)
          • DUPLICATES Clause (duplicates_clause)
          • Expression
          • Specifications of Values (extended_value_spec)
          • Function (function spec)
            • Arithmetic Function (arithmetic_function)
              • ABS(a)
              • CEIL(a)
              • EXP(a)
              • FIXED(a,p,s)
              • FLOAT(a,s)
              • FLOOR(a)
              • INDEX(a,b,p,s)
              • LENGTH(a)
              • LN(a)
              • LOG(a,b)
              • NOROUND(a)
              • PI
              • POWER(a,n)
              • ROUND(a,n)
              • SIGN(a)
              • SQRT(a)
              • TRUNC(a,n)
            • Conversion Function (conversion_function)
              • CHAR(a,t)
              • CHR(a,n)
              • HEX(a)
              • HEXTORAW(a)
              • NUM(a)
              • Date and Time Format (datetimeformat)
            • Date function
              • ADDDATE/SUBDATE(t,a)
              • DATEDIFF(t,s)
              • DAYNAME/MONTHNAME(t)
              • DAYOFWEEK/WEEKOFYEAR/DAYOFMONTH/DAYOFYEAR(t)
              • MAKEDATE(a,b)
            • Database Function Call (dbfunction_call)
            • Extraction function
              • DATE(a)
              • HOUR/MINUTE/SECOND(t)
              • MICROSECOND(a)
              • TIME(a)
              • TIMESTAMP(a,b)
              • YEAR/MONTH/DAY(t)
            • Special Function (special_function)
              • DECODE(x,y(i),...,z)
              • GREATEST/LEAST(x,y,...)
              • VALUE(x,y,...)
              • General CASE Function (searched_case_function)
              • Simple CASE Function (simple_case_function)
            • String Function (string_function)
              • ALPHA(x,n)
              • ASCII(x)
              • EXPAND(x,n)
              • GET_OBJECTNAME(x,o)
              • GET_SCHEMA(x,o)
              • INITCAP(x)
              • LFILL(x,a,n)
              • LPAD(x,a,y,n)
              • LTRIM(x,y)
              • MAPCHAR(x,n,i)
              • REPLACE(x,y,z)
              • RFILL(x,a,n)
              • RPAD(x,a,y,n)
              • RTRIM(x,y)
              • SOUNDEX(x)
              • SUBSTR(x,a,b)
              • TRANSLATE(x,y,z)
              • TRIM(x,y)
              • UPPER/LOWER(x)
              • Concatenation
            • Time Function (time_function)
              • ADDTIME/SUBTIME(t,a)
              • MAKETIME(h,m,s)
              • TIMEDIFF(t,s)
            • Trigonometric Function (trigonometric_function)
          • Joined Table (joined_table)
          • Key Specification (key_spec)
          • Literal
            • Fixed Point Number (fixed_point_literal)
            • Floating Point Number (floating_point_literal)
            • Unsigned integer (unsigned_integer)
            • Integer
          • Parameter Specification (parameter spec)
          • Predicate
            • BETWEEN predicate
            • Boolean Predicate (bool_predicate)
            • Comparison Predicate (comparison_predicate)
            • DEFAULT Predicate (default predicate)
            • EXISTS predicate
            • IN predicate
            • JOIN Predicate (join_predicate)
            • LIKE Predicate (like_predicate)
            • NULL predicate
            • Quantified predicate
            • ROWNO Predicate (rowno_predicate)
            • SOUNDS Predicate (sounds_predicate)
          • SAMPLE Definition (sample_definition)
          • Search Condition (search_condition)
          • Selected Column (select_column)
          • Set Function (set_function_spec)
          • Character Set (token)
            • Identifier
            • Keyword (key_word)
        • Functions: Overview
        • Names: Overview
          • Alias Name (alias_name)
          • Column Name (column_name)
          • Constraint Name (constraint_name)
          • Name of a Database Function (dbfunction_name)
          • Name of a database procedure (dbproc_name)
          • Domain Name (domain_name)
          • Index Name (index_name)
          • Indicator Name (indicator_name)
          • MapChar Set Name (mapchar_set_name)
          • Password
          • Parameter Name (parameter_name)
          • Reference Name (reference_name)
          • Name of a Referential Constraint (referential_constraint_name)
          • Results Table Name (result_table_name)
          • Role Name (role_name)
          • Schema Name (schema_name)
          • Sequence Name (sequence_name)
          • Synonym Name (synonym_name)
          • Table Name (table_name)
          • Trigger Name (trigger_name)
          • User Group Name (usergroup_name)
          • User Name (user_name)
        • Privileges: Overview
          • Privilege Specification (priv_spec)
          • Privilege Specification for a Schema (schema_priv_spec)
        • Syntax List
          • add_definition
          • alias_name
          • all_function
          • alter_definition
          • alter_index_statement
          • alter_password_statement
          • alter_table_statement
          • alter_user_statement
          • alter_usergroup_statement
          • argument
          • argument1
          • arithmetic_function
          • ASCII_or_UNICODE
          • assignment_statement
          • between_predicate
          • bool_predicate
          • boolean_factor
          • boolean_term
          • call_statement
          • cascade_option
          • case_else_clause
          • case_function
          • case_statement
          • character
          • check_expression
          • close_statement
          • column_attributes
          • column_change_definition
          • column_definition
          • column_list
          • column_name
          • column_spec
          • comment
          • comment_on_statement
          • commit_statement
          • comp_op
          • comparison_predicate
          • connect_mode
          • connect_option
          • connect_statement
          • constraint_definition
          • constraint_name
          • conversion_function
          • create_dbproc_statement
          • create_domain_statement
          • create_function_statement
          • create_index_statement
          • create_role_statement
          • create_schema_statement
          • create_sequence_statement
          • create_synonym_statement
          • create_system_trigger_statement
          • create_table_statement
          • create_table_temp
          • create_trigger_statement
          • create_user_statement
          • create_usergroup_statement
          • create_view_statement
          • data_type
          • date_function
          • date_or_timestamp_expression
          • datetimeformat
          • dbfunction_call
          • dbfunction_name
          • dbproc_name
          • declare_cursor_statement
          • default_expression
          • default_predicate
          • default_spec
          • delete_rule
          • delete_statement
          • delimiter_token
          • derived_column
          • digit
          • digit_sequence
          • distinct_function
          • distinct_spec
          • domain_name
          • double_quotes
          • drop_dbproc_statement
          • drop_definition
          • drop_domain_statement
          • drop_function_statement
          • drop_index_statement
          • drop_role_statement
          • drop_schema_statement
          • drop_sequence_statement
          • drop_synonym_statement
          • drop_system_trigger_statement
          • drop_table_statement
          • drop_table_temp
          • drop_trigger_statement
          • drop_user_statement
          • drop_usergroup_statement
          • drop_view_statement
          • duplicates_clause
          • equal_or_not
          • exists_predicate
          • exists_table_statement
          • explain_statement
          • exponent
          • expression
          • expression_list
          • extended_expression
          • extended_letter
          • extended_value_spec
          • extraction_function
          • factor
          • fetch_statement
          • final_select
          • first_character
          • first_password_character
          • fixed_point_literal
          • floating_point_literal
          • formal_parameter
          • formal_parameter1
          • from_clause
          • from_table_spec
          • function_spec
          • grant_statement
          • grant_user_statement
          • grant_usergroup_statement
          • granted_usergroups
          • granted_users
          • grantee
          • group_clause
          • having_clause
          • hex_digit
          • hex_digit_seq
          • hex_literal
          • hours
          • identifier
          • identifier_tail_character
          • if_statement
          • in_predicate
          • index_column_name
          • index_name
          • index_spec
          • indicator_name
          • initial_select
          • inner_transaction_statement
          • insert_expression
          • insert_statement
          • integer
          • INTERNAL_ANSI_DB2_ORACLE
          • join_predicate
          • join_spec
          • joined_table
          • key_definition
          • key_or_not_null_spec
          • key_spec
          • key_word
          • language_specific_character
          • letter
          • like_expression
          • like_predicate
          • limit_clause
          • literal
          • local_variable
          • local_variable_list
          • local_variables
          • lock_option
          • lock_spec
          • lock_statement
          • mantissa
          • mapchar_set_name
          • match_char
          • match_set
          • match_string
          • minutes
          • modify_column_definition
          • modify_definition
          • monitor_statement
          • new_index_name
          • new_password
          • new_schema_name
          • new_synonym_name
          • new_table_name
          • new_user_name
          • new_usergroup_name
          • next_stamp_statement
          • not_reserved_key_word
          • null_predicate
          • numeric_literal
          • object_spec
          • offset
          • old_index_name
          • old_password
          • old_synonym_name
          • old_table_name
          • order_clause
          • outer_join_indicator
          • parameter_name
          • parameter_spec
          • password
          • pattern_element
          • position
          • predicate
          • priv_spec
          • privilege
          • quantified_predicate
          • quantifier
          • query_expression
          • query_primary
          • query_spec
          • query_statement
          • query_term
          • recursive_declare_cursor_statement
          • recursive_select
          • reference_name
          • referenced_column
          • referenced_table
          • referencing_column
          • referential_constraint_definition
          • referential_constraint_name
          • regular_token
          • release_savepoint_statement
          • release_statement
          • rename_column_statement
          • rename_index_statement
          • rename_schema_statement
          • rename_synonym_statement
          • rename_table_statement
          • rename_user_statement
          • rename_usergroup_statement
          • rename_view_statement
          • reserved_key_word
          • result_column_name
          • result_expression
          • result_table_name
          • revoke_statement
          • role_name
          • rollback_statement
          • rollback_to_statement
          • routine
          • routine_sql_statement
          • row_count
          • row_spec
          • rowno_column
          • rowno_predicate
          • sample_definition
          • savepoint_statement
          • scalar_subquery
          • schema_authorization_identifier
          • schema_element
          • schema_name
          • schema_name_clause
          • schema_priv_spec
          • schema_privilege
          • search_and_result_spec
          • search_condition
          • search_expression
          • searched_case_function
          • searched_case_statement
          • searched_case_when_clause
          • seconds
          • select_column
          • select_statement
          • sequence_name
          • set_function_name
          • set_function_spec
          • set_insert_clause
          • set_statement
          • set_update_clause
          • sign
          • simple_case_function
          • simple_case_statement
          • simple_case_when_clause
          • simple_identifier
          • single_select_statement
          • sort_spec
          • sound_predicate
          • source_user
          • special_character
          • special_function
          • special_identifier
          • special_identifier_character
          • sql_comment
          • sql_comment_text
          • sql_savepoint_name
          • sql_statement
          • stamp_column
          • statement
          • statement_list
          • string_function
          • string_literal
          • string_spec
          • subquery
          • subtrans_statement
          • synonym_name
          • table_columns
          • table_description_element
          • table_expression
          • table_name
          • term
          • time_expression
          • time_or_timestamp_expression
          • time_function
          • token
          • top_spec
          • trigger_event
          • trigger_name
          • trigonometric_function
          • underscore
          • unique_definition
          • unlock_statement
          • unsigned_integer
          • update_clause
          • update_statement
          • update_statistics_statement
          • user_mode
          • user_name
          • usergroup_mode
          • usergroup_name
          • value_spec
          • variable_name
          • vertical_slash
          • where_clause
          • while_statement
          • Syntax Notation
          • Syntax Changes
        • System Tables
          • General Notes
          • Database Terms
          • Evaluating System Tables (Examples)
            • ACTIVECONFIGURATION
            • CACHESTATISTICS
            • COLUMNS
            • CONSTRAINTS
            • DATASTATISTICS
            • DATAVOLUMES
            • DBPROCEDURES
            • DBPROCPARAMS
            • DOMAINCONSTRAINTS
            • DOMAINS
            • FOREIGNKEYCOLUMNS
            • FOREIGNKEYS
            • FUNCTIONS
            • INDEXCOLUMNS
            • INDEXES
            • INSTANCE
            • LOCKS
            • LOGQUEUESTATISTICS
            • LOGSTATISTICS
            • MAPCHARSETS
            • ROLEPRIVILEGES
            • ROLES
            • SEQUENCES
            • SESSION_ROLES
            • SESSIONS
            • SYNONYMS
            • TABLEPRIVILEGES
            • TABLES
            • TRIGGERS
            • USERS
            • VERSION
            • VIEWCOLUMNS
            • VIEWDEFS
            • VIEWS
          • Definitions of the System Tables
            • ACTIVECONFIGURATION
            • BACKUPTHREADS
            • CACHESTATISTICS
            • CATALOGCACHESTATISTICS
            • CLASSCONTAINER_CHAINS
            • CLASSCONTAINER_KEYS
            • CLASSCONTAINER_ROOTS
            • CLASSCONTAINERS
            • CODEPAGE
            • COLUMNS
            • COMMANDCACHESTATISTICS
            • COMMANDCACHESTATISTICSRESET
            • COMMANDSTATISTICS
            • COMMANDSTATISTICSRESET
            • CONNECTEDUSERS
            • CONNECTPARAMETERS
            • CONSISTENTVIEWS
            • CONSTRAINTCOLUMNS
            • CONSTRAINTS
            • DATACACHE
            • DATASTATISTICS
            • DATASTATISTICSRESET
            • DATAVOLUMES
            • DBPARAMETERS
            • DBPROCEDURES
            • DBPROCPARAMS
            • DOMAINCONSTRAINTS
            • DOMAINS
            • FILEDIRECTORIES
            • FILES
            • FOREIGNKEYCOLUMNS
            • FOREIGNKEYS
            • FUNCTIONS
            • GARBAGECOLLECTOR_STATISTICS
            • HISTORYINFO
            • HOTSTANDBYCOMPONENT
            • HOTSTANDBYGROUP
            • INDEXCOLUMNS
            • INDEXES
            • INDEXSIZE
            • INDEXSTATISTICS
            • INDEXSTORAGEDETAILS
            • INSTANCE
            • IOBUFFERCACHES
            • IOTHREADSTATISTICS
            • IOTHREADSTATISTICSRESET
            • LOCKLISTSTATISTICS
            • LOCKS
            • LOCK_WAITS
            • LOGINFORMATION
            • LOGQUEUESTATISTICS
            • LOGQUEUESTATISTICSRESET
            • LOGSTATISTICS
            • LOGSTATISTICSRESET
            • LOGVOLUMES
            • MACHINECONFIGURATION
            • MACHINEUTILIZATION
            • MAPCHARSETS
            • MEMORYALLOCATORSTATISTICS
            • MONITOR
            • MONITOR_CACHES
            • MONITOR_LOAD
            • MONITOR_LOCK
            • MONITOR_LOG
            • MONITOR_LONG
            • MONITOR_OMS
            • MONITOR_PAGES
            • MONITOR_REWRITE
            • MONITOR_ROW
            • MONITOR_TRANS
            • OBJECTLOCKS
            • OMS_HEAP_STATISTICS
            • OMS_LOCKOBJ_INFO
            • OMSLOCKS
            • OMS_VERSIONS
            • OPTIMIZERINFORMATION
            • OPTIMIZERSTATISTICS
            • PACKAGES
            • POSTUPGRADECHECKLIST
            • READERWRITERLOCKINFORMATION
            • READERWRITERLOCKSTATISTICS
            • READERWRITERLOCKSTATISTICSRESET
            • READERWRITERLOCKWAITINGTASKS
            • REGIONINFORMATION
            • REGIONSTATISTICS
            • REGIONSTATISTICSRESET
            • RESTARTINFORMATION
            • ROLEPRIVILEGES
            • ROLES
            • SCHEMAPRIVILEGES
            • SCHEMAS
            • SCHEMASIZE
            • SEQUENCEPRIVILEGES
            • SEQUENCES
            • SERVERDBSTATISTICS
            • SERVERTASKS
            • SESSION_ROLES
            • SESSIONS
            • SNAPSHOTS
            • SPINLOCKPOOLSTATISTICS
            • SPINLOCKPOOLSTATISTICSRESET
            • SPINLOCKSTATISTICS
            • SPINLOCKSTATISTICSRESET
            • SYNONYMS
            • SYSTEMTRIGGERS
            • SYSUPDATECOUNTERWANTED
            • SYSUPDSTATWANTED
            • SYSUPGRADEHISTORY
            • TABLEPRIVILEGES
            • TABLES
            • TABLESIZE
            • TABLESTATISTICS
            • TABLESTORAGEDETAILS
            • TASKGROUPSTATISTICS
            • TASKGROUPSTATISTICSRESET
            • TASKLOADBALANCINGINFORMATION
            • TASKLOADBALANCINGTASKGROUPSTATES
            • TASKLOADBALANCINGTASKMOVES
            • TRANSACTIONHISTORY
            • TRANSACTIONS
            • TRANSACTIONS
            • TRANSFORMATIONMODEL
            • TRANSFORMATIONMONITOR
            • TRANSFORMATIONPACKAGES
            • TRANSFORMATIONRESOURCES
            • TRANSFORMATIONSTATISTICS
            • TRANSFORMATIONSTEPS
            • TRIGGERS
            • UNLOADEDSTATEMENTS
            • USERS
            • USERSTATISTICS
            • VERSION
            • VERSIONS
            • VIEWCOLUMNS
            • VIEWDEFS
            • VIEWS
            • VIEWTABLES
        • Restrictions for SQL Statements
        • ORACLE SQL Mode
          • SQL Syntax Elements
            • Database Object
            • Name
            • Namespace
            • Access to Objects
            • Integer (whole number)
            • Number
            • Data Type
            • Pseudo Column
            • Operator
            • Function
            • Format
          • SQL Statements
            • alter_cluster_statement
            • alter_database_statement
            • alter_function_statement
            • alter_index_statement
            • alter_package_statement
            • alter_procedure_statement
            • alter_profile_statement
            • alter_resource_cost_statement
            • alter_role_statement
            • alter_rollback_segment_statement
            • alter_sequence_statement
            • alter_snapshot_statement
            • alter_snapshot_log_statement
            • alter_system_statement
            • alter_table_statement
            • alter_tablespace_statement
            • alter_trigger_statement
            • alter_user_statement
            • alter_view_statement
            • analyze_statement
            • audit_statement
            • commit_statement
            • constraint_clause
            • create_cluster_statement
            • create_controlfile_statement
            • create_database_statement
            • create_database_link_statement
            • create_index_statement
            • create_package_statement
            • create_package_body_statement
            • create_procedure_statement
            • create_profile_statement
            • create_rollback_segment_statement
            • create_sequence_statement
            • create_snapshot_statement
            • create_snapshot_log_statement
            • create_synonym_statement
            • create_table_statement
            • create_tablespace_statement
            • create_trigger_statement
            • create_user_statement
            • create_view_statement
            • declare_statement
            • declare_table_statement
            • delete_statement
            • describe_statement
            • drop_cluster_statement
            • drop_database_link_statement
            • drop_index_statement
            • drop_procedure_statement
            • drop_profile_statement
            • drop_rollback_segment_statement
            • drop_snapshot_statement
            • drop_snapshot_log_statement
            • drop_table_statement
            • drop_tablespace_statement
            • drop_trigger_statement
            • drop_view_statement
            • execute_statement
            • explain_plan_statement
            • grant_statement
            • insert_statement (embedded SQL)
            • lock_table_statement
            • noaudit_statement
            • rename_statement
            • revoke_statement
            • rollback_statement
            • select_statement
            • set_transaction_statement
            • truncate_statement
            • update_statement
          • System Tables
          • Error Messages
      • Messages
        • Number ranges
        • From -1 to -699
          • -1: Duplicate key in index
          • -8: Execution failed, parse again
          • -20: Duplicate key
          • -25: Duplicate secondary key
          • -30: Integrity violation
          • -32: View violation
          • -35: Referential integrity violated
          • -36: Foreign key integrity violation
          • -40: Lock collision
          • -50: Lock request timeout
          • -51: Lock request timeout
          • -54: Lock collision
          • -60: Work rolled back
          • -65: Work rolled back
          • -70: Session inactivity timeout (Work rolled back)
          • -71: Session terminated by shutdown (Work rolled back)
          • -75: Too many SQL statements (Work rolled back)
          • -101: SQL statement not available in this DB mode
          • -102: SQL statement canceled
          • -103: SQL statement not available for this application
          • -104: DBM command impossible at this time
          • -106: Table unloaded or content deleted
          • -107: SQL statement not allowed for this instance
          • -108: Table or index dropped or content deleted
          • -111: Incompatible incremental backup
          • -115: Table is read only
          • -123: No more log to save
          • -126: Data backup missing (backup history lost)
          • -127: Log backup is not possible because log writing has been sw
          • -128: Log backup is not possible because the log overwrite mode
          • -530: Referential integrity violated
          • -602: System error
        • From -900 to -999
          • -900: Data area full
          • -901: Log full
          • -902: I/O error
          • -903: Hostfile I/O error
          • -904: Space for result tables exhausted
          • -907: Space for user session exhausted
          • -910: COSTLIMIT for this user exhausted
          • -911: Work rolled back
          • -913: Lock request timeout
          • -914: New volume not accessible
          • -915: No more memory
          • -917: Save/restore write process crash - I/O error
          • -918: Stack overflow
          • -942: Unknown table name
          • -955: Duplicate name
        • From -1000 to -1999
          • -1000: Too many lock requests
          • -1001: Too many lock objects specified
          • -1002: Too many columns
          • -1003: Too many buffers requested
          • -1004: Too many correlated columns
          • -1005: Too many monadic operators
          • -1006: Too many variables
          • -1007: Parameter list too long
          • -1008: Too many or too few host variables for output
          • -1009: Too many named indexes for this table
          • -1010: Too many volumes
          • -1011: Too many correlated tables
          • -1012: Too many referential constraint definitions for this tabl
          • -1013: Too many order columns
          • -1014: Too many source tables
          • -1015: Too many values
          • -1017: Too many joins
          • -1023: Too many nested subtransactions
          • -1025: Too many asynchron requests
          • -1026: Too many differences between old and new view definition
          • -1102: Too complicated SQL statement (Too many subqueries)
          • -1103: Too complicated SQL statement
          • -1104: Too complicated SQL statement (KB-stack overflow)
          • -1105: Too complicated SQL statement (Too much data)
          • -1106: Too complicated SQL statement (Too much strategy data)
          • -1107: Too complicated SQL statement (Too many internal commands
          • -1108: Too complicated SQL statement (correlated row too long)
          • -1110: View definition too long
          • -1111: Too many savepoints
          • -1112: Constraint too complicated
          • -1113: Too many nested function calls
          • -1114: Communication packet too small
          • -1115: Too many intern columns
          • -1116: Too long trigger parameters
          • -1117: Too complicated trigger qualification
          • -1119: Too many constraints for this table
          • -1120: Too many statements in definition
          • -1200: Too few values
          • -1201: Too few columns
          • -1400: Input parameter cannot be NULL value
          • -1402: Integrity violation
          • -1403: Row not found
          • -1405: Missing indicator variable, output parameter with NULL va
          • -1406: Output value truncated
          • -1452: Duplicate secondary key
          • -1556: Data space full
          • -1755: SQL statement will drop further objects (use CASCADE)
        • From -2000 to -2999
          • -2000: Row too long
          • -2001: Key too long
          • -2002: One output column too long
          • -2003: Output columns too long
          • -2004: Numeric constant too long
          • -2008: Data area too small
          • -2009: Join columns too long
          • -2010: Assignment impossible, char value too long
          • -2012: View column list too long
          • -2013: Select column list too long
          • -2014: Identifier too long
          • -2020: Data buffer too small
          • -2025: Invalid number of backup devices
          • -2027: Space for converted value too small
          • -2028: Sequence <sequence name> exhausted
          • -2029: <sequence_name>.CURRVAL is not yet defined in this sessio
        • From -3000 to -3999
          • -3000: Invalid host file content
          • -3002: Invalid datatype
          • -3003: Invalid user name
          • -3004: Invalid host file sequence
          • -3005: Invalid SQL statement
          • -3007: Invalid sequence for DML and DDL statements
          • -3008: Invalid keyword or missing delimiter
          • -3009: Invalid table name
          • -3011: Invalid column name
          • -3014: Invalid end of SQL statement
          • -3016: Invalid numeric constant
          • -3017: Invalid unsigned integer
          • -3018: Invalid numeric parameter
          • -3019: Invalid exponent
          • -3020: Invalid length for this data type
          • -3021: Invalid mixture of functions and columns
          • -3022: Invalid number of tables for outer join
          • -3024: Invalid numeric expression
          • -3030: Invalid SESSION TIMEOUT
          • -3035: Invalid date time format
          • -3037: Invalid volume name
          • -3038: Invalid volume size
          • -3046: Invalid char position in string function
          • -3047: Invalid table for RESTORE CATALOG
          • -3048: Invalid date format
          • -3049: Invalid time format
          • -3050: Invalid timestamp format
          • -3054: Invalid block size
          • -3059: Invalid day of week
          • -3060: Invalid escape sequence
          • -3061: Invalid escape value
          • -3062: Invalid month
          • -3063: Invalid format code
          • -3064: Date input value out of range
          • -3065: Invalid date input value
          • -3066: Date input value inconsistent
          • -3067: Invalid timezone
          • -3068: Mismatch of parameter configuration between backup and in
          • -3069: Bad xparam page in backup
          • -3102: Invalid subtrans structure
          • -3103: Invalid sequence definition
          • -3995: Invalid pattern
          • -3998: Wrong password
          • -3999: Invalid parameter
        • From -4000 to -4999
          • -4000: Unknown result table
          • -4001: Unknown user name/password combination in operational sta
          • -4002: Unknown password
          • -4003: Unknown user name
          • -4004: Unknown table name
          • -4005: Unknown column name
          • -4006: Unknown domain name
          • -4007: Unknown synonym name
          • -4008: Unknown user name/password combination
          • -4009: Unknown referential constraint name
          • -4010: Unknown MAPCHAR SET name
          • -4011: Unknown index name
          • -4013: Unknown user group name
          • -4014: Unknown SERVERDB name
          • -4016: Unknown procedure name
          • -4017: Unknown constraint
          • -4018: Unknown default
          • -4019: Unknown trigger name
          • -4020: Unknown sequence name
          • -4023: Unknown function name
          • -4024: Unknown name
          • -4025: Unknown or not loaded character set
          • -4027: Unknown session
          • -4030: Unknown schema
        • From -5000 to -5999
          • -5001: Missing privilege
          • -5003: Missing key specification
          • -5004: Missing constant
          • -5005: Missing non-NULL value
          • -5006: Missing identifier
          • -5007: Missing numeric constant
          • -5008: Missing string constant
          • -5009: Missing integer
          • -5010: Missing value specification
          • -5012: Missing definite table name
          • -5013: Missing update column
          • -5014: Missing definite column name
          • -5015: Missing keyword
          • -5016: Missing delimiter
        • From -6000 to -6999
          • -6000: Duplicate table name
          • -6001: Duplicate column name
          • -6002: Duplicate privilege
          • -6003: Duplicate result table name
          • -6006: Duplicate name
          • -6008: Duplicate index name
          • -6009: Duplicate reference name
          • -6011: Duplicate constraint
          • -6012: Duplicate default
          • -6013: Duplicate trigger definition
          • -6014: Duplicate value
          • -6016: Duplicate format code
        • From -7000 to -7999
          • -7002: KEY not allowed
          • -7003: NOT NULL not allowed
          • -7004: DEFAULT not allowed
          • -7005: Lower bound greater than upper bound not allowed
          • -7006: Reserved identifier not allowed
          • -7007: Key column not allowed
          • -7008: Updates of this table not allowed
          • -7009: NULL value in key column not allowed
          • -7011: Correlated subquery not allowed
          • -7012: More than one update row not allowed
          • -7015: More than one result row not allowed
          • -7016: Parameter spec not allowed in this context
          • -7017: User not allowed
          • -7018: Variable not allowed in view definition
          • -7019: Feature not allowed in view definition
          • -7021: View column derived from function not allowed
          • -7022: Columns from more than one table not allowed
          • -7023: Dropping of all columns not allowed
          • -7024: Alter column not allowed, constraint violation
          • -7026: SQL statement not allowed without previous FETCH
          • -7029: Function not allowed for this data type
          • -7032: SQL statement not allowed for column of data type LONG
          • -7035: DEFAULT specification not allowed for this column
          • -7036: ROWNO- specification not allowed in this context
          • -7037: NULL value for NOT NULL column not allowed
          • -7038: Foreign key column not allowed
          • -7039: Cycle in referential constraint definition not allowed
          • -7040: Referential constraint not allowed
          • -7041: Result table name not allowed
          • -7042: Key update not allowed
          • -7043: Group member not allowed
          • -7045: Parameter spec not allowed
          • -7046: Column with length greater than 254 not allowed
          • -7048: DROP/ALTER USER not allowed while user is connected
          • -7050: Fastload with indexed table not allowed
          • -7051: Read only view WITH CHECK OPTION not allowed
          • -7055: Column(s) already indexed
          • -7056: Subquery not allowed
          • -7057: View definition contradicts new table definition
          • -7058: Correlated subquery with select in from clause not allowe
          • -7061: LOCK ROW for this table not allowed
          • -7063: Temp table not allowed
          • -7064: Feature not allowed in temp table definition
          • -7065: SUBTRANS COMMIT/ROLLBACK not allowed without SUBTRANS BEG
          • -7066: Unique index referenced by foreign key not allowed
          • -7067: Update without repeated read not allowed
          • -7068: Outer Join not allowed in this context
          • -7071: AUTOSAVE LOG must be stopped
          • -7072: More than one column with default SERIAL not allowed
          • -7074: Cycle in granted roles not allowed
          • -7075: Current save skipped, next is ready to take on this tape
          • -7076: No more data to read from tape
          • -7077: Synonym not allowed
          • -7078: No backup is running
          • -7079: A backup is already running
          • -7080: Query in statement not allowed
          • -7082: SQL statement not allowed for this table type
          • -7084: Parameter change not allowed
          • -7085: Function not allowed for this cursor
          • -7086: Schema not allowed
          • -7500: DCOM HRESULT
          • -7900: Different block sizes
        • From -8000 to -9799
          • -8000: SERVERDB must be restarted
          • -8001: User must be connected
          • -8002: User already connected to this user task
          • -8003: Log and data must be compatible
          • -8004: Constant must be compatible with column type and length
          • -8005: Value expression must be parameter name
          • -8006: Data types must be compatible
          • -8007: Column must be key column
          • -8009: DEFAULT value must be in constraint specification
          • -8010: Table name must be in from list
          • -8013: Order column must be output column
          • -8014: Result table must be FOR REUSE
          • -8015: Table must be a base table
          • -8016: Table must be a view table
          • -8017: Column must be group column
          • -8018: Index name must be unique
          • -8020: Next volume required
          • -8021: Column must have DEFAULT specification
          • -8022: User already connected
          • -8023: COSTLIMIT must be greater than COSTWARNING
          • -8024: RESTORE CATALOG failed
          • -8025: Table must be temp table
          • -8026: Connect disabled for this user
          • -8028: UNION columns must be compatible
          • -8030: Column must be indexed
          • -8031: Schema must be specified
          • -8033: Incomplete log segment
          • -8034: Order column must be number
          • -8035: Foreign key must exist
          • -8037: DB procedure must be recompiled
          • -8040: Key does not exist
          • -8044: Conversion for character set value impossible
          • -8045: Conversion to UNICODE impossible
          • -8046: Conversion from UNICODE impossible
          • -8047: Password required
          • -8048: Version of component must be compatible with kernel versi
          • -8049: Prepare migration required
          • -8050: Migration error
          • -8051: No snapshot available
          • -8052: Trigger dropped during migration; check view migrationerr
          • -8053: Software version is too old for version of persistent dat
          • -8888: SERVERDB not accessible
          • -9000: SYSTEM ERROR: NOT YET IMPLEMENTED
          • -9001 to -9799: System error
        • From -10000 to -10999
          • -10001: System error: <description>
          • -10003: Feature not supported for kernel version <version>
          • -10100: Invalid value for option <option> of SQLDBC_ConnectPrope
          • -10101: Invalid value for ISOLATIONLEVEL (<description>)
          • -10102: Invalid value for PACKETCOUNT (<description>)
          • -10103: Invalid value for STATEMENTCACHESIZE (<description>)
          • -10104: Invalid value for KEY
          • -10200: Function sequence error (data for execution expected)
          • -10201: Function sequence error (no data for execution expected)
          • -10202: Function sequence error (operation was aborted by discon
          • -10210: Invalid command state (no prepared SQL command)
          • -10220: Calling addBatch is not allowed for PreparedStatement /
          • -10221: Command info too long
          • -10300: Invalid parameter index [<number>]
          • -10301: Invalid host type (<name>) for parameter (<number>)
          • -10304: Parameter/Column (<number>) not bound
          • -10305: Parameter <number> contains null pointer
          • -10306: Negative buffer length for parameter (<number>) used
          • -10307: Invalid length or indicator value for parameter (<number
          • -10308: Non-character and non-binary data for parameter (<number
          • -10310: Invalid column index (<number>)
          • -10312: Attempt to concatenate to a NULL or DEFAULT value for pa
          • -10313: Requested parameter (<number>) was already processed
          • -10314: Invalid parameter processing sequence, process non-LONG
          • -10315: Invalid start position (<number>)
          • -10316: DATA AT EXECUTE for parameter (<number>) not allowed (co
          • -10317: LOB type for parameter (<number>) not allowed (conflicts
          • -10318: Invalid LOB object
          • -10319: Could not read/write LOB for parameter/column (<number>)
          • -10320: LOB already closed for parameter/column (<number>)
          • -10321: LOB invalidated by a previous error for parameter/column
          • -10322: Could not insert LOB. Parameter/column (<number>) has a
          • -10323: Non-character and non-binary data for parameter/column (
          • -10324: Stream with id (<number>) not found
          • -10325: Stream parameter (<number>) is not an input|output param
          • -10326: No data found for stream (<number>)
          • -10327: Invalid use of null pointer in stream parameter field of
          • -10328: Mismatch of number of stream members for parameter (<num
          • -10329: Invalid serial value requested, must be first or last va
          • -10330: Multiple stream output sequence error
          • -10331: Input stream callback buffer overflow for table id (<num
          • -10332: No callback function supplied for stream parameter (<num
          • -10400: Conversion looses significant digits for parameter/colum
          • -10401: Conversion of parameter/column (<number>) would truncate
          • -10404: Conversion not supported for parameter/column (<number>)
          • -10405: Cannot convert UCS2 data to ASCII
          • -10406: Invalid data length for UCS2 data for parameter/column (
          • -10407: Corrupted UTF8 data for parameter/column (<number>)
          • -10408: Character conversion failed
          • -10410: Date/time format is not supported for parameter/column (
          • -10411: Illegal DATE value for parameter/column (<number>)
          • -10412: Illegal TIME value for parameter/column (<number>)
          • -10413: Illegal TIMESTAMP value for parameter/column (<number>)
          • -10414: Conversion from binary value to string is not supported
          • -10500: Result set is closed
          • -10501: Invalid position in result set: before first row
          • -10502: Invalid position in result set: after last row
          • -10503: The operation is not allowed for result set type FORWARD
          • -10504: Invalid position (<row_number>) for row set
          • -10505: Result set type is UPDATABLE but row set type is READ_ON
          • -10506: Result set type is READ_ONLY but row set type is UPDATAB
          • -10507: Internal error: No metadata available for row set operat
          • -10508: Invalid encoding of column name for column (<number>) fo
          • -10509: The statement was not executed with updatable cursor con
          • -10601: SQL command is the empty string
          • -10602: SQL command contains UNICODE character
          • -10603: SQL command would generate a result set
          • -10604: SQL command contains output parameters
          • -10605: Illegal schema modification, parameters/columns have cha
          • -10706: Statement too long
          • -10709: Connection failed (<description>)
          • -10715: Missing user name for connection | Missing password for
          • -10757: XUSER error (<description>)
          • -10802: Invalid numeric value for parameter/column (<number>)
          • -10803: Allocation of shared memory failed (<description>)
          • -10807: Connection down: [<description>]
          • -10808: Feature <feature> not implemented yet in module: <module
          • -10810: Session already in use
          • -10811: Numeric overflow for parameter/column (<number>)
          • -10821: Session not connected
          • -10856: Invalid row array size 0
          • -10857: Missing database name for connection
          • -10861: Invalid use of null pointer for stream handle in paramet
          • -10862: Stream parameter (<number>) error in read|write procedur
          • -10899: Unknown error
          • -10901: No space left in request packet
          • -10902: Invalid request packet structure
          • -10903: Internal Error: LONGDATA part expected
          • -10904: Internal error: Expected result count
          • -10905: Invalid reply packet structure
          • -10906: Internal Error: Entry for valindex (<number>) not found
          • -10907: Internal Error: Long descriptor has error flag set
        • From -11000 to -11099
        • From -11100 to -11199
          • -11100: Unknown error
          • -11101: Initialization failed [<description>].
          • -11104: Session not connected.
          • -11105: Cannot get column name for column <number>.
          • -11106: No result set found.
          • -11107: Statement not prepared.
          • -11108: Invalid parameter index <number>.
          • -11109: Column/Parameter <number> truncated.
          • -11111: Parameter/Column (<number>) not bound.
          • -11113: Number of parameters does not match number of result col
          • -11115: Syntax error. Expected: <description>.
          • -11116: Wrong parameter type. Expected: <description>.
        • From -22000 to -22999
          • -22000: Null values not allowed on more than one long column
          • -22005: Connection timeout occurred. Session reconnected
        • From -23000 to -23999
          • -23050: Unknown error
          • -23051: Could not load system tables for SQL Studio
          • -23052: Could not save object data
          • -23053: Cannot load suppose list
          • -23054: Maximum numbers of windows reached
          • -23055: Connection failed
          • -23056: User is exclusive
          • -23057: Reconnect failed
          • -23058: No database connection
          • -23059: You do not have the permission to modify this object
          • -23060: You do not have the permission to delete this object
          • -23061: Cannot analyze error
          • -23062: Could not open connection
          • -23063: Could not create Global Com Object
          • -23064: Import failed
          • -23070: Cannot open object created by newer SQL Studio Version
          • -23071: Convert object created by older SQL Studio Version
          • -23072: Representation of null value too long
          • -23100: OLE Error! Please restart SQL Studio
          • -23101: Data in clipboard truncated
          • -23102: Failed to create DBC Pool
          • -23103: Failed to create DBC Handle
          • -23104: Could not load table definition
          • -23200: No data sources
          • -23201: No ODBC driver
          • -23202: Could not load object description
          • -23203: Cannot show tables of users, wrong database version!
        • From -24000 to -24999
          • -24905: ERR_NOEBIDLIST: no information on external backup IDs av
          • -24906: ERR_EBFDIRTY: invalid format of external backup history
          • -24907: ERR_DBAWRONG - wrong SYSDBA
          • -24909: ERR_DBAUNKNOWN - SYSDBA unknown
          • -24910: ERR_PARAMVER - wrong version of param help file (cserv.p
          • -24911: ERR_INVDBNAME - database name <database_name> is reserve
          • -24912: ERR_WRONGINST – DBM server instroot is <inst_path>
          • -24913: ERR_SERVICEDB - can not register service kernel for <ins
          • -24914: ERR_KEYEXISTS - installation key <key> exists
          • -24915: ERR_NOADDD - configuration update not allowed (param fil
          • -24916: ERR_MAXVOLCNT - max volume count exceeded
          • -24917: ERR_MAXDATA - max data size exceeded
          • -24918: ERR_MISSMIRR - missing data for mirror volume
          • -24919: ERR_CLEANUP: cannot free all operational resources after
          • -24920: ERR_BACKUPOP: backup operation was unsuccessful
          • -24921: ERR_POSTOP: error while finishing backup operation
          • -24922: ERR_OPCHK: cannot check state of backup operation
          • -24923: ERR_TOOLREQ: error while starting external backup tool
          • -24924: ERR_DBREQ: cannot start database kernel request
          • -24925: ERR_PREPARE: preparation of backup operation failed
          • -24926: ERR_MEDIUMCHK: medium cannot be used with this external
          • -24927: ERR_TOOLCHK: external backup tool not found
          • -24928: ERR_NOREPLY - no reply available
          • -24929: ERR_USRFRM - invalid user record format
          • -24930: ERR_XPVALUESET - parameter value not in value set
          • -24931: ERR_XPMIN - parameter value smaller than minimum allowed
          • -24932: ERR_XPMIN - parameter value smaller than minimum allowed
          • -24933: ERR_NOSERVICESESSION - no service kernel available
          • -24934: ERR_VERSION - incompatible versions (param and kernel)
          • -24935: ERR_NOUSERS - no users found
          • -24936: ERR_DBNORUN - database is not running
          • -24937: ERR_MISSRIGHT - no server rights for this command
          • -24938: ERR_NOENTRY - no entry found
          • -24939: ERR_LASTREG - cannot delete last registration of instanc
          • -24940: ERR_NEEDSYSLOGON - system logon required
          • -24941: ERR_NEEDLOGON - DBM server logon required
          • -24942: ERR_USRDELSDBA - cannot delete sysdba
          • -24943: ERR_USRDELDBM - cannot delete DBM operator
          • -24944: ERR_USRDELSELF - cannot delete current user
          • -24945: ERR_TOFEWPARAM - to few parameters
          • -24946: ERR_TOMANYPARAM - to many parameters
          • -24947: ERR_DBNAME - do not use dbname
          • -24948: ERR_NODBNAME - database name required
          • -24949: ERR_USREXISTS - user entry already exists
          • -24950: ERR_USRFAIL - user authorization failed
          • -24951: ERR_USRREAD - could not read user data
          • -24952: ERR_USRSAVE - could not save user data
          • -24953: ERR_DBEXIST - database instance already exists
          • -24954: ERR_BANOAUTOMED - no autolog medium found in media list
          • -24955: ERR_BANOSAVETYPE - backup type not defined
          • -24956: ERR_BASAVETYPECON - backup type conflicts with medium de
          • -24957: ERR_NOUSER - required user not set
          • -24958: ERR_BAOVERWRITE - file already exists, cannot overwrite
          • -24959: ERR_XPOVERFLOW - value out of margin
          • -24960: ERR_DBRUN - database is running
          • -24961: ERR_STATE - cannot determine current db state
          • -24962: ERR_VOLTYPE - wrong volume type
          • -24963: ERR_VOLCHECK - error while checking volume
          • -24964: ERR_EXECUTE - error in program execution
          • -24965: ERR_SYSLOGON - logon to system failed
          • -24966: ERR_LOGON - logon to DBM server failed
          • -24967: ERR_SYSTEM - system call error
          • -24968: ERR_XPREADONLY - parameter is read only
          • -24969: ERR_XPDIRTY - param file is dirty
          • -24970: ERR_XPNOMODIFY - parameter must not be modified
          • -24971: ERR_XPNOCHECK - no running parameter check
          • -24972: ERR_XPINVCONF - invalid value
          • -24973: ERR_XPCHECK - param check failure/request
          • -24974: ERR_XPSESSION - param session active
          • -24975: ERR_NOXPSESSION - param session inactive
          • -24976: ERR_PARAMEXIST - param file of database already exists
          • -24977: ERR_COMMAND - unknown command <command>
          • -24978: ERR_XPSYNTAX - xparam syntax error
          • -24979: ERR_XPNOTFOUND - parameter not found
          • -24980: ERR_NOHELP - xparam help file not found
          • -24981: ERR_HIENTRYNOTFOUND - backup history entry not found
          • -24982: ERR_ERR_NOHISTORY - backup history file not found
          • -24983: ERR_BANOVALIDTYPE - invalid backup type
          • -24984: ERR_MENOVALID - invalid medium definition
          • -24985: ERR_MENOTFOUND - medium not found
          • -24986: ERR_NOMEDIA - media file not found
          • -24987: ERR_TOSMALL - packet size too small for answer
          • -24988: ERR_SQL - sql error
          • -24989: ERR_NOHISTORYSESSION - no backup history session availab
          • -24990: ERR_ NOBACKUPSESSION - no backup session available
          • -24993: ERR_RTEEXT - runtime environment error
          • -24994: ERR_RTE - runtime environment error
          • -24995: ERR_MEM - memory allocation error
          • -24996: ERR_PARAM - wrong parameters
          • -24997: ERR_FILE - file handling error
          • -24998: ERR_NOTIMPL - sorry, command not yet implemented
          • -24999: ERR - common error
        • From -25000 to -25999
          • -25002: No database connection possible - missing database name;
          • -25003: Getting hostname of database host failed: <error_code> =
          • -25004: A connection to the database could not be established: <
          • -25005: User (<user_name>) logon to database failed: <error_text
          • -25006: Connect with userkey '<user_key>' failed: <error_text>
          • -25007: No connection to server db '<database_name>' established
          • -25008: Logon failure; previous user's (<user_name>) connection
          • -25009: Failure in db communication (<type>): <return_code> = <e
          • -25010: <SQL_error_text>
          • -25011: Error executing internal SQL statement '<statement>' : '
          • -25012: No user connection to server db established
          • -25018: Error changing log file owner to current user '<user_nam
          • -25019: Error opening server log file '<log_file_name>' (<error_
          • -25020: No more memory available
          • -25021: Error switching connected user to <user_name> : <error_t
          • -25022: Received cancel request; stopping execution
          • -25024: Error switching current schema to <schema_name> ; <error
          • -25109: Command not implemented
          • -25201: Column '<column_name>' - INTEGER field: 1, 2 or 4 bytes
          • -25202: Column '<column_name>' - REAL field: 4 or 8 bytes long (
          • -25203: Column '<column_name>' - DECIMAL field: 20 bytes maximum
          • -25204: Column '<column_name>' - ZONED field: 20 bytes maximum (
          • -25205: Declare USAGE between 50% and 100%
          • -25206: USAGE value of '0 rows' not allowed
          • -25207: USAGE value of row(s) too high; maximum number of record
          • -25208: Invalid position specification (negative values not allo
          • -25209: Invalid FRACTION specification (neg. vals not allowed)
          • -25210: Invalid SCALE spec. Scale range: -127 <= SCALE <= 127
          • -25211: Invalid ROUND specification (0 <= ROUND_value <= 18)
          • -25212: Invalid TRUNC specification (0 <= TRUNC_value <= 18)
          • -25213: Invalid file format specification: given formats rule ea
          • -25214: The specification of a separator/delimiter is not allowe
          • -25216: File option FWV required
          • -25217: End position for column <column_name> lower than start p
          • -25218: No column specified but file format is FWV
          • -25219: Columns have to be specified in left-to-right order (pos
          • -25220: Wrong separator/delimiter specification
          • -25221: Wrong decimal specification
          • -25222: Wrong Boolean specification
          • -25223: Wrong null specification
          • -25225: Wrong number specification
          • -25226: A maximum of 1024 columns can be specified for one table
          • -25227: Specification of conditions exceeds allowed count of con
          • -25228: Incorrect date-time format, all patterns accepted in the
          • -25229: Incorrect comparison operator in condition
          • -25230: Cannot execute command DATAEXTRACT FOR <load_type>; spec
          • -25231: ROUND or TRUNC specification not allowed for this column
          • -25232: Wrong keyword
          • -25233: Some column descriptions with end position but file form
          • -25234: Some column descriptions without end position but file f
          • -25235: Some positions specified more than once
          • -25236: Some positions overlap
          • -25237: Cannot execute DATAUPDATE command; specify set columns
          • -25238: Cannot execute DATAUPDATE command; specify access column
          • -25239: Specified value '<value>' is not a valid integer
          • -25240: Incomplete logon parameters; password missing
          • -25242: Database identifier too long
          • -25243: Error parsing <time> mask: <error_text>
          • -25244: Loader CONSTRAINT violation: <error_text>
          • -25245: Error: specify CATALOG, DATA, and PACKAGE stream
          • -25247: Error: specify CATALOG or DATA stream
          • -25249: Invalid Isolation Level specification: possible values a
          • -25250: Error building URI for encrypted connection: <error_text
          • -25251: Code page to set (<code_page_name>) not found in system
          • -25281: Syntax error at position <position> (<error_text>). Chec
          • -25301: Invalid input for date or time column: <input_value>
          • -25302: This value is not a valid number: '<input_value>'
          • -25303: Input value does not match key order or range specificat
          • -25304: Columns for key (KEY) or search condition missing
          • -25305: Data for key columns exceeds allowed key length
          • -25306: The value is not a valid HEX constant: <input_value>
          • -25308: CONSTRAINT condition violated
          • -25309: Invalid input for BOOLEAN column: <input_value>
          • -25310: Column '<column_name>' must not contain NULL values
          • -25311: No Data for NOT NULL - column without default (<column_n
          • -25313: Overflow occurred, execution aborted
          • -25314: Fractional part too small for column '<column_name>', mi
          • -25315: Column data type of column '<column_name>' and external
          • -25316: Table contains at least one column defined as LONG; IMPO
          • -25317: Constant must be compatible with column type and length
          • -25318: Syskey violation (the computed value exceeds the highest
          • -25319: Missing data for specified column '<column_name>'
          • -25320: The LONG value could not be loaded into column
          • -25321: This condition value is not a valid number: '<value>'
          • -25322: This condition value was truncated and cannot be used: '
          • -25323: Data type of null value representation for column '<colu
          • -25324: Errors checking length of column specifications. See Loa
          • -25325: Errors checking compatibility of external and db data ty
          • -25326: The exported number (column '<column_name>') was truncat
          • -25327: Error(s) exporting record <record_no>; start position of
          • -25328: Some error(s) while extracting data. See Loader server l
          • -25329: The given data file '<file_name>' was not generated usin
          • -25330: The page sizes of the source system and the target syste
          • -25331: This is a restricted statement, user must be SYSDBA
          • -25332: Error getting schema definition of table <table_name> (<
          • -25333: Error getting index definitions for table <table_name> (
          • -25334: File counter for data file exceeded maximum value of 999
          • -25335: Error restoring single table using data file with multip
          • -25336: Error restoring multiple tables using data file with sin
          • -25337: Error restoring table <table_name>; no table data found
          • -25338: Error during restart IMPORT; restart entry <position> no
          • -25339: Error during restart IMPORT; file <file_name> could not
          • -25340: UCS2 conversion error; character string contains invalid
          • -25341: Error generating 'create table/index statements': <error
          • -25342: Error restoring table <table_name>; table exists but sou
          • -25343: Column name(s) or number(s) do not match column names/nu
          • -25344: Incorrect field length for column '<column_name>', minim
          • -25345: Definition of source and target table <table_name> do no
          • -25346: Communication packet size too small to run IMPORT for PA
          • -25347: Encoding type of source and target database do not match
          • -25348: Different byte swap of source and target computer. The L
          • -25349: Error exporting <type> data of table <table_name>. See L
          • -25350: Conversion from UNICODE data to ASCII data is not suppor
          • -25351: No long file info given for LONG column '<column_name>'
          • -25352: Errors analyzing long file information. See loader serve
          • -25353: Specified maximum number of LONG data files for column '
          • -25354: LONGFILE specification missing or incorrect
          • -25355: Error processing LONG value (column '<column_name>'): <e
          • -25356: Error processing LONG value(s): <error_text>
          • -25364: Name of table to import <table_name> and the table curre
          • -25365: Data file corrupted: trailer not found
          • -25366: Data file corrupted: header not found
          • -25371: Error converting data from <source_encoding> to <target_
          • -25390: Error generating CREATE TABLE/INDEX statements. Table na
          • -25391: SQL statement is too long
          • -25392: [SAP AG][SQLOD32 DLL][MaxDB] <error_text>
          • -25393: Error during check if table <table_name> exists <error_t
          • -25394: Catalog of table <table_name> changed while processing <
          • -25401: Error reading system table SYSLOADER.CODEPAGE
          • -25402: Error creating/granting system table SYSLOADER.CODEPAGE
          • -25403: Error opening/reading code page file <code_page>. Can't
          • -25404: Invalid HEX constant <hex_value> found in code page file
          • -25405: Invalid ASCII values read or values not sorted in ascend
          • -25451: Integrity violation (SQL_Error)
          • -25498: Errors processing data for table <table_name>; No data i
          • -25499: Errors processing data for table <table_name>. Data not
          • -25500: Errors processing command exceed maximum number of error
          • -25501: Error opening file <file_name> : <error_text>
          • -25502: Error closing file <file_name> : <error_text>
          • -25503: Error reading file <file_name> : <error_text>
          • -25504: Error writing file <file_name> : <error_text>
          • -25505: Error erasing file <file_name> : <error_text>
          • -25507: Error truncating file <file_name> : <error_text>
          • -25508: File <file_name> is not encoded as <encoding>
          • -25551: Error importing statistics: <error_text>
          • -25552: Error exporting statistics: <error_text>
          • -25601: Error restoring table <table_name>. Table does not exist
          • -25602: Error restoring table <table_name>. Table is not empty.
          • -25603: Error processing IMPORT in PAGE Format. Loader versions
          • -25801: Internal error [<file_name>,<line_no>,<error_code>]. Con
        • From -27000 to -28999
          • -27000: Unknown error
          • -27003: Numeric input parameter overflow
          • -27006: Incompatible data types
          • -27009: Command too long
          • -27014: Connect not ok
          • -27015: Connection down
          • -27016: DB shut down
          • -27017: Too many volumes
          • -27018: Connection error
          • -27019: Conversion UNICODE to ASCII not possible
          • -28001: Access via NIL OID
          • -28002: Invalid OID
          • -28003: Unknown GUID
          • -28005: Duplicate object
          • -28006: Object not locked
          • -28007: OID not compatible with given class
          • -28501: Error reading OMS input stream
          • -28502: Error writing OMS output stream
          • -28503: Crash in DB Procedure
          • -28505: No Component Object found
          • -28508: Unsupported parameter type
          • -28514: Unknown OMS Version
          • -28515: OMS Version already open
          • -28516: Commit or Rollback required
          • -28517: Already in Critical Section
          • -28518: Not in Critical Section
          • -28521: Already in version
          • -28522: Missing before image
          • -28523: Unknown schema
          • -28524: Duplicate schema
          • -28525: Procedure Address not found
          • -28527: Directory not found
          • -28529: Too small name buffer
          • -28530: omsTerminate called
          • -28531: OMS read only
          • -28532: Version bound by transaction
          • -28533: Integer out of packed range
          • -28534: Package must be recreated
          • -28600: Invalid request code in packet
          • -28601: Object data packet for read missing
          • -28602: Packet size does not match object size
          • -28603: Requested packet size to transfer an object is too big
          • -28604: Trying to queue too many data packets when sending objec
          • -28605: Invalid operation in UDE Server-Kernel communication
          • -28606: Communication error
          • -28607: Missing object data packet
          • -28608: Invalid reply for stored procedure
          • -28609: Stored procedure not found
          • -28801: Wrong class id
          • -28802: Wrong object version
          • -28803: Wrong object version
          • -28804: Too old OID
          • -28806: Nil page pointer
          • -28808: Hash not found
          • -28810: Duplicate hash key
          • -28813: Unknown consistent version
          • -28814: Object not found
          • -28815: Object history not found
          • -28817: Wrong object length
          • -28818: Wrong object position
          • -28819: Object has been updated by other transactions
          • -28823: Page already in use
          • -28826: Pagecounter inconsistent
          • -28828: Inconsistent information concerning “is container droppe
          • -28902: Too many nested try/catch statements
          • -28903: DBFunction$1 must return a value
          • -28822 to -28999: Internal Error
        • From 0 to 1999
          • 0: Success
          • 100: Row not found
          • 200: Duplicate key
          • 250: Duplicate secondary key
          • 300: Integrity violation
          • 320: View violation
          • 350: Referential integrity violated
          • 360: Foreign key integrity violated
          • 400: Lock collision
          • 500: Lock request timeout
          • 600: Work rolled back
          • 650: Work rolled back
          • 700: Session inactivity timeout (work rolled back)
          • 710:Session terminated by shutdown (work rolled back)
          • 750: Too many SQL statements (work rolled back)
          • 1403: Row not found
        • From 25000 to 25999
          • 25599: Value for usage <number> rows too high to fit into one da
          • 25600: CONFIGURATION stream is not supported for this Loader com
          • 25601: Output of NULL values for column <column_name> will be tr
          • 25602: Possible overflow of integer values for column '<column_n
          • 25603: Output of literal '<literal>' will be truncated
          • 25604: Surplus long file info (column name/id '<column_name>') i
          • 25605: No header in binary data file and no record length in com
          • 25606: Different byte swap of source and target machine; long va
          • 25607: Value for usage <value>% too less to fit one row into one
          • 25608: Restart file <file_name> not found; starting import from
          • 25913: Table <schema_name>. <table_name> not imported
          • 25921: Range of SEQUENCE is exhausted
          • 25940: Error at record <record_count> in input file for table <t
          • 25965: No data to import in datastream <file_name>; either the s
          • 25966: Error at record <record_count> in input file <file_name>
          • 25967: Error at position <file_position> in input file <file_nam
          • 25968: Number of NULL values inserted: <null_count> (NULL repres
      • MaxDB Security Guide
        • Introduction
        • Before You Start
        • Technical System Landscape
        • User Administration and Authentication
          • Changing the Passwords of Standard Users
          • Checking Log Files for Failed Logon Attempts
        • Authorizations
          • Defining Clear Authorizations for Users
        • Network and Communication Security
          • Securing Communication Channels
          • Using the MaxDB X Server Behind a Firewall
          • Using Web Tools Behind a Firewall
        • Data Storage Security
          • Restricting Access to Database Resources (UNIX/Linux up to Datab
          • Changing the Passwords of SAP Standard Operating System Users
        • Dispensable Functions with Impacts on Security
          • Switching Off the MaxDB X Server for Local Communication
          • Starting the MaxDB X Server Without NI Support (Unix/Linux)
          • Removing Demo Data
        • Other Security-Relevant Information
          • Checking User Input in SQL Statements
        • Trace and Log Files
          • Restricting Access to Log Files
        • Attachment
    • Tutorials
      • Database Administration Tutorial
        • Creating and Configuring a Database Instance
          • Using a Script File
          • Using the Parameter File from Another Database Instance
            • Copying the Parameter File from Another Database Instance
            • Copying a Parameter File from a Data Backup
        • Displaying Information About Installed Software and Database Ins
        • Starting and Stopping a Database Instance
        • Deleting a Database Instance
        • Loading Demo Data in a Database Instance
        • Creating a DBM Operator
        • Changing the Values of Database Parameters
          • Changing the Value of a Single Database Parameter
          • Changing the Values of Multiple Database Parameters
        • Enlarging a Database Instance
        • Executing Database Statements
          • Executing a Single Database Statement
          • Executing a Succession of Database Statements
        • Defining Backup Templates
          • Defining a Backup Template for Complete Data Backup to a File
          • Defining a Backup Template for Incremental Data Backup to a File
          • Defining a Backup Template for Log Backup to a File
          • Defining a Backup Template for Log Backup to a Pipe
          • Backup Template for Complete Data Backup to a Tape
        • Backup
          • Complete Data Backup to a File
          • Complete Data Backup to a Tape
            • Displaying the Backup Status
          • Incremental Data Backup to a File
          • Log Backup to a Pipe
          • Activating Automatic Log Backup
          • Backups with Backup Tools from Other Providers
          • Backing Up the Database Instance on a Remote Computer
        • Automatic Log Backup After Event LOGABOVELIMIT
        • Displaying the Event DATABASEFULL with the Microsoft Windows Eve
        • Evaluating the Restart Information and Backup History for Import
        • Restoring Database Instances
          • Importing Log Backups up to a Specific Time (Restore)
        • Creating a Database Copy (Importing a Data Backup into Another D
        • Setting Up and Updating Standby Instances
          • Starting a Standby Instance as the Active Instance
          • Copying Log Volumes with Operating System Commands and Starting
        • Setting up a Hot Standby System
        • Operating Modes in the Database Manager CLI
          • Using Command Mode
          • Using Session Mode
          • Using Script Mode
      • SQL Tutorial
        • Demo Data for the SQL Tutorial
          • SQL Statements for the HOTEL Demo Schema
          • Explanation of the Tables in the HOTEL Demo Schema
        • Data Query
          • Selecting, Arranging, and Renaming Columns
          • Selecting and Arranging Rows
          • Conditions: Comparison, AND, OR, BETWEEN, IN
          • Searching for Character Strings: LIKE
          • Negative Conditions: NOT
          • Creating Groups: GROUP BY, HAVING
          • Arithmetic Operations
          • Functions
          • Set Functions
          • Date and Time Calculations
          • Converting Values
          • Changing Character Strings
          • Information About Character Strings
          • Subquery: Internal Queries
          • Joins: Information from Several Tables
          • Set Operations: UNION, INTERSECT, EXCEPT
        • Data Definition
          • Tables
          • Constraints
          • Primary Keys
          • Foreign Key Dependencies Between Tables
          • View tables
          • Indexes
          • Domains
          • Database Procedures
          • Database Functions
          • Database Triggers
          • Number Generators for Tables
          • Number Generator for a Single Table Column
        • Data Manipulation
          • Inserting, Changing, and Deleting Rows
        • Authorization
          • Database Users and Their Privileges
          • Roles
        • Evaluating System Tables (Examples)
      • Loader Tutorial
        • Demo Databases DEMODB and TESTDB
        • Exporting
          • EXPORT DB
          • EXPORT USER
          • EXPORT SCHEMA
          • EXPORT TABLE
          • EXPORT COLUMNS
        • Importing
          • IMPORT DB
          • IMPORT USER
          • IMPORT SCHEMA
          • IMPORT TABLE
          • IMPORT COLUMNS
        • UPDATE COLUMNS
        • Transport Mode
          • Transport
          • Export
          • Import
        • Command File Mode
        • Session Mode
    • Tools
      • Database Manager GUI
        • Calling the Database Manager GUI
        • Screen Areas of the Database Manager GUI
        • Creating a Database Instance
          • Creating a Database Instance: Desktop PC/Laptop
          • Creating a Database Instance: Custom
          • Creating a Database Instance: My Templates
        • Initializing an Existing Database Instance
        • Database Instance Management
          • Managing the List of Database Instances
          • Connection to the DBM Server
          • Starting (Restarting) the Database Instance
          • Stopping the Database Instance (Shutdown)
          • Monitoring the Operational State
          • Closing a Database Session Manually
          • Creating, Displaying and Deleting Volumes
          • Changing Volume Properties
          • Displaying and Changing Database Parameters
          • Changing Database Parameters for Volumes
          • Switching on/off Automatic Extension of the Data Area
          • Changing Log Settings
          • Setting Up a Master Instance (Hot Standby)
          • Adding a Standby Instance (Hot Standby)
          • Activating, Deactivating, or Deleting Indexes
          • Creating, Displaying, Changing and Deleting Mapchar Sets
          • Updating the Statistics Information
          • Loading Demo Data
        • Deleting a Database Instance
        • Managing the Database System Administrator
          • Changing the DBM Operator Properties of the Database System Admi
          • Changing the Password of the Database System Administrator
          • Changing the Server Authorizations of the Database System Admini
          • Changing the SQL User Properties of the Database System Administ
        • Managing Database Manager Operators
          • Creating, Changing, or Deleting a Database Manager Operator
          • Changing the DBM Operator Properties
          • Changing the Password of a Database Manager Operator
          • Changing the Server Authorizations
        • Managing Database Users
          • Creating/Changing/Deleting a Database User
          • Changing the SQL User Properties of a Database User
          • Changing the Password of a Database User
          • Creating/Changing/Deleting a Synchronization User
        • Backup
          • Backup Wizard
          • Managing the Backup Templates
            • Backup Template for a Single Data Carrier
            • Backup Template for a Group of Parallel Data Carriers
            • Changing Backup Templates
            • Deleting Backup Templates
          • Backup Procedures
            • Backing Up to a Single Data Carrier
            • Backing Up to a Group of Parallel Data Carriers
            • Backups with Automatic Tape Loaders
            • Backups to Manually Changed Data Carriers (Succeeding Data Carri
            • Backups with Backup Tools from Other Providers
            • Activating and Deactivating Automatic Log Backup
        • Restoring
          • Recovery Wizard
          • Restoring the Last Backup in the Backup History
          • Restoring a Backup from the Backup History
          • Restoring Without a Backup History
          • Continuing an Interrupted Restore
          • Restoring with Automatic Tape Loaders
          • Restoring with Backup Tools from Other Providers
          • Restoring After Initializing a Database Instance
          • Restoring the Indexes after a Database Restore
          • Restoring a Mirrored Log Volume
        • Freezing the Data Area (Snapshots)
          • Creating a Snapshot
          • Reverting to the Snapshot
          • Deleting the Snapshot
        • Displaying Information
          • Displaying the Backup History
          • Displaying Cache Information
          • Displaying Data Area Information
          • Displaying Database Activities
          • Displaying Database Parameters
          • Displaying Database Sessions
          • Displaying Log Area Information
          • Displaying System Tables
        • Options for Diagnosing Problems
          • Checking Backups
          • Displaying and Deleting Database Analyzer Information
          • Checking Database Servers
          • Reading Log Files
          • Checking Database Structures
          • Using the Database Trace
          • Displaying OMS Caches
          • Displaying OMS Class Containers
          • Activating the OMS Monitor
        • Updating the Database Software
          • Updating the System Tables
        • Using the SQL Studio
        • Using the Database Manager CLI
      • Database Manager CLI
        • How the Database Manager CLI Works
          • Calling the Database Manager CLI
            • DBM Options
              • -c: Indicate as DBM Command
              • -d: Name of the Database Instance
              • -e: Activating Encryption
              • -i | -ic | is | ics: Name of the Input Script
              • -n: Name of the Database Computer
              • -o: Name of the Output File
              • -R: Installation Directory of the Database Software:
              • -t: Name of the Log File
              • -uSQL: Opening an SQL Session
              • -uSRV: Opening a Service Session
              • -uUTL: Opening a Utility Session
              • -du: Deleting XUSER Entries
              • -uk: User Key
              • -us: Creating or Changing XUSER Entries
              • -ux: Logging On to the XUSER Program
              • -ul: Displaying XUSER Data
            • DBM Commands
            • Operating Modes in the Database Manager
            • Input Help
              • Comment: #
              • Local System Call: !
              • Linking Lines: /
              • Linking Lines: <
          • Reply Format
        • Command Reference for Working with the Database Manager CLI
          • Database Manager Help
            • Other Commands for Database Manager Help
          • Software Installation
            • Other Commands for Software Installation
          • Creating and Deleting Database Instances
            • Other Commands for Creating and Deleting Database Instances
          • Configuring Database Instances
            • Other Commands for Configuring Volumes
            • Commands for Changing Database Parameters
          • Controlling Database Instances
            • Other Commands for Controlling Database Instances
          • Backing Up and Restoring Database Instances
            • Other Commands for Backup Templates
            • Other Commands for Backups
            • Other Commands for Information on Backups
            • Other Commands for Data Recovery
          • Managing Database Manager Operators
            • Other Commands for Managing Database Manager Operators
          • Analyzing the Database Instance
            • Commands for the Database Trace Function
            • Commands for Accessing Database Files
            • Commands for Using the Database Analyzer
          • Accessing the Database Instance using SQL
            • Other Commands Accessing the Database Instance Using SQL
          • Optimizing SQL Access to the Database Instance
          • Using Database Events
            • Other Commands for Using Database Events
          • Using the Scheduler
            • Other Commands for Using the Scheduler
          • Managing Hot Standby Systems
            • Commands for Managing Hot Standby Systems
          • Database Manager Settings
            • Other Commands for the Database Manager Settings
        • Overview of All DBM Commands
          • apropos
          • archive_stage
          • archive_stage_repeat
          • auto_extend
          • auto_update_statistics
          • autolog_cancel
          • autolog_off
          • autolog_on
          • autolog_show
          • autorecover
          • backup_cancel
          • backup_cancel_req
          • backup_ext_ids_forget
          • backup_ext_ids_get
          • backup_ext_ids_getfromtool
          • backup_ext_ids_list
          • backup_ext_ids_listnext
          • backup_history_append
          • backup_history_close
          • backup_history_date
          • backup_history_list
          • backup_history_listnext
          • backup_history_open
          • backup_ignore
          • backup_ignore_req
          • backup_replace
          • backup_replace_req
          • backup_reply_available
          • backup_reply_receive
          • backup_req
          • backup_start
          • backup_state
          • bye | exit | quit | release
          • db_activate
          • db_activate RECOVER
          • db_activate_req
          • db_addvolume
          • db_admin
          • db_clear
          • db_connect
          • db_cons
          • db_create
          • db_deletevolume
          • db_drop
          • db_enum
          • db_execute
          • db_executenice
          • db_fetch
          • db_fetchnice
          • db_migratecatalog
          • db_offline
          • db_online
          • db_reg
          • db_reinstall
          • db_release
          • db_restart
          • db_restartinfo
          • db_speed
          • db_standby
          • db_state
          • db_stop
          • dban_delete
          • dban_start
          • dban_state
          • dban_stop
          • dbm_configget
          • dbm_configset
          • dbm_execute_serverprocess
          • dbm_getpath
          • dbm_getpid
          • dbm_listmemoryerror
          • dbm_next
          • dbm_setpath
          • dbm_shm_info
          • dbm_shm_reset
          • dbm_shm_unlock
          • dbm_version
          • dbmevtdisp_internal_add
          • dbmevtdisp_internal_communication
          • dbmevtdisp_internal_delete
          • diag_histlist
          • diag_pack
          • event_available
          • event_delete
          • event_list
          • event_list_categories
          • event_receive
          • event_release
          • event_set
          • event_wait
          • exec_lcinit
          • exec_nipingsrv
          • exec_sdbinfo
          • explain
          • file_backup
          • file_getfirst
          • file_getlist
          • file_getnext
          • file_operation
          • file_restore
          • get_default
          • help
          • hss_addstandby
          • hss_copyfile
          • hss_enable
          • hss_execute
          • hss_getnodes
          • hss_removestandby
          • info
          • info_next
          • inst_enum
          • inst_info
          • inst_reg
          • inst_unreg
          • load_lcapps
          • load_r3tab
          • load_systab
          • load_tutorial
          • medium_date
          • medium_delete
          • medium_delete_nodistribute
          • medium_get
          • medium_getall
          • medium_label
          • medium_labeloffline
          • medium_migrate
          • medium_put
          • medium_put_nodistribute
          • package_info
          • param_abortsession
          • param_addvolume
          • param_checkall
          • param_commitsession
          • param_copy
          • param_delvolume
          • param_directdel
          • param_directget
          • param_directgetall
          • param_directgetallnext
          • param_directput
          • param_extget
          • param_extgetall
          • param_extgetallnext
          • param_getdefault
          • param_getexplain
          • param_getfull
          • param_gethelp
          • param_gethistory
          • param_gethistorynext
          • param_getproperties
          • param_gettype
          • param_getvalue
          • param_getvolsall
          • param_getvolume
          • param_init
          • param_put
          • param_restore
          • param_rmfile
          • param_startsession
          • param_versions
          • recover_cancel
          • recover_cancel_req
          • recover_check
          • recover_check_req
          • recover_config
          • recover_ignore
          • recover_ignore_req
          • recover_replace
          • recover_replace_req
          • recover_req
          • recover_start
          • recover_state
          • recover_state_check
          • recover_volume
          • scheduler_activate_job
          • scheduler_create_job
          • scheduler_deactivate_job
          • scheduler_delete_job
          • scheduler_list_jobs
          • scheduler_start
          • scheduler_state
          • scheduler_stop
          • service_connect
          • service_release
          • show
          • show_list
          • show_next
          • sql_connect
          • sql_execute
          • sql_executenice
          • sql_fetch
          • sql_fetchnice
          • sql_info
          • sql_recreateindex
          • sql_release
          • sql_updatestat
          • sql_updatestat_per_systemtable
          • trace_clear
          • trace_flush
          • trace_off
          • trace_on
          • trace_prot
          • trace_protopt
          • trace_show
          • user_create
          • user_delete
          • user_get
          • user_getall
          • user_getrights
          • user_logon
          • user_put
            • Server Authorizations
              • Access SQL: Access to SQL Session
              • AccessUtility: Access to Utility Session
              • Backup: Performing Backups
              • DBFile Read: Accessing Database Files (Reading Only)
              • DBInfoRead: Displaying Status Information
              • DB Start: Starting the Database Instance
              • DBStop: Stopping the Database Instance
              • ExecLoad: Executing the Loader program:
              • InstallMgm: Installation Management
              • LoadSysTab: Loading the System Tables
              • ParamCheckWrite: Accessing Database Parameters (Checked Writing)
              • PAccessing Database Parameters (Reading and Writing): ParamFull
              • ParamRead: Accessing Database Parameters (Reading Only)
              • Recovery: Restoring Backups
              • SchedulerMgm: Managing the Scheduler
              • Scheduling: Scheduling DBM Commands
              • SharedMemoryAdmin: Managing the Shared Memory
              • SystemCmd: Executing Operating System Commands
              • UserMgm: Managing Database Manager Operators
          • user_rename
          • user_sap
          • user_sysdba
          • user_system
      • Database Analyzer
        • Calling the Database Analyzer
          • Options
        • Configuration File
        • Log Files
        • Messages
          • Avg user cmd exec time for task
          • Avg user suspend time for task
          • Avg User Wait Time For Task
          • Catalog Cache Hitrate
          • Collision Rate
          • Data Cache Hit Rate
          • Data volume filling level
          • Deletes/Updates
          • Free User Tasks
          • Lock List Escalations
          • Log Area Filling Level
          • Log Queue Overflows
          • Log write time
          • Max Log Queue Filling
          • Number of Cached History Pages
          • Number of Physical Reads
          • Number of physical writes
          • Number of Physical Writes of Temporary Pages
          • OMS Cache Hit Rate
          • OMS Heap Collisions
          • OMS Heap Utilization
          • OMS History Cache Hit Rate
          • OMS Terminates
          • OMS version is old
          • OMS Version is Unloaded
          • Optimizer Strategies
          • Out of Memory Exceptions
          • Parse Activities
          • Physical Reads for User Task
          • Selects and Fetches
          • Table scans
          • User Task Blocked in State
          • User Task Physical Writes
      • Loader
        • Calling the Loader
          • Call Options of the Loader CLI
            • Transport Mode
            • Command File Mode
              • Command File
            • Session Mode
            • Options for Establishing a Connection
            • Options for Input and Output
            • Options for Determining Version Information
        • Commands and SQL Statements
          • Creating a Database Session: Commands
            • AUTOCOMMIT Command
            • SET Command
            • SQLMODE Command
            • USE DB Command
            • USE SCHEMA Command
            • USE SCHEMAMAP Command
              • CREATE/DROP SCHEMAMAP Statement
            • USE USER Command
          • Exporting: Commands
            • EXPORT DB Command
            • EXPORT USER Command
            • EXPORT SCHEMA Command
            • EXPORT TABLE Command
            • EXPORT COLUMNS Command
          • Importing: Commands
            • IMPORT DB Command
            • IMPORT USER Command
            • IMPORT SCHEMA Command
            • IMPORT TABLE Command
              • Performance Improvement in the IMPORT TABLE
            • IMPORT COLUMNS Command
          • UPDATE COLUMNS Command
          • Data
            • Data Stream
            • Position Description
            • Data Format
            • Code Specification
            • CSV, FWV, FWV BINARY
            • PAGES, RECORDS
            • Data Carrier Type
          • Column Description
            • Data Types
            • Importing Constants and Special Constants
            • Selecting Data Records
            • Output Column
          • Table Name
          • Dates
          • Time Specifications
          • Time Stamp Specifications
          • NULL Value Representation
          • Transformation
          • Exporting and Importing Using Backup Tools from Other Providers
          • Importing and Exporting LONG Values
            • Exporting LONG Values
            • Importing LONG Values
          • Restarting
        • Log Functions
          • Log File
          • Transformation History
          • Additional Log Functions (package_spec)
          • System Tables
            • CODEPAGE
            • MAPSCHEMANAMES
            • TRANSFORMATIONMODEL
            • TRANSFORMATIONMONITOR
            • TRANSFORMATIONPACKAGES
            • TRANSFORMATIONRESOURCES
            • TRANSFORMATIONSTATISTICS
            • TRANSFORMATIONSTEPS
        • Syntax Rules: Arranged Alphabetically
          • autocommit_command
          • backup_tool_spec
          • bool_spec
          • catalog_data_instream_part_spec
          • catalog_data_outstream_part_spec
          • catalog_data_instream_table_spec
          • catalog_data_outstream_table_spec
          • catalog_instream_spec
          • catalog_outstream_spec
          • code_page_spec
          • code_spec
          • column_assignment
          • column_dataformat_spec
          • column_function
          • column_id
          • column_name
          • column_spec
          • compare_operator
          • condition
          • configuration_spec
          • csv_format_spec
          • data_instream_column_spec
          • data_instream_columns_spec
          • data_instream_part_spec
          • data_instream_table_spec
          • data_outstream_column_spec
          • data_outstream_part_spec
          • data_outstream_table_spec
          • database_spec
          • date_spec
          • delimiter
          • delimiter_spec
          • duplicates_clause
          • ebid_spec
          • exclude_include
          • export_column_spec
          • export_columns_command
          • export_command
          • export_db_command
          • export_lobcolumn_spec
          • export_schema_command
          • export_table_command
          • export_user_command
          • field_assignment
          • field_format_spec
          • field_function
          • field_spec
          • field_type
          • fwv_format_spec
          • if_condition
          • import_column_spec
          • import_columns_command
          • import_command
          • import_db_command
          • import_lobcolumn_spec
          • import_schema_command
          • import_table_command
          • import_user_command
          • instream_columnformat_spec
          • instream_csv_spec
          • instream_ddl_spec
          • instream_fwv_spec
          • instream_lob_spec
          • instream_pages_spec
          • instream_records_spec
          • instream_tableformat_spec
          • int_spec
          • isolation_level_spec
          • lob_code_spec
          • map_column_field
          • map_field_column
          • map_schema_spec
          • mediumtype_spec
          • noheader_spec
          • null_assign
          • null_condition
          • null_spec
          • number_spec
          • numerical_functions
          • order_clause
          • outstream_columnformat_spec
          • outstream_csv_spec
          • outstream_ddl_spec
          • outstream_fwv_spec
          • outstream_lob_spec
          • outstream_pages_spec
          • outstream_records_spec
          • outstream_tableformat_spec
          • package_spec
          • records_format_spec
          • remark_command
          • restart_spec
          • restore_spec
          • round_or_trunc_spec
          • scale_spec
          • schema_name
          • schema_map_name
          • schema_to_schema
          • select_expression
          • separator
          • separator_spec
          • sequence_number
          • set_column_spec
          • set_command
          • simple_condition
          • sql_mode
          • sql_mode_command
          • standard_code_spec
          • standard_date_mask
          • standard_time_mask
          • standard_timestamp_mask
          • start_spec
          • table_dataformat_spec
          • table_name
          • time_spec
          • timestamp_spec
          • update_column_spec
          • update_columns_command
          • usage_spec
          • use_database_command
          • use_schema_command
          • use_schema_map_command
          • use_user_command
          • user_spec
          • Syntax Rules Arranged Semantically
        • Terms: Overview
        • Key Words: Overview
      • SQL Studio (GUI)
        • Starting SQL Studio
        • Opening a Database Session
          • Recent Sessions List
        • SQL Studio Screen Areas
        • User Settings
          • Unicode Support
        • Catalog Manager
          • SQL Studio Objects
          • Exporting a Database Object Definition
          • Tables
            • Creating a Database Table
              • Defining Columns
              • Defining Constraints
              • Defining Foreign Key Dependencies
              • Defining Miscellaneous Information
            • Creating a View Table
            • Creating a Synonym
            • Displaying the Definition of a Table
            • Changing the Definition of a Database Table
            • Displaying the Content of a Table
            • Using a Table in Dialogs or Definitions
            • Renaming a Table
            • Deleting all Rows in a Table
            • Dropping a Table
          • Indexes
            • Creating an Index
            • Displaying the Definition of an Index
            • Dropping an Index
          • Number Sequences
            • Creating a Sequence
            • Displaying the Definition of a Sequence
            • Deleting a Sequence
          • Users
          • Database procedures
          • Triggers
        • SQL Dialog
          • Creating and Executing SQL Statements
            • Keyword List
            • Setting Parameters for SQL Statements
          • Importing and Exporting SQL Statements
        • Form Dialog
          • Executing a Form Dialog
            • Selecting Data Records Using Search Conditions
            • Changing Data Records
            • Inserting Data Records
            • Deleting a Data Record
            • Importing and Exporting LONG Columns
        • Visual Query Dialog
          • Creating and Executing a Visual Query
            • Linking Table Columns with Joins
            • Entering Search Conditions
              • Setting Parameters for Search Conditions
            • Defining the Result View
        • Result Tables
          • Adjusting the Result View
          • Saving a Result
        • Status Window
        • Ending the Database Session
      • Web SQL Studio
        • Calling Web SQL Studio
        • Logging on to a Database Instance
        • Screen Areas in Web SQL Studio
        • Executing SQL statements
        • Opening WebDAV Repositories
        • Saving SQL Statements
        • Editing Saved SQL Statements
        • Displaying the Software Version of Web SQL Studio
        • Closing Web SQL Studio
      • SQLCLI
        • Logging on to a Database Instance
        • Executing Commands
          • Multiple Row Mode
          • Command Buffer
          • Editing Commands in an External File
          • Batch File
          • Redirecting a Result to a File
        • Executing SQL Statements
        • Executing Database Procedures
        • Requesting Information About the Database Catalog
        • Executing Shell Commands
        • Exiting the SQLCLI
        • Overview of the Call Options
        • Overview of the SQLCLI Commands
      • Synchronization Manager
        • Technical System Landscape
          • Message Server
          • Synchronization Manager GUI
          • Synchronization Services
          • Synchronization Ports
        • Data Model
          • Example: Data Model
        • Configuration
          • Configuring Java Paths
          • Configuring the Synchronization Manager GUI
          • Configuring Database Instances
          • Configuring the Message Server
          • Configuring Synchronizations
            • Defining Replication Tables
            • Defining Replication Units
            • Activating and Deactivating Replication Units
            • Initializing Client Tables
            • Configuring Synchronization Services
        • Starting the Synchronization Manager GUI
        • Logging on to a Database Instance
        • Starting and Stopping the Message Server
        • Logging On To the Message Server
        • Synchronization
          • Starting and Stopping Synchronization Services
      • Utilities
        • Event Dispatcher
          • Commissioning the Event Dispatcher
            • Configuration for the Event Dispatcher
          • Special Events of the Event Dispatcher
          • Overview of Event Dispatcher Commands
            • add
            • delete
            • list
            • start
            • state
            • stop
            • version
        • XCONS
          • Displaying Information about the Database Instance
        • XUSER
          • Using a User Key when Logging On to a Database Instance
          • Creating or Changing XUSER Entries
          • Displaying Data for XUSER Entries
          • Deleting XUSER Entries
          • XUSER Options
          • Importing XUSER Entries from a File
        • X Server
          • Starting the X Server
          • Stopping the X Server
          • Ports and Protocols of the X Server
    • Interfaces
      • ODBC Manual
        • Properties of the MaxDB ODBC Driver
          • ODBC-API Compatibility
            • Core API
            • Level 1 API
              • Remark for SQLGetConnectAttr
              • Remarks for SQLGetFunctions
              • Remarks for SQLGetInfo
            • Level 2 API
          • Supported Data Types
          • Unicode Support
        • Using the MaxDB ODBC Driver
        • Creating/Changing a Data Source
          • Properties of Data Sources
      • SQLDBC Manual
        • Structure of SQLDBC
        • SQLDBC Classes
        • SQLDBC Traces
        • sqldbc_cons
      • Java Manual
        • Adding the Path for sapdbc.jar to the CLASSPATH Environment Vari
        • JDBC Driver
          • Loading the JDBC Driver
          • Connecting to the Database Instance
            • Method java.sql.DriverManager.getConnection
            • Class com.sap.dbtech.jdbcext.DataSourceSapDB
            • Connection URL
            • Setting Up an SSL Connection
            • Example: Connecting to the Database Instance
          • Executing SQL Statements
          • Troubleshooting (JDBC Driver)
          • Example: HelloMaxDB
        • Database Manager Java Classes
          • Method com.sap.dbtech.powertoys.DBM.dbrootDBM
          • Method com.sap.dbtech.powertoys.DBM.dbDBM
          • Method com.sap.dbtech.powertoys.DBM.dbDBM
          • Method com.sap.dbtech.powertoys.DBM.cancel
          • Method com.sap.dbtech.powertoys.DBM.release
          • Troubleshooting (Database Manager)
          • Example: Displaying the Operational State of the Database Instan
        • Loader Java Classes
          • Method com.sap.dbtech.powertoys.Loader.dbLoader
          • Method com.sap.dbtech.powertoys.Loader.cmd
          • Method com.sap.dbtech.powertoys.Loader.cancel
          • Method com.sap.dbtech.powertoys.Loader.release
          • Troubleshooting (Loader)
          • Example: Exporting a Table
      • Perl Manual
        • Configuring the Perl Modules
        • Module SAP::DBTech::dbm
          • Class DBM
            • Method cmd
            • Method rawCmd
            • Method release
          • Troubleshooting for the Module SAP::DBTech::dbm
            • Exception CommunicationError
            • Exception DBMServError
          • Examples for the SAP::DBTech::dbm Module
        • SAP::DBTech::loader Module
          • Class Loader
            • Method cmd
            • Method rawCmd
            • Method sql
            • Method release
          • Troubleshooting for the Module SAP::DBTech::loader
            • Exception CommunicationError
            • Exception LoaderError
          • Examples for the SAP::DBTech::loader Module
      • Python Manual
        • Configuring the Python Modules
        • Module sdb.dbapi
          • Method connect
          • Converting Date and Time Values
          • Converting LOB Values
        • Module sdb.sql
          • Method connect
          • Class SapDB_Session
            • Method sql
            • Method sqlX
            • Method prepare
            • Method release
            • Method commit
            • Method rollback
          • Class SapDB_ResultSet
            • Method next
            • Method previous
            • Method relative
            • Method absolute
            • Method first
            • Method last
            • Method current
            • Method __getitem__
            • Method getDescription
          • Class SapDB_Prepared
            • Method execute
            • Method getDescription
          • Class SapDB_Result
            • Method getResultSet
            • Method getOutputParameters
            • Method getRowsAffected
            • Method getLastSerial
            • Method getFirstSerial
          • SapDB_LongReader Class
            • Method read
          • Error Handling for the sdb.sql Module
            • Class CommunicationError
            • Class SQLError
          • Possible SQL Results
          • Examples for the sdb.sql Module
            • Establishing/Closing the Connection to the Database Instance
            • Executing an SQL Statement and Reading the Result Set
            • Executing SQL Statements and Navigating in the Result Set
            • Executing an SQL Statement and Reading the Result Set with a For
            • Executing SQL Statements and Querying Information About the Resu
            • Executing an SQL Statement Multiple Times with Different Values
            • Executing SQL Statements and Handling Errors
        • Module sdb.dbm
          • Class DBM
            • Method cmd
            • Method rawCmd
            • Method release
          • Error Handling for the sdb.dbm Module
            • Class CommunicationError
            • Class DBMServError
          • Examples for the sdb.dbm Module
            • Calling/Closing the Database Manager
            • Executing a DBM Command
            • Executing DBM Commands and Handling Errors
        • Module sdb.loader
          • Class Loader
            • Method cmd
            • Method rawCmd
            • Method sql
            • Method release
          • Error Handling for the sdb.loader Module
            • Class CommunicationError
            • Class LoaderError
          • Examples for the sdb.loader Module
            • Logging on to a Database Instance
            • Querying Whether a Table Exists
            • Exporting Tables
      • PHP Manual
      • WebDAV
        • Calling the WebDAV Servlet
      • Backint for MaxDB
        • Backing Up and Restoring Data with MaxDB Programs
        • Backing Up and Restoring Data with External Backup Programs
        • Functional Description for Backint for Max DB
          • Backup Function
          • Restore Function (restore)
          • Inquire Function
          • Delete Function
        • Program Definition for Backint for Max DB
          • Calling Backint for MaxDB
            • Options
            • Variables
            • Backup ID (BID)
          • Content of the Input File
          • Content of the Output File
          • Return Codes
        • Supported Operating Systems and Platforms (Version 7.4)
        • Supported Operating Systems and Platforms (Version 7.3)
    • Development
      • Development Environment
        • Installing the Development Environment
        • Installing the Source Code
        • Initializing the Development Environment
          • Environment Variables
            • $ARC_TYPE
            • $BUILD_PRAEFIX
            • $CORRECTION_LEVEL
            • $DBROOT
            • $DLL_TYPE
            • $EDITOR
            • %INCLUDE%
            • $INSTROOT
            • $NOQUIET
            • $OWN
            • $PATH
            • $PERL5LIB
            • $PYTHONPATH
            • $RELVER
            • $SHELL
            • $TOOL
            • $TOOLEXT
            • $TOOLOPT
            • $TOOLSHELL
            • $TOOLVARS
            • $VMAKE_DEFAULT
            • $VMAKE_OPTION
              • General Parameters for $VMAKE_OPTION
              • $VMAKE_OPTION Parameters for Searching for Source Code
              • $VMAKE_OPTION Parameters for Searching for Object Files
            • $VMAKE_PATH
            • $VMAKE_VERSION
            • $WRK
          • Search Hierarchy
          • Directory Structure of the Development Environment
        • Changing a MaxDB Program
          • Changing a Module File
            • Module File
            • Include Files
            • Layer
          • Preparing the MAKE process
            • Creating/Changing Description Files
              • Description Files
                • Link Description
                • Compilation Description
                • Processing List
              • General Grammar for Description Files
                • Grammar for Link Descriptions
                • Grammar for Compilation Descriptions
                • Grammar for Processing Lists
              • Options for Description Files
                • Options for Link Descriptions
                • Options for Compilation Descriptions
                • Options for Processing Lists
                • ! <command>
                • !! <command>
                • !? <command>
                • ? defaultlayer : <layer>
                • ? defaultlayer :
                • ? defaultversion : <vmake_version>
                • ? defaultversion :
                • ? distribute : <list>
                • ? error: <error_message>
                • ? link with : <list>
                • ? linkoption : <list>
                • ? output : <list>
                • ? parentlinkoption : <link_option>
                • ? propagate : <variable>[=<value>]
                • ? require : <target>
                • ? tooloption : <list>
                • -><output>
                • ascii
                • binary
                • debug|d
                • definition
                • demand
                • demand{<relative path>}
                • demand=<list>
                • demand{<relative path>}=<list>
                • dep=<list>
                • distrib
                • exec
                • extdep=<list>
                • inc=<list>
                • interface
                • nobind
                • nocomfile
                • nodistrib
                • noobjcopy
                • noshrglob
                • noversion
                • obj=<list>
                • output=<list>
                • parentlinkoption=<link_option>
                • profile|p
                • remake
                • shrglob
                • uncond
            • Adapting the Initialization Files
              • Langextinfo
              • Langinfo
              • Extra
              • Globals.com
              • DirectoryMapping
            • Specifying Files That Do Not Require Translation
          • icp.pl: Copying Files to the Development Area
          • iview.pl: Displaying and Editing Files
          • idiff.pl: Comparing Files
          • ils.pl: Displaying the Versions of a File
          • Naming Conventions for Files
            • Naming Conventions for Module Files
            • Naming Conventions for Description Files
        • MAKE Operation
          • ims.pl, imf.pl: Starting the MAKE Operation
            • Direct VMAKE Call
            • Options for Calling VMAKE
            • Activating Debug Mode
            • VMAKE Versions
          • Determining the Files to be Translated
          • Translation Process
            • Selecting the Translation Tools
            • Unpacking the Module Files
            • Translating the Module Files
            • Object Files
            • Date Files
          • Link Operation
          • VMAKE Tools
            • Options for VMAKE Tools
          • VMAKE Logs
            • ips.pl, ipf.pl: Displaying Logs
          • Comparison Between MaxDB VMAKE and a Conventional Make Program
        • Example: Translating the File HelloWorld.c
        • Example: Creating the Database Manager CLI 7.4.03 Program
          • Components of DBMCLI
            • dbmcli.rc
            • vcn12.cpp, vcn13.cpp, vcn14.c
              • Compilation Descriptions
              • Example of an Include File
            • cservlib
            • splib
            • eoxlib
            • sqlusr, enalib, enblib
            • Further Dependencies
          • Creating the DBMCLI
            • Link Description dbmcli.lnk
          • Function Check
      • Web Based Problem Tracking System
        • System Requirements
        • How the Web PTS Works
          • Simple Search
            • Result List of the Simple Search
          • Advanced Search
            • Result List of the Advanced Search
          • My Release Notes
            • Result List of My Release Notes
        • Terms
          • Message Data
            • Header Data
            • Settlement
          • Message Texts
    • Icons and Typographic Conventions

 © 2018