Basic Information |
Database Administration |
SAP DB and MySQL MaxDB |
Database System |
Kernel |
Kernel Variant |
Thread |
User Kernel Thread |
Pager |
Log Writer |
Server Task |
Timer Task |
Trace Writer Task |
User Task |
Utility Task |
Special Threads |
Task |
Task States |
Directory Structure |
Example: Directory Structure |
Database Directories |
Run Directory |
Database Tools |
Database Analyzer |
Database Manager |
Architecture of the Database Manager |
DBM Server |
Database Manager Files |
Database Manager Log Files |
Database Manager Configuration Files |
Loader |
Architecture of the Loader |
Loader Server |
Unloading Data |
Loading Data |
Query Tools |
SQLCLI |
Architecture of the Query Tools |
WebDAV GUI |
Web Tools |
Architecture of the Web Tools |
XCONS (Database Console) |
XPU |
XUSER |
Creating or Changing XUSER Entries |
Connecting with the XUSER Entry |
Displaying Data for XUSER Entries |
Deleting XUSER Entries |
XUSER Files |
X Server |
Programming Interfaces |
Database Instance |
Database |
Database Catalog |
Application Data |
Database Instance Type |
OLTP (MySQL MaxDB) |
liveCache (SAP liveCache) |
Archive |
Operational State |
Database Name |
UNICODE |
Creating a UNICODE Database |
Example: Displaying Column Information |
Language Support (MapChar Sets) |
Multiprocessor Configuration |
Database Parameters |
General Database Parameters |
Special Database Parameters (Extended) |
DEVNO_BIT_COUNT |
JOIN_SEARCH_LEVEL |
Database Files |
File Classes |
Log Files |
Database Trace |
Configuration Files |
Caches |
Catalog Cache |
I/O Buffer Cache |
Converter |
Data Cache |
Log Queue |
Volumes |
Data Volumes and Data Area |
Log Volumes and Log Area |
Log Segment |
Page |
Database Session |
Connecting to a Database Instance |
Calling the Database Tools |
SQL Mode |
Timeout Value |
Transactions |
COMMIT |
ROLLBACK |
Locks |
Type of Lock |
Shared Lock |
Exclusive Lock |
Optimistic Lock |
Requesting Locks |
Releasing Locks |
Isolation Level |
Isolation Level 0 |
Isolation Level 1 or 10 |
Isolation Level 15 |
Isolation Level 2 or 20 |
Isolation Level 3 or 30 |
Phenomena |
User Concept |
Database Manager Operator (DBM Operator) |
Properties of a DBM Operator |
Server Authorizations |
Database User |
Database System Administrator (SYSDBA User) |
Database Administrator (DBA User) |
DOMAIN User |
RESOURCE Users |
STANDARD User |
User Groups |
Security Concepts |
Availability |
Log Settings |
Log Mode |
Overwrite Mode for the Log Area |
Activating or Deactivating Redo Log Management |
Backup |
Backup Strategy |
Data Backup |
Log Backup |
Automatic Log Backup |
Interactive Log Backup |
Version Files of the Log Backup |
Backup History |
Backup ID |
External Backup ID |
Backup Medium |
Group of Parallel Backup Media |
External Backup Tool |
Naming Conventions for Backup Media |
Restore |
Savepoint |
Restart |
Checking the Database Structures |
Version Notation |
Technical Specifications |
Supported Operating Systems and Platforms |
Support |
Using Web PTS to Search for Known Problems |
Overview of the Documentation |
Variables |
Terms |
Reference Manual |
Basic Elements |
Character |
Digit |
Letter |
Extended letter |
hex_digit |
language_specific_character |
Special character |
Literal (literal) |
String Literal (string_literal) |
hex_literal |
hex_digit_seq |
Numeric Literal (numeric_literal) |
Fixed point literal |
Sign |
Digit sequence |
Floating point literal |
Mantissa |
Exponent |
Unsigned integer |
Integer |
Token |
Regular token |
Keyword |
Not reserved keyword |
Reserved keyword |
Identifier |
Simple Identifier (simple_identifier) |
First character |
Identifier tail character |
Underscore |
Double quotes |
Special Identifier (special_identifier) |
Delimiter token |
Names |
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 |
Index Name (index_name) |
Indicator name |
Mapchar Set Name (mapchar_set_name) |
Owner |
Password |
Parameter name |
Privilege type (privilege) |
Reference Name (reference_name) |
Name of a Referential Constraint (referential_constraint_name) |
Result Table Name (result_table_name) |
Role Name (role_name) |
Sequence Name (sequence_name) |
Synonym Name (synonym_name) |
Table Name (table_name) |
Trigger Name (trigger_name) |
Usergroup Name (usergroup_name) |
User Name (user_name) |
Column specification (column_spec) |
Parameter specification (parameter spec) |
Specifying values (extended value spec) |
Specifying Values (value_spec) |
Date and Time Format (datetimeformat) |
Specifying a string (string spec) |
Specifying a Key (key_spec) |
Expression |
factor |
Predicate (predicate) |
BETWEEN predicate (between_predicate) |
Boolean predicate (bool_predicate) |
Comparison Predicate (comparison_predicate) |
Comparison Operators (comp_op) |
Comparison Operators (equal_or_not) |
DEFAULT predicate |
EXISTS Predicate (exists_predicate) |
IN Predicate (in_predicate) |
JOIN Predicate (join_predicate) |
LIKE Predicate (like_predicate) |
Pattern element |
match_string |
match_set |
NULL predicate |
Quantified Predicate (quantified_predicate) |
Quantifier |
ROWNO Predicate (rowno_predicate) |
SOUNDS Predicate (sounds_predicate) |
Search Condition (search_condition) |
Boolean factor |
Functions: Overview |
Function (function spec) |
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) |
Trigonometric function |
String Function (string_function) |
ALPHA(x,n) |
ASCII(x) |
EXPAND(x,n) |
GET_OBJECTNAME(x,o) |
GET_OWNER(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 (concatenation) |
Date function |
ADDDATE/SUBDATE(t,a) |
DATEDIFF(t,s) |
DAYNAME/MONTHNAME(t) |
DAYOFWEEK/WEEKOFYEAR/DAYOFMONTH/DAYOFYEAR(t) |
MAKEDATE(a,b) |
date_or_timestamp_expression |
Time Function (time_function) |
ADDTIME/SUBTIME(t,a) |
MAKETIME(h,m,s) |
TIMEDIFF(t,s) |
hours/minutes/seconds |
Time expression |
Time or timestamp expression |
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) |
Conversion Function (conversion_function) |
CHAR(a,t) |
CHR(a,n) |
HEX(a) |
HEXTORAW(a) |
NUM(a) |
Database Function Call (dbfunction_call) |
Set Function (set_function_spec) |
DISTINCT Function (distinct_function) |
ALL function |
Set function name |
AVG |
COUNT |
MAX/MIN |
STDDEV |
SUM |
VARIANCE |
SQL Statements: Overview |
Comment (sql_comment) |
Example Tables |
customer |
hotel |
room |
reservation |
Data Definition |
CREATE TABLE Statement (create_table_statement) |
SAMPLE definition |
Column Definition (column_definition) |
Data Type (data_type) |
CHAR[ACTER]![End Level 7 Node CHAR[ACTER]](../../images/1x1.gif) |
VARCHAR |
LONG[VARCHAR]![End Level 7 Node LONG[VARCHAR]](../../images/1x1.gif) |
BOOLEAN |
FIXED |
FLOAT |
INT[EGER]![End Level 7 Node INT[EGER]](../../images/1x1.gif) |
SMALLINT |
DATE |
TIME |
TIMESTAMP |
Memory Requirements of a Column Value per Data Types |
Column Attributes (column_attributes) |
DEFAULT Specification (default_spec) |
CONSTRAINT definition (constraint_definition) |
Referential CONSTRAINT Definition (referential_constraint_defini |
DELETE rule |
CASCADE dependency |
Reference cycle |
Matching row |
Key Definition (key_definition) |
UNIQUE Definition (unique_definition) |
DROP TABLE Statement (drop_table_statement) |
CASCADE Option (cascade_option) |
ALTER TABLE statement (alter_table_statement) |
ADD Definition (add_definition) |
ALTER definition |
COLUMN Change Definition (column_change_definition) |
DROP Definition (drop_definition) |
MODIFY definition |
RENAME TABLE statement |
RENAME COLUMN statement |
EXISTS TABLE statement |
CREATE DOMAIN statement |
DROP DOMAIN statement |
CREATE SEQUENCE Statement (create_sequence_statement) |
DROP SEQUENCE statement |
CREATE SYNONYM statement |
DROP SYNONYM statement |
RENAME SYNONYM statement |
CREATE VIEW Statement (create_view_statement) |
Complex view table |
Updateable View Table |
INSERT Privilege for the Owner of the View Table |
UPDATE privilege for the owner of the view table |
DELETE privilege for the owner of the view table |
Updateable join view table |
DROP VIEW Statement (drop_view_statement) |
RENAME VIEW statement |
CREATE INDEX Statement (create_index_statement) |
DROP INDEX Statement (drop_index_statement) |
ALTER INDEX Statement (alter_index_statement) |
RENAME INDEX statement |
COMMENT ON Statement (comment_on_statement) |
CREATE DBPROC Statement (create_dbproc_statement) |
Routine |
statement |
General CASE Statement (searched_case_statement) |
Simple CASE Statement (simple_case_statement) |
DROP DBPROC statement |
CREATE TRIGGER Statement (create_trigger_statement) |
DROP TRIGGER statement |
CREATE FUNCTION Statement (create_function_statement) |
DROP FUNCTION Statement (drop_function_statement) |
Authorization |
CREATE USER Statement (create_user_statement) |
user_mode |
CREATE USERGROUP Statement (create_usergroup_statement) |
usergroup_mode |
DROP USER Statement (drop_user_statement) |
DROP USERGROUP Statement (drop_usergroup_statement) |
ALTER USER Statement (alter_user_statement) |
ALTER USERGROUP Statement (alter_usergroup_statement) |
RENAME USER 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 (alter_password_statement) |
CREATE ROLE Statement (create_role_statement) |
DROP ROLE Statement (drop_role_statement) |
GRANT Statement (grant_statement) |
Privilege Specification (priv_spec) |
Grantee |
REVOKE Statement (revoke_statement) |
Data Manipulation |
INSERT Statement (insert_statement) |
Data Type of the Target Column and Inserted Value |
Join View Table in INSERT Statement |
QUERY Expression in INSERT Statement |
DUPLICATES clause |
Constraint Definition in INSERT Statement |
Trigger in INSERT Statement |
Extended expression |
SET INSERT clause |
UPDATE Statement |
SET UPDATE clause |
Column combination for a given column of a join view table |
DELETE statement |
NEXT STAMP statement |
CALL Statement (call_statement) |
Data Query |
QUERY statement |
Named/Unnamed Result Table |
DECLARE CURSOR statement |
Recursive DECLARE CURSOR statement |
SELECT Statement (named_select_statement) |
SELECT Statement (select_statement) |
QUERY Expression (query_expression) |
QUERY term (query_term) |
QUERY Expression (named_query_expression) |
QUERY term (named query term) |
QUERY specification (query_spec) |
DISTINCT function (distinct spec) |
Selected Column (select_column) |
QUERY specification (named_query_spec) |
Table expression |
FROM clause |
FROM TABLE Specification (from_table_spec) |
Joined Table (joined_table) |
WHERE Clause (where_clause) |
GROUP Clause (group_clause) |
HAVING clause |
Subquery |
Correlated Subquery |
Scalar Subquery (scalar_subquery) |
ORDER Clause (order_clause) |
UPDATE Clause (update_clause) |
LOCK Option (lock_option) |
OPEN CURSOR statement |
FETCH Statement (fetch_statement) |
CLOSE 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) |
LOCK Statement (lock_statement) |
ROW specification (row spec) |
UNLOCK Statement (unlock_statement) |
RELEASE Statement (release_statement) |
Statistics |
UPDATE STATISTICS Statement (update_statistics_statement) |
MONITOR Statement (monitor_statement) |
Terms and Concepts |
ASCII code |
BOOLEAN |
Users and User Groups |
Code Attribute |
Database Function |
Database Procedure |
Data integrity |
Data Type |
Date Value |
index |
LONG column |
NULL value |
Parameter |
Privilege |
Role |
Role Concept |
SERIAL |
Column |
Special NULL value |
SQL Mode |
Subtransaction |
Synonym |
Table |
Transactions |
Trigger |
Domain |
Number |
Character String |
Timestamp Value |
Time Value |
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 |
assignment_statement |
between_predicate |
bool_predicate |
boolean_factor |
boolean_term |
call_statement |
cascade_option |
case_else_clause |
case_function |
case_statement |
character |
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_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_sequence_statement |
create_synonym_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_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_sequence_statement |
drop_synonym_statement |
drop_table_statement |
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_name |
index_spec |
indicator_name |
initial_select |
insert_expression |
insert_statement |
integer |
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 |
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_definition |
monitor_statement |
named_query_expression |
named_query_primary |
named_query_spec |
named_query_term |
named_select_statement |
new_index_name |
new_table_name |
next_stamp_statement |
not_reserved_key_word |
null_predicate |
numeric_literal |
object_spec |
old_index_name |
old_table_name |
open_cursor_statement |
order_clause |
outer_join_inidicator |
owner |
parameter_name |
parameter_spec |
password |
pattern_element |
position |
predicate |
priv_spec |
privilege |
procedure_name |
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_statement |
rename_column_statement |
rename_index_statement |
rename_synonym_statement |
rename_table_statement |
rename_user_statement |
rename_usergroup_statement |
rename_view_statement |
reserved_key_word |
result_column_name |
result_table_name |
revoke_statement |
role_name |
rollback_statement |
routine |
routine_sql_statement |
row_spec |
rowno_column |
rowno_predicate |
sample_definition |
scalar_subquery |
search_and_result_spec |
search_condition |
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 |
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 |
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 |
where_clause |
while_statement |
Syntax Notation |
System Tables |
General Information |
Database Terms |
A-C |
D-H |
I-R |
S |
T |
U-Z |
Evaluating System Tables |
COLUMNS |
CONNECTEDUSERS |
CONNECTPARAMETERS |
CONSTRAINTS |
DBPROCEDURES |
DBPROCPARAMS |
DOMAINCONSTRAINTS |
DOMAINS |
FOREIGNKEYCOLUMNS |
FOREIGNKEYS |
INDEXCOLUMNS |
INDEXES |
LOCKS |
MAPCHARSETS |
ROLEPRIVILEGES |
ROLES |
SEQUENCES |
SESSION_ROLES |
SYNONYMS |
TABLEPRIVILEGES |
TABLES |
TRIGGERS |
USERS |
VERSIONS |
VIEWCOLUMNS |
VIEWDEFS |
VIEWS |
Definitions of the System Tables |
ACTIVECONFIGURATION |
CACHESTATISTICS |
COLUMNS |
COMMANDCACHESTATISTICS |
COMMANDSTATISTICS |
CONNECTEDUSERS |
CONNECTPARAMETERS |
CONSTRAINTS |
DATASTATISTICS |
DATAVOLUMES |
DBPARAMETERS |
DBPROCEDURES |
DBPROCPARAMS |
DIAGNOSE |
DOMAINCONSTRAINTS |
DOMAINS |
FOREIGNKEYCOLUMNS |
FOREIGNKEYS |
HOTSTANDBYCOMPONENT |
HOTSTANDBYGROUP |
INDEXCOLUMNS |
INDEXES |
INDEXSTATISTICS |
INSTANCE |
LOCKLISTSTATISTICS |
LOCKS |
LOGVOLUMES |
MACHINECONFIGURATION |
MACHINEUTILIZATION |
MAPCHARSETS |
MEMORYALLOCATORSTATISTICS |
MONITOR |
MONITOR_CACHES |
MONITOR_LOAD |
MONITOR_LOCK |
MONITOR_LOG |
MONITOR_LONG |
MONITOR_PAGES |
MONITOR_ROW |
MONITOR_TRANS |
OPTIMIZERINFORMATION |
OPTIMIZERSTATISTICS |
PACKAGES |
ROLEPRIVILEGES |
ROLES |
SCHEMAS |
SEQUENCES |
SERVERDBSTATISTICS |
SESSION_ROLES |
SESSIONS |
SNAPSHOTS |
SYNONYMS |
TABLEPRIVILEGES |
TABLES |
TABLESTATISTICS |
TRANSACTIONS |
TRIGGERS |
USERS |
USERSTATISTICS |
VERSION |
VERSIONS |
VIEWCOLUMNS |
VIEWDEFS |
VIEWS |
ORACLE SQL Mode |
General Differences |
SQL Syntax Elements |
Schema Object |
Name |
Namespace |
Access to Objects |
Integer |
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_function_statement |
create_index_statement |
create_package_statement |
create_package_body_statement |
create_procedure_statement |
create_profile_statement |
create_rollback_segment_statement |
create_schema_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_function_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) |
-530: Referential integrity violated |
-602: System error |
From -700 to -899 |
-702: Missing variable address in SQLDA |
-703: Duplicate FETCH statement for same select in program |
-706: SQL statement too long (buffer overflow) |
-707: Invalid CONNECT statement syntax |
-708: SERVERDB system not available |
-709: Connect failed, check SERVERDB |
-710: Missing select PARSID |
-711: Implicit CONNECT: missing user or SERVERDB |
-712: Too many parameters, SQLMAX too small |
-715: Missing username or password for connect |
-719: Unknown LOCALSYSUSER.SYSPROFILE table |
-720: SQLCODE <no> comes from SYSPROFILE command |
-721: Macro not initiated, no SQLCHECK |
-724: Duplicate substructure name |
-729: Source code may be truncated |
-730: Nested comment not closed |
-731: Component name too long |
-732: Index of component out of |
-733: Variable is declared as a pointer |
-734: Pointer variable not allowed here |
-735: No syntax check for CONNECT command |
-740: Array size mismatch |
-743: Input string too long |
-750: FFETCH or ARRAY-FETCH and FETCH mix not allo |
-751: Numeric input parameter overflow |
-752: Session already connected |
-753: Output parameter with CONST type |
-756: Different SQLMODEs not allowed |
-758: Include file exists on disk |
-759: Include file produced by user |
-760: Memory allocation failed |
-762: EXEC ORACLE command has been deleted |
-763: Variable not allowed as ARRAY |
-767: Unterminated C string |
-768: Invalid escape value |
-769: Pointer component not allowed |
-770: Macro in FETCH set SQLOPT="-B 0" |
-771: LONG column exists in table definition |
-772: Multibyte char set not allowed |
-773: Datafile open error |
-774: Datafile write error |
-775: Datafile read error |
-776: Datafile close error |
-777: Conversion from UNICODE impossible |
-778: Conversion to UNICODE impossible |
-801: Input parameter cannot be NULL value |
-802: Invalid numeric input parameter value |
-804: Parameter list too long |
-805: Program must be precompiled |
-806: DB session number not allowed |
-807: Connection down, session released |
-808: Not yet implemented |
-809: Missing indicator variable, output parameter with NULL val |
-811: Numeric output parameter overflow |
-812: Parameter list too short |
-813: SERVERDB must be restarted |
-814: Trace file close error |
-815: Trace file open error |
-816: Trace file write error |
-817: Incompatible data types |
-818: Missing macro parameter initialization |
-819: Parameter in SQL statement not allowed |
-820: Invalid declare statement |
-822: Invalid constant definition |
-823: Integer too large, greater than 32767 |
-824: Statement in conflict with COMPATIBLE option |
-825: Duplicate field name in record |
-826: Duplicate statement name |
-827: Duplicate type definition |
-828: Duplicate variable name |
-829: File close error |
-830: File open error |
-831: File read error |
-832: File write error |
-833: Illegal INCLUDE position |
-834: INCLUDEs must not be nested |
-835: INCLUDE file open error |
-836: Invalid C preprocessor command |
-837: Data definition not allowed |
-838: Invalid declarator |
-839: Invalid macro value |
-840: Invalid numeric macro value |
-841: Invalid precompiler option |
-842: Parameter and indicator do not match |
-843: Invalid parameter name |
-844: Invalid record name |
-845: Invalid SQL statement |
-846: Invalid statement in section |
-847: Invalid type definition |
-848: Invalid unsigned integer |
-849: Invalid data definition |
-850: Statement termination expected |
-851: Missing input file name |
-852: Missing program file |
-853: Precompiler syntax check only |
-854: Parameters must be question marks |
-855: SQL variable must be an array |
-856: Invalid loop parameter value |
-857: Missing SERVERDB |
-858: Storage class not allowed |
-859: Number of columns < number_of_parameters |
-860: Too many constants declared |
-870: Too many type definitions |
-871: Too many variable definitions |
-872: Number of columns > number of parameters |
-873: Unknown constant name |
-874: Unknown cursor name |
-876: Unknown macro number |
-877: Unknown parameter name |
-878: Unknown record name |
-879: Unknown precompiler statement |
-880: Unknown statement name |
-881: Unknown type name |
-882: Missing user name for connect |
-883: Invalid runtime options |
-884: Missing indicator variable |
-885: Variable may be truncated |
-886: DECLARE SECTION BEGIN or END missing |
-887: Too long WHENEVER action |
-889: Input line longer than 512 characters |
-890: Input line longer than right margin |
-892: Variable my be overflow |
-893: Too many hostvariables |
-894: Trace parameter structure not allowed |
-895: Whole table may be deleted or updated |
-899: Error unknown |
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 |
-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 usergroup 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 |
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 |
 |