Grundwissen |
Konzepte des Datenbanksystems |
Informationen zur Software |
SAP DB und MaxDB |
Dokumentation |
Demo-Datenbank |
Download |
Versionsnotierung |
Unterstützte Betriebssysteme, Plattformen und Browser |
Open-Source-Entwicklung der Datenbanksoftware |
Support |
Problemmeldungen mit Web PTS verfolgen |
Das Datenbanksystem im Überblick |
SQL |
Transaktionen |
Logging von Transaktionen |
Log-Einstellungen |
Undo-Log-Verwaltung |
Redo-Log-Verwaltung |
History-Verwaltung |
Beispiel: Konsistente Sicht |
Verwendung der Log-Einträge bei Restart oder Wiederherstellung |
Log-Informationen auswerten |
Transaktionen wiederholen |
Beispiel: Restart |
Sperren für Datenbankobjekte |
Lesesperre |
Schreibsperre |
Optimistische Sperre |
Phänomene |
Parallelität von Sperren |
Isolation-Level |
Datenablage und -zugriff |
B*-Baum |
B*-Bäume für Tabellen mit LONG-Spalten |
B*-Bäume für Tabellen mit Indizes |
Belegungsausgleich |
Beispiel: SELECT-Anweisung |
Beispiel: INSERT-Anweisung |
Beispiel: DELETE-Anweisung |
Beispiel: UPDATE-Anweisung |
Savepoint |
Converter |
Datenbankwerkzeuge |
Schnittstellen |
Technische Systemlandschaft |
Netzwerkkommunikation |
Architektur der Datenbankwerkzeuge |
Architektur der Schnittstellen |
Datenverschlüsselung |
Beispiel: Systemlandschaft mit MaxDB-Datenbankinstanz |
Beispiel: SAP-Systemlandschaft mit zwei MaxDB-Datenbankinstanzen |
Prozessstruktur |
Übersicht der Prozesse |
Übersicht der Dienste |
Übersicht der Tasks |
Übersicht der Task-Zustände |
Task-Wechsel |
Load-Balancing |
Übersicht der Spezial-Threads |
Anlegen und Konfigurieren einer Datenbankinstanz |
Tipps zum Anlegen und Konfigurieren der Datenbankinstanz |
Konventionen für Datenbanknamen |
Technische Restriktionen |
Verzeichnisse |
Datenbankparameter |
Allgemeine Datenbankparameter |
Spezielle Datenbankparameter |
Support-Datenbankparameter |
liveCache-Datenbankparameter |
Eigenschaften von Datenbankparametern |
Konfigurationsdateien |
Automatischer Start |
Beispiel: Startskript für eine Datenbankinstanz (Linux) |
Verwaltung |
Regelmäßige Verwaltungsaufgaben |
Verwaltungsaufgaben automatisieren |
Übersicht der Datenbank-Events |
Benutzer, Authentifizierung und Berechtigungen |
Datenbanksystemadministrator (SYSDBA-Benutzer) |
Database Manager-Benutzer (DBM-Benutzer) |
Datenbankbenutzer |
Serverberechtigungen für den DBM-Server |
Konventionen für Benutzernamen und Kennwörter |
Authentifizierung |
Spezielle Betriebssystembenutzer und -gruppen (UNIX/Linux) |
<sdb_user> (spezieller Betriebssystembenutzer) |
<sdba_group> (spezielle Betriebssystemgruppe) |
Supportgruppe (spezielle Betriebssystemgruppe) |
Sichern und Wiederherstellen |
Sicherungsmedien |
Daten sichern |
Log-Einträge sichern |
Versionsdateien archivieren |
Datenbankinstanz wiederherstellen |
Beispiel: Sichern und Wiederherstellen |
Unterstützte Sicherungswerkzeuge anderer Anbieter |
Datenbereich einfrieren (Snapshot) |
Exportieren und Importieren |
Replikation und High-Availability |
Datenbankkopie |
Kompatible Prozessorarchitekturen für Datenbankkopien |
Schattendatenbank |
Einrichten einer Schatteninstanz |
Aktualisieren der Schatteninstanz |
Inbetriebnahme der Schatteninstanz als aktive Instanz |
Einlesen einer weiteren manuellen Log-Sicherung |
Einlesen der Log-Sicherungen bis zu einem bestimmten Zeitpunkt |
Kopieren der Log-Volumes der Originalinstanz |
Log-Sicherungen seit dem letzten Savepoint identifizieren |
Beispiel: Schattendatenbank |
Hot-Standby |
Systemanforderungen für ein Hot-Standby-System |
Architektur eines Hot-Standby-Systems |
Synchronisation von Master- und Standby-Instanzen |
Verhalten des Hot-Standby-Systems im Fehlerfall |
Synchronisation |
Überwachung |
Performance |
Tipps zum Datenbank-Design |
Automatisches Umformen von SQL-Anweisungen |
SQL-Optimierer |
Arbeitsweise des Optimierers |
Suchbedingungen |
Gleichheitsbedingung |
Bereichsbedingung |
IN-Bedingung |
LIKE-Bedingung |
Einschränkungen für UPDATE-Anweisungen |
Suchstrategien |
Sequentielle Suche |
Suchbedingungen für Schlüsselspalten |
Suchbedingungen für indizierte Spalten |
Beispiele: Suchbedingungen für indizierte Spalten |
Mit OR verknüpfte Suchbedingungen |
Verlagerung der Suche auf den FETCH-Zeitpunkt |
Joins |
Datenbankparameter JOIN_SEARCH_LEVEL |
Liste aller Suchstrategien |
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 |
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 KEY |
SUBQ CONDITION FOR KEY |
RANGE CONDITION FOR INDEX |
SUBQ CONDITION FOR INDEX |
INDEX SCAN |
TABLE SCAN |
Kostenermittlung |
Statistiken des SQL-Optimierers |
Beispiele |
example |
ind |
indf |
invcolumn1 |
invcolumn2 |
one |
ten1 |
ten2 |
Problemanalyse |
EXPLAIN-Anweisung |
EXPLAIN-Anweisung für Joins |
EXPLAIN-Anweisung für komplizierte SELECT-Anweisungen |
EXPLAIN-Anweisung für SELECT-Anweisungen mit Unterabfragen |
Spalte STRATEGY |
Fehlersuche |
Typische Fehlersituationen |
Protokolldateien |
Traces |
Datenbankstrukturen prüfen |
Fehler in der Datenstruktur beheben |
Beispiel: Fehler in der Datenstruktur |
Entwicklung von Datenbankanwendungen |
Beispiel: OpenOffice über ODBC an MaxDB anbinden (Microsoft Wind |
Beispiel: OpenOffice über JDBC an MaxDB anbinden (Linux) |
Anhang |
Betriebsmodus von Kommandozeilenprogrammen |
Syntaxnotation |
Variablen und Beispiele |
Glossar |
A |
Datenzugriff |
Verwaltung |
After-Image |
Anwendungsdaten |
Architektur |
ASCII |
Authentifizierung |
Berechtigung |
AUTOCOMMIT-Modus |
Automatische Log-Sicherung |
Automatischer Start |
Automatisierung |
B |
B*-Baum |
Backint for MaxDB |
Sichern |
Sicherungshistorie |
Sicherungskennung |
Sicherungsmedium |
Sicherungsart |
Before-Image |
BLOB |
C |
Cache |
Catalog-Cache |
Checkpoint |
Codeattribut |
Spalte |
Kommandomonitor |
COMMIT |
Kommunikationsserver |
Vollständige Datensicherung |
Konfiguration |
Konfigurationsverzeichnis |
Konfigurationsdatei |
Konsistente Sicht |
Converter |
Kritischer Abschnitt |
Cursor |
D |
Datenbereich |
Datensicherung |
Datenbank |
Datenbankadministrator (DBA-Benutzer) |
Database Analyzer |
Datenbankanwendung |
Datenbankkatalog |
Datenbankkopie |
Datenbank-Design |
Datenbankverzeichnis |
Datenbankdatei |
Datenbankfunktion |
Datenbank-ID |
Datenbankinstanz |
Database Manager |
Database Manager-Benutzer (DBM-Benutzer) |
Datenbankname |
Datenbankobjekt |
Datenbankparameter |
Datenbankprozedur |
Datenbanksitzung |
Datenbankstruktur |
Datenbanksystem |
Datenbanksystemadministrator (SYSDBA-Benutzer) |
Datenbankwerkzeug |
Datenbank-Trace |
Datenbankbenutzer |
Data-Cache |
Datenintegrität |
Datensatz |
Datentyp |
Data-Volume |
Data-Writer |
DBA |
DBA-Einplanungskalender |
DBMCLI |
DBM-Kommando |
DBMGUI |
DBM-Benutzer |
DBM-Benutzereigenschaften |
DBM-Option |
DBM-Server |
DDL-Anweisung |
Vorschlagsparameterdatei |
Demo-Datenbank |
Entwicklung |
Diagnosedatei |
Verzeichnisstruktur |
Dokumentation |
Download |
E |
Verschlüsselung |
Umgebungsvariable |
Event |
Event-Dispatcher |
Beispiele |
Schreibsperre |
Ausführungsplan |
EXPLAIN-Anweisung |
Exportieren |
Externe Sicherungskennung |
Externes Sicherungswerkzeug |
F |
Dateiklasse |
Dateiverzeichnis |
File-ID |
Fremdschlüssel |
G |
Garbage-Collector |
Gruppe paralleler Sicherungsmedien |
H |
High-Availability |
History-Datei |
Trefferquote |
Homogene Systemkopie |
Hot-Standby |
I |
Importieren |
Inkrementelle Datensicherung |
Index |
Indizierte Spalte |
Initialisieren |
Installation |
Installationsprofil |
Interaktive Log-Sicherung |
Datenbankinterne Datei |
Invertierungsliste |
Invertierte Spalte |
I/O-Buffer-Cache |
Isolation-Level |
J |
JDBC-Schnittstelle |
Join |
K |
Kern |
Kernprotokoll |
Kernvariante |
KNLDIAG |
L |
Sprachunterstützung (Mapchar-Sets) |
Blattseite |
liveCache (SAP liveCache) |
Laden |
Load-Balancing |
Loader |
Loader-Server |
Sperre |
Sperrliste |
Log-Bereich |
Log-Sicherung |
Log-Eintrag |
Protokolldatei |
Logging |
Log-Modus |
Log-Seite |
Log-Warteschlange |
Log-Leser |
Log-Segment |
Log-Einstellung |
Log-Volume |
Log-Writer |
LONG-Wert |
M |
Mailing-Liste |
Mapchar-Set |
MaxDB |
Message-Server |
Migration |
Überwachung |
Multi-Prozessor-Konfiguration |
N |
Namenskonventionen |
Netzwerk |
O |
ODBC-Schnittstelle |
OLTP (MaxDB) |
OMS |
OMS-Heap |
OMS-Version |
Open-Source-Entwicklung |
Betriebssystembenutzer |
Betriebsmodus |
Betriebszustand |
Optimistische Sperre |
Optimierer |
Überschreibmodus für den Log-Bereich |
Eigentümer |
P |
Seite |
Seitenkette |
Seitennummer |
Pager |
Parameter |
Parameterdatei |
Parameter in SQL-Anweisungen |
Performance |
Perl-Schnittstelle |
PHP-Schnittstelle |
Port |
Precompiler |
Prepared Statement |
Primärschlüssel |
Privileg |
Prozess |
Programmierschnittstelle |
PTS (Problem Tracking System) |
Python-Schnittstelle |
Q |
Query Tool |
R |
Reader-Writer-Lock |
Redo-Liste |
Redo-Log-Eintrag |
Redo-Log-Datei |
Redo-Log-Verwaltung |
Redo-Log-Manager |
Redo-Task |
Region |
Reorganisation |
Replikation |
Replikationstabelle |
Replikationseinheit |
RESOURCE-Benutzer |
Ressourcenmonitor |
Restart |
Restart-Record |
Wiederherstellen |
Rolle |
ROLLBACK |
ROLL FORWARD |
Zeile |
S |
SAP DB |
Savepoint |
Scheduler |
Schema |
sdb |
sdba |
Suchstrategie |
Sekundärschlüssel |
Selektivität |
Separator |
Sequenz |
Sequence-Cache |
Serverberechtigung |
Server-Task |
Dienst |
Service-Datenbankinstanz |
Service-Sitzung |
Shared-Memory |
Shared-SQL |
Lesesperre |
Snapshot |
Softwarekomponente |
Spezial-Thread |
SQL |
SQLCLI |
SQLDBC |
SQL-Modus |
SQL-Optimierer |
SQL-Sitzung |
SQL-Anweisung |
SQL Studio |
SQL-Tutorial |
SSL/TLS |
STANDARD-Benutzer |
Schattendatenbank |
Starten |
Statistiken |
Stored Procedure |
Subtransaktion |
Support |
Synchronisation |
Synchronization Manager |
Synchronisationsbenutzer |
Synonym |
Syntaxnotation |
SYSDBA-Benutzer |
Systemkopie |
Systemausfall |
Systemtabelle |
System-Trigger |
T |
Tabelle |
Tabellen-ID |
Tabellenname |
Task |
Task-Zustand |
Thread |
Timer-Task |
Timeout-Wert |
Trace |
Trace-Writer-Task |
Transaktion |
Transaktionsdatei |
Transaktionsliste |
Trigger |
Fehlersuche |
Tutorial |
U |
Undo-Log-Eintrag |
Undo-Log-Datei |
UNICODE |
Entladen |
Update |
Upgrade |
Benutzer |
Benutzerdefinierte Funktion |
Benutzergruppe |
User-Kernel-Thread |
Benutzerschlüssel |
User-Task |
Utility-Task |
V |
Wertebereich |
Variable |
Version |
Versionsdatei der Log-Sicherung |
View |
View-Tabelle |
VMAKE |
Volume |
vserver |
vtrace |
W |
WebDAV |
Web DBM |
Web Server |
Web Server Manager |
Web SQL |
Web Tool |
Arbeitsverzeichnis |
X |
XCONS (Datenbankkonsole) |
X-Server |
XUSER |
Y |
Z |
 Glossar (deutsch) |
SQL-Tutorial |
Beispielschema HOTEL für das SQL-Tutorial |
SQL-Anweisungen für das Schema HOTEL |
Erläuterung der Tabellen im Schema HOTEL |
Erläuterung der Objekte im Schema HOTEL |
Datenanfrage |
Auswählen, Anordnen und Umbenennen von Spalten |
Auswählen und Anordnen von Zeilen |
Bedingungen: Vergleich, AND, OR, BETWEEN, IN |
Suchen nach Zeichenketten: LIKE |
Negative Bedingungen: NOT |
Bilden von Gruppen: GROUP BY, HAVING |
Arithmetische Operationen |
Funktionen |
Set-Funktionen |
Datums- und Zeitberechnungen |
Umwandeln von Werten |
Verändern von Zeichenketten |
Informationen über Zeichenketten |
Subquery: Innere Abfragen |
Joins: Informationen aus mehreren Tabellen |
Mengenoperationen: UNION, INTERSECT, EXCEPT |
Datendefinition |
Tabellen |
Constraints |
Primärschlüssel |
Fremdschlüsselbeziehungen zwischen Tabellen |
View-Tabellen |
Indizes |
Wertebereiche |
Datenbankprozeduren |
Datenbankfunktionen |
Datenbanktrigger |
Nummerngeneratoren für Tabellen |
Nummerngenerator für eine einzelne Spalte einer Tabelle |
Datenmanipulation |
Einfügen, Ändern, Löschen von Zeilen |
Autorisierung |
Datenbankbenutzer und ihre Privilegien |
Rollen |
Systemtabellen auswerten (Beispiele) |
Referenzhandbuch |
Datendefinition |
Datenintegrität absichern |
CREATE TABLE-Anweisung (create_table_statement) |
Spaltendefinition (column_definition) |
Datentyp (data_type) |
CHAR[ACTER]![Ende Ebene 7 Knoten CHAR[ACTER]](../../images/1x1.gif) |
VARCHAR |
LONG [VARCHAR]![Ende Ebene 7 Knoten LONG [VARCHAR]](../../images/1x1.gif) |
Codeattribut |
BOOLEAN |
FIXED |
FLOAT |
INT[EGER]![Ende Ebene 7 Knoten INT[EGER]](../../images/1x1.gif) |
SMALLINT |
DATE (Datumswert) |
TIME (Zeitwert) |
TIMESTAMP (Zeitstempelwert) |
NULL-Wert |
Spezial-NULL-Wert |
Zahl |
Zeichenkette |
Spaltenattribute (column_attributes) |
CONSTRAINT-Definition (constraint_definition) |
Referentielle CONSTRAINT-Definition (referential_constraint_defi |
Schlüsseldefinition (key_definition) |
UNIQUE-Definition (unique_definition) |
DROP TABLE-Anweisung (drop_table_statement) |
ALTER TABLE-Anweisung (alter_table_statement) |
ADD-Definition (add_definition) |
ALTER-Definition (alter_definition) |
COLUMN-Change-Definition (column_change_definition) |
DROP-Definition (drop_definition) |
MODIFY-Definition (modify_definition) |
RENAME TABLE-Anweisung (rename_table_statement) |
RENAME COLUMN-Anweisung (rename_column_statement) |
EXISTS TABLE-Anweisung (exists_table_statement) |
CREATE SCHEMA-Anweisung (create_schema_statement) |
RENAME SCHEMA-Anweisung (rename_schema_statement) |
DROP SCHEMA-Anweisung (drop_schema_statement) |
CREATE DOMAIN-Anweisung (create_domain_statement) |
DROP DOMAIN-Anweisung (drop_domain_statement) |
CREATE SEQUENCE-Anweisung (create_sequence_statement) |
DROP SEQUENCE-Anweisung (drop_sequence_statement) |
CREATE SYNONYM-Anweisung (create_synonym_statement) |
DROP SYNONYM-Anweisung (drop_synonym_statement) |
RENAME SYNONYM-Anweisung (rename_synonym_statement) |
CREATE VIEW-Anweisung (create_view_statement) |
INSERT-/UPDATE-/DELETE-Privileg für Eigentümer der View-Tabelle |
Änderbare Join-View-Tabelle |
DROP VIEW-Anweisung (drop_view_statement) |
RENAME VIEW-Anweisung (rename_view_statement) |
CREATE INDEX-Anweisung (create_index_statement) |
DROP INDEX-Anweisung (drop_index_statement) |
ALTER INDEX-Anweisung (alter_index_statement) |
RENAME INDEX-Anweisung (rename_index_statement) |
CREATE DBPROC[EDURE]-Anweisung (create_dbproc_statement)![Ende Ebene 4 Knoten CREATE DBPROC[EDURE]-Anweisung (create_dbproc_statement)](../../images/1x1.gif) |
Routine (routine) |
Allgemeine CASE-Anweisung (searched_case_statement) |
Einfache CASE-Anweisung (simple_case_statement) |
DROP DBPROC[EDURE]-Anweisung (drop_dbproc_statement)![Ende Ebene 4 Knoten DROP DBPROC[EDURE]-Anweisung (drop_dbproc_statement)](../../images/1x1.gif) |
CREATE SYSTEM TRIGGER-Anweisung (create_system_trigger_statement |
DROP SYSTEM TRIGGER-Anweisung (drop_system_trigger_statement) |
CREATE FUNCTION-Anweisung (create_function_statement) |
DROP FUNCTION-Anweisung (drop_function_statement) |
CREATE TRIGGER-Anweisung (create_trigger_statement) |
DROP TRIGGER-Anweisung (drop_trigger_statement) |
COMMENT ON-Anweisung (comment_on_statement) |
Autorisierung |
CREATE USER-Anweisung (create_user_statement) |
CREATE USERGROUP-Anweisung (create_usergroup_statement) |
DROP USER-Anweisung (drop_user_statement) |
DROP USERGROUP-Anweisung (drop_usergroup_statement) |
ALTER USER-Anweisung (alter_user_statement) |
ALTER USERGROUP-Anweisung (alter_usergroup_statement) |
RENAME USER-Anweisung (rename_user_statement) |
RENAME USERGROUP-Anweisung (rename_usergroup_statement) |
GRANT USER-Anweisung (grant_user_statement) |
GRANT USERGROUP-Anweisung (grant_usergroup_statement) |
ALTER PASSWORD-Anweisung (alter_password_statement) |
CREATE ROLE-Anweisung (create_role_statement) |
DROP ROLE-Anweisung (drop_role_statement) |
GRANT-Anweisung (grant_statement) |
REVOKE-Anweisung (revoke_statement) |
Datenmanipulation |
INSERT-Anweisung (insert_statement) |
Datentyp der Zielspalte und Datentyp des einzufügenden Wertes |
Join-View-Tabelle, QUERY-Ausdruck, CONSTRAINT-Definition, Trigge |
UPDATE-Anweisung (update_statement) |
DELETE-Anweisung (delete_statement) |
NEXT STAMP-Anweisung (next_stamp_statement) |
CALL-Anweisung (call_statement) |
Datenanfrage |
QUERY-Anweisung (query_statement) |
DECLARE CURSOR-Anweisung (declare_cursor_statement) |
Rekursive DECLARE CURSOR-Anweisung (recursive_declare_cursor_sta |
SELECT-Anweisung (select_statement) |
QUERY-Ausdruck (query_expression) |
Tabellenausdruck (table_expression) |
Subquery (subquery) |
ORDER-Klausel (order_clause) |
UPDATE-Klausel (update_clause) |
LOCK-Option (lock_option) |
FETCH-Anweisung (fetch_statement) |
CLOSE-Anweisung (close_statement) |
SINGLE SELECT-Anweisung (single_select_statement) |
EXPLAIN-Anweisung (explain_statement) |
Transaktionen |
CONNECT-Anweisung (connect_statement) |
SET-Anweisung (set_statement) |
COMMIT-Anweisung (commit_statement) |
ROLLBACK-Anweisung (rollback_statement) |
SUBTRANS-Anweisung (subtrans_statement) |
SAVEPOINT-/ROLLBACK TO-Anweisung (savepoint/rollback_to_statemen |
LOCK-Anweisung (lock_statement) |
UNLOCK-Anweisung (unlock_statement) |
RELEASE-Anweisung (release_statement) |
Statistiken |
UPDATE STATISTICS-Anweisung (update_statistics_statement) |
MONITOR-Anweisung (monitor_statement) |
SQL-Anweisungen: Überblick |
Kommentar (sql_comment) |
Häufig verwendete Syntaxelemente: Überblick |
CASCADE-Option (cascade_option) |
Zeichen (character) |
Spaltenspezifikation (column_spec) |
DEFAULT-Spezifikation (default_spec) |
DELETE-Regel (delete_rule) |
DISTINCT-Spezifikation (distinct_spec) |
DUPLICATES-Klausel (duplicates_clause) |
Ausdruck (expression) |
Spezifikation von Werten (extended_value_spec) |
Funktion (function_spec) |
Arithmetische Funktion (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) |
Konversionsfunktion (conversion_function) |
CHAR(a,t) |
CHR(a,n) |
HEX(a) |
HEXTORAW(a) |
NUM(a) |
Datums- und Zeitformat (datetimeformat) |
Datumsfunktion (date_function) |
ADDDATE/SUBDATE(t,a) |
DATEDIFF(t,s) |
DAYNAME/MONTHNAME(t) |
DAYOFWEEK/WEEKOFYEAR/DAYOFMONTH/DAYOFYEAR(t) |
MAKEDATE(a,b) |
Datenbankfunktionsaufruf (dbfunction_call) |
Extraktion (extraction_function) |
DATE(a) |
HOUR/MINUTE/SECOND(t) |
MICROSECOND(a) |
TIME(a) |
TIMESTAMP(a,b) |
YEAR/MONTH/DAY(t) |
Spezialfunktion (special_function) |
DECODE(x,y(i),...,z) |
GREATEST/LEAST(x,y,...) |
VALUE(x,y,...) |
Allgemeine CASE-Funktion (searched_case_function) |
Einfache CASE-Funktion (simple_case_function) |
Stringfunktion (string_function) |
ALPHA(x,n) |
ASCII(x) |
EXPAND(x,n) |
GET_OBJECTNAME(x,o) |
GET_SCHEMA(x,o) |
INITCAP(x) |
LFILL(x,a,n) |
LPAD(x,a,y,n) |
LTRIM(x,y) |
MAPCHAR(x,n,i) |
REPLACE(x,y,z) |
RFILL(x,a,n) |
RPAD(x,a,y,n) |
RTRIM(x,y) |
SOUNDEX(x) |
SUBSTR(x,a,b) |
TRANSLATE(x,y,z) |
TRIM(x,y) |
UPPER/LOWER(x) |
Verkettung (concatenation) |
Zeitfunktion (time_function) |
ADDTIME/SUBTIME(t,a) |
MAKETIME(h,m,s) |
TIMEDIFF(t,s) |
Trigonometrische Funktion (trigonometric_function) |
Schlüsselspezifikation (key_spec) |
Literal (literal) |
Festkommazahl (fixed_point_literal) |
Gleitkommazahl (floating_point_literal) |
Ganze Zahl ohne Vorzeichen (unsigned_integer) |
Ganze Zahl (integer) |
Parameterspezifikation (parameter_spec) |
Prädikat (predicate) |
BETWEEN-Prädikat (between_predicate) |
Boolesches Prädikat (bool_predicate) |
Vergleichsprädikat (comparison_predicate) |
DEFAULT-Prädikat (default_predicate) |
EXISTS-Prädikat (exists_predicate) |
IN-Prädikat (in_predicate) |
JOIN-Prädikat (join_predicate) |
LIKE-Prädikat (like_predicate) |
NULL-Prädikat (null_predicate) |
Mengenvergleichsprädikat (quantified_predicate) |
ROWNO-Prädikat (rowno_predicate) |
SOUNDS-Prädikat (sounds_predicate) |
SAMPLE-Definition (sample_definition) |
Suchbedingung (search_condition) |
Selektierte Spalte (select_column) |
Set-Funktion (set_function_spec) |
Zeichensatz (token) |
Bezeichner (identifier) |
Schlüsselwort (key_word) |
Funktionen: Überblick |
Namen: Überblick |
Alias-Name (alias_name) |
Spaltenname (column_name) |
Constraint-Name (constraint_name) |
Name einer Datenbankfunktion (dbfunction_name) |
Name einer Datenbankprozedur (dbproc_name) |
Domänenname (domain_name) |
Indexname (index_name) |
Indikatorname (indicator_name) |
Mapchar-Set-Name (mapchar_set_name) |
Kennwort (password) |
Parametername (parameter_name) |
Referenzname (reference_name) |
Name eines Referentiellen Constraints (referential_constraint_na |
Ergebnistabellenname (result_table_name) |
Rollenname (role_name) |
Schemaname (schema_name) |
Sequenzname (sequence_name) |
Synonymname (synonym_name) |
Tabellenname (table_name) |
Triggername (trigger_name) |
Benutzergruppenname (usergroup_name) |
Benutzername (user_name) |
Privilegien: Überblick |
Privilegienspezifikation (priv_spec) |
Privilegienspezifikation für ein Schema (schema_priv_spec) |
Syntaxverzeichnis |
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_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_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_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_column_definition |
modify_definition |
monitor_statement |
new_index_name |
new_schema_name |
new_table_name |
new_user_name |
new_usergroup_name |
next_stamp_statement |
not_reserved_key_word |
null_predicate |
numeric_literal |
object_spec |
old_index_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_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_table_name |
revoke_statement |
role_name |
rollback_statement |
rollback_to_statement |
routine |
routine_sql_statement |
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 |
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 |
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 |
Syntaxnotation |
Systemtabellen |
Allgemeine Hinweise |
Datenbankbegriffe |
Systemtabellen auswerten (Beispiele) |
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 |
Definitionen der Systemtabellen |
ACTIVECONFIGURATION |
BACKUPTHREADS |
CACHESTATISTICS |
CLASSCONTAINER_CHAINS |
CLASSCONTAINER_KEYS |
CLASSCONTAINER_ROOTS |
CLASSCONTAINERS |
COLUMNS |
COMMANDCACHESTATISTICS |
COMMANDSTATISTICS |
CONNECTEDUSERS |
CONNECTPARAMETERS |
CONSISTENTVIEWOPENTRANSACTIONS |
CONSISTENTVIEWS |
CONSTRAINTS |
DATACACHE |
DATASTATISTICS |
DATAVOLUMES |
DBPARAMETERS |
DBPROCEDURES |
DBPROCPARAMS |
DOMAINCONSTRAINTS |
DOMAINS |
FILEDIRECTORIES |
FILES |
FOREIGNKEYCOLUMNS |
FOREIGNKEYS |
FUNCTIONS |
GARBAGECOLLECTOR_STATISTICS |
HISTORYINFO |
HOTSTANDBYCOMPONENT |
HOTSTANDBYGROUP |
INDEXCOLUMNS |
INDEXES |
INDEXSTATISTICS |
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_ROW |
MONITOR_TRANS |
OBJECTLOCKS |
OMS_HEAP_STATISTICS |
OMS_LOCKOBJ_INFO |
OMSLOCKS |
OMS_VERSIONS |
OPTIMIZERINFORMATION |
OPTIMIZERSTATISTICS |
PACKAGES |
POSTUPGRADECHECKLIST |
READERWRITERLOCKINFORMATION |
READERWRITERLOCKSTATISTICS |
READERWRITERLOCKSTATISTICSRESET |
READERWRITERLOCKWAITINGTASKS |
RESTARTINFORMATION |
ROLEPRIVILEGES |
ROLES |
SCHEMAPRIVILEGES |
SCHEMAS |
SEQUENCES |
SERVERDBSTATISTICS |
SERVERTASKS |
SESSION_ROLES |
SESSIONS |
SNAPSHOTS |
SPINLOCKPOOLSTATISTICS |
SPINLOCKSTATISTICS |
SYNONYMS |
SYSTEMTRIGGERS |
SYSUPGRADEHISTORY |
TABLEPRIVILEGES |
TABLES |
TABLESTATISTICS |
TASKLOADBALANCINGINFORMATION |
TASKLOADBALANCINGTASKGROUPSTATES |
TASKLOADBALANCINGTASKMOVES |
TRANSACTIONHISTORY |
TRANSACTIONS |
TRANSACTIONS |
TRIGGERS |
UNLOADEDSTATEMENTS |
USERS |
USERSTATISTICS |
VERSION |
VERSIONS |
VIEWCOLUMNS |
VIEWDEFS |
VIEWS |
Restriktionen für SQL-Anweisungen |
SQL-Modus ORACLE |
SQL-Syntaxelemente |
Datenbankobjekt |
Name |
Namensraum |
Zugriff auf Objekte |
Ganze Zahl |
Zahl |
Datentyp |
Pseudospalte |
Operator |
Funktion |
Format |
SQL-Anweisungen |
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 |
Systemtabellen |
Fehlermeldungen |
Variablen und Beispiele |
Meldungen |
Nummernkreise |
Von -1 bis -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 |
Von -900 bis -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 |
Von -1000 bis -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) |
Von -2000 bis -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 |
Von -3000 bis -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 |
Von -4000 bis -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 |
-4030: Unknown schema |
Von -5000 bis -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 |
Von -6000 bis -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 |
Von -7000 bis -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 |
Von -8000 bis -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 |
-8888: SERVERDB not accessible |
-9000: System error: Not yet implemented |
-9001 bis -9799: System error |
Von -10000 bis -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>]![Ende Ebene 4 Knoten -10300: Invalid parameter index [<number>]](../../images/1x1.gif) |
-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>]![Ende Ebene 4 Knoten -10807: Connection down: [<description>]](../../images/1x1.gif) |
-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 |
Von -11000 bis -11099 |
Von -11100 bis -11199 |
Von -22000 bis -22999 |
-22000: Null values not allowed on more than one long column |
-22005: Connection timeout occurred. Session reconnected |
Von -23000 bis -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 |
Von -24000 bis -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 ressources afte |
-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_XPMAX - parameter value higher than maximum 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 |
Von -25000 bis -25999 |
-25003: Name of database host could not be determined |
-25004: Error when connecting to the database |
-25005: Error when logging user on to the database |
-25006: Error occurred when connecting to the database with spec |
-25007: Error when executing the command; no connection to the d |
-25008: Error when logging on user; previous user's database con |
-25009: Failure in db communication |
-25010: <SQL_error_text> |
-25011: Error when executing the internal SQL command |
-25018: Error when changing the authorizations for the log file; |
-25019: Error when opening the log file; temporary log file open |
-25020: Memory space exhausted |
-25021: Error switching connected user to ; |
-25022: Request to terminate operation received; processing of c |
-25109: <command> not implemented |
-25201: Invalid length specification for INTEGER field |
-25202: Invalid length specification for REAL field |
-25203: Invalid length specification for DECIMAL field |
-25204: Invalid length specification for ZONED field |
-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 rec |
-25208: Invalid position specification; specify a positive value |
-25209: Invalid value for FRACTION; specify a positive value |
-25210: Invalid value for SCALE; enter a value between -127 and |
-25211: Invalid ROUND specification; specify a value between 0 a |
-25212: Invalid TRUNC specification; enter a value between 0 and |
-25213: Invalid file format specification; FORMATTED and COMPRES |
-25214: Invalid file format specification; Separator/Delimiter i |
-25216: File format specification FORMATTED required |
-25218: Invalid file format specification; no columns specified |
-25219: Columns must be specified in the command in ascending or |
-25220: Invalid separator/delimiter specification |
-25221: Invalid specification for representation of decimal numb |
-25222: Invalid specification for representation of Boolean valu |
-25223: Invalid specification for representation of NULL values |
-25224: Invalid specification for language of messages; specify |
-25225: Invalid specification for the representation of thousand |
-25226: Maximum number of column specifications in a command has |
-25227: Maximum number of conditions in a command has been excee |
-25228: Invalid specification for external representation of dat |
-25229: Incorrect comparison operator in condition |
-25230: Cannot execute command; specify an outfile for commands |
-25231: Specification of ROUND, TRUNC, or SCALE not allowed for |
-25232: Unknown 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 UPDATE COLUMNS command; specify set colum |
-25238: Cannot execute UPDATE COLUMNS command; specify access co |
-25239: Specified value is not a valid integer |
-25281: Syntax error at a certain position |
-25301: Invalid input for date or time column |
-25302: The value entered is not a valid numerical 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: Invalid HEX constant found in code page file; the file m |
-25308: CONSTRAINT condition violated |
-25309: Invalid input for BOOLEAN column |
-25310: Column must not contain NULL values |
-25311: No Data for NOT NULL - column without default |
-25313: Overflow occurred, execution aborted |
-25314: Fractional part too small for column, minimum length: |
-25315: Column data type of column and external data type are no |
-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: Unable to find any data for the column in the data file |
-25320: The LONG value could not be loaded into column |
-25321: This condition value is not a valid number: |
-25322: This condition value was truncated and cannot be used: ' |
-25323: Data type of null value representation for column is inc |
-25324: Errors checking length of column specifications. See loa |
-25325: Errors checking compatibility of external and db data ty |
-25326: The exported number (column ) was truncated |
-25327: Error(s) exporting record ; start position of incorrec |
-25328: Some error(s) while extracting data. See loader server l |
-25329: The given data file was not generated using EXPORT i |
-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 ( ): |
-25333: Error getting index definitions for table ( ) |
-25334: File counter for data file exceeded maximum value of |
-25335: Error restoring single table using data file with mul |
-25336: Error restoring multiple tables using data file with sin |
-25337: Error restoring table ; no table data found in data fi |
-25338: Error during restart IMPORT; restart entry not found |
-25339: Error during restart IMPORT; file could not be opened |
-25340: UCS2 conversion error; character string contains invalid |
-25341: Error generating 'create table/index statements' |
-25342: Error restoring table ; table exists but source table |
-25343: Column name(s) or number(s) do not match column names/nu |
-25344: Incorrect field length for column , minimum length |
-25351: No long file info given for LONG column |
-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 |
-25501: Error when opening file |
-25502: Error when closing file |
-25503: Error when reading file |
-25504: Error when writing file |
-25505: Error when erasing file |
-25507: Error when shrinking file |
-25801: Internal program error |
Von -27000 bis -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 users |
-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 bis -28999: Internal Error |
Von 0 bis 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 violation |
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 |
Von 25000 bis 25999 |
25601: Output of NULL values for column will be truncated |
25602: Possible overflow of integer values for column |
25603: Output of literal will be truncated |
25604: Surplus long file info (column name/id ) ignored |
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 too small. Row does not fit onto database |
25608: Restart file not found; starting import from the beginnin |
MaxDB-Sicherheitsleitfaden |
Einführung |
Bevor Sie anfangen |
Technische Systemlandschaft |
Benutzerverwaltung und -authentifizierung |
Kennwörter von Standardbenutzern ändern |
Protokolldateien auf fehlgeschlagene Anmeldeversuche überprüfen |
Berechtigungen |
Klare Berechtigungen für Benutzer definieren |
Netzwerk- und Kommunikationssicherheit |
Kommunikationskanäle absichern |
MaxDB X-Server hinter einer Firewall verwenden |
Web Tools hinter einer Firewall verwenden |
Sicherheit der Datenablage |
Zugriffsrechte auf Datenbankressourcen einschränken (UNIX/Linux |
Zugriff auf Datenbankressourcen einschränken (Microsoft Windows) |
Kennwörter von SAP Standard-Betriebssystembenutzern ändern |
Überflüssige Funktionen mit Auswirkungen auf die Sicherheit |
MaxDB X-Server bei lokaler Kommunikation ausschalten |
MaxDB X-Server ohne NI-Unterstützung starten (UNIX/Linux) |
Demo-Daten entfernen |
Weitere sicherheitsrelevante Informationen |
Benutzereingaben in SQL-Anweisungen überprüfen |
Trace- und Protokolldateien |
Zugriff auf Protokolldateien einschränken |
Anhang |