create_package_statement
The SQL statement CREATE PACKAGE (create_package_statement) is not accepted by MaxDB.
- MaxDB Library
- Installation
- Installation Manual
- Using the Installation Manager
- Installation, Upgrade and Uninstallation on the Command Line
- 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
- Connecting to a Backint for MaxDB Interface
- Connecting to TSM
- Connecting to NetWorker
- Connecting to VERITAS NetBackup
- Installing the Synchronization Manager
- Installing MaxDB PHP Extension
- Configuring Web SQL / WebDAV
- Troubleshooting
- Details
- Installation Manual
- Basic Information
- Concepts of the Database System
- Software Information
- Overview of the Database System
- Database Tools
- Interfaces
- Technical System Landscape
- Creating and Configuring a Database Instance
- Administration
- Regular Administration Tasks
- Automating Administration Tasks
- Users, Authentication and Authorizations
- Backing Up and Restoring
- Exporting and Importing
- Replication and High Availability
- Monitoring
- Performance
- Analyzing Performance Bottlenecks
- Automatic Transformation of SQL Statements
- SQL Optimizer
- How the SQL Optimizer Operates
- Search Conditions
- 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
- 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
- How the SQL Optimizer Operates
- Troubleshooting
- 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)
- 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)
- 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)
- 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)
- 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
- Data query
- 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
- SQL Statements: Overview
- 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)
- Conversion Function (conversion_function)
- Date function
- Database Function Call (dbfunction_call)
- Extraction function
- Special Function (special_function)
- String Function (string_function)
- Time Function (time_function)
- Trigonometric Function (trigonometric_function)
- Joined Table (joined_table)
- Key Specification (key_spec)
- Literal
- 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)
- 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
- 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
- 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
- Data definition
- 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
- 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
- Concepts of the Database System
- Tutorials
- Database Administration Tutorial
- Creating and Configuring a Database Instance
- 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
- Enlarging a Database Instance
- Executing Database Statements
- Defining Backup Templates
- Backup
- 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
- Creating a Database Copy (Importing a Data Backup into Another D
- Setting Up and Updating Standby Instances
- Setting up a Hot Standby System
- Operating Modes in the Database Manager CLI
- SQL Tutorial
- Demo Data for the SQL Tutorial
- 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
- Data Manipulation
- Authorization
- Evaluating System Tables (Examples)
- Loader Tutorial
- Database Administration Tutorial
- Tools
- Database Manager GUI
- Calling the Database Manager GUI
- Screen Areas of the Database Manager GUI
- Creating a Database Instance
- 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
- Managing Database Manager Operators
- Managing Database Users
- 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)
- Displaying Information
- Options for Diagnosing Problems
- Updating the Database Software
- 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
- DBM Options
- Reply Format
- Calling the Database Manager CLI
- Command Reference for Working with the Database Manager CLI
- Database Manager Help
- Software Installation
- Creating and Deleting Database Instances
- Configuring Database Instances
- Controlling Database Instances
- Backing Up and Restoring Database Instances
- Managing Database Manager Operators
- Analyzing the Database Instance
- Accessing the Database Instance using SQL
- Optimizing SQL Access to the Database Instance
- Using Database Events
- Using the Scheduler
- Managing Hot Standby Systems
- 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
- Server Authorizations
- user_rename
- user_sap
- user_sysdba
- user_system
- How the Database Manager CLI Works
- Database Analyzer
- Calling the Database Analyzer
- 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
- Commands and SQL Statements
- Creating a Database Session: Commands
- Exporting: Commands
- Importing: Commands
- UPDATE COLUMNS Command
- Data
- Column Description
- 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
- Restarting
- Log Functions
- 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
- SQL Studio Screen Areas
- User Settings
- Catalog Manager
- SQL Studio Objects
- Exporting a Database Object Definition
- Tables
- Indexes
- Number Sequences
- Users
- Database procedures
- Triggers
- SQL Dialog
- Form Dialog
- Visual Query Dialog
- Result Tables
- Status Window
- Ending the Database Session
- Web SQL Studio
- SQLCLI
- Synchronization Manager
- Technical System Landscape
- Data Model
- Configuration
- Starting the Synchronization Manager GUI
- Logging on to a Database Instance
- Starting and Stopping the Message Server
- Logging On To the Message Server
- Synchronization
- Utilities
- Database Manager GUI
- Interfaces
- ODBC Manual
- SQLDBC Manual
- Java Manual
- Adding the Path for sapdbc.jar to the CLASSPATH Environment Vari
- JDBC Driver
- 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
- Perl Manual
- Python Manual
- Configuring the Python Modules
- Module sdb.dbapi
- Module sdb.sql
- Method connect
- Class SapDB_Session
- Class SapDB_ResultSet
- Class SapDB_Prepared
- Class SapDB_Result
- SapDB_LongReader Class
- Error Handling for the sdb.sql Module
- 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
- Module sdb.loader
- PHP Manual
- WebDAV
- 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
- Program Definition for Backint for Max DB
- 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
- Search Hierarchy
- Directory Structure of the Development Environment
- Changing a MaxDB Program
- Changing a Module File
- Preparing the MAKE process
- Creating/Changing Description Files
- Description Files
- General Grammar for Description Files
- 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
- Specifying Files That Do Not Require Translation
- Creating/Changing Description Files
- 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
- MAKE Operation
- Example: Translating the File HelloWorld.c
- Example: Creating the Database Manager CLI 7.4.03 Program
- Web Based Problem Tracking System
- Development Environment
- Icons and Typographic Conventions
- Installation