Developing on Database MaxDB |
Getting Involved |
Technical System Landscape |
MaxDB Security Guide |
Introduction |
Before You Start |
Technical System Landscape |
User Administration and Authentication |
Changing the Passwords of Standard Users |
Checking Log Files for Failed Logon Attempts |
Authorizations |
Defining Clear Authorizations for Users |
Network and Communication Security |
Securing Communication Channels |
Using the MaxDB X Server Behind a Firewall |
Using Web Tools Behind a Firewall |
Data Storage Security |
Restricting Access to Database Resources (UNIX/Linux up to Datab |
Changing the Passwords of SAP Standard Operating System Users |
Dispensable Functions with Impacts on Security |
Switching Off the MaxDB X Server for Local Communication |
Starting the MaxDB X Server Without NI Support (Unix/Linux) |
Removing Demo Data |
Other Security-Relevant Information |
Checking User Input in SQL Statements |
Trace and Log Files |
Restricting Access to Log Files |
Appendix |
Reference |
SQL Tutorial |
HOTEL Demo Schema for the SQL Tutorial |
SQL Statements for the HOTEL Schema |
Explanation of the Tables in the HOTEL Schema |
Explanation of the Objects in the HOTEL Schema |
Data Query |
Selecting, Arranging, and Renaming Columns |
Selecting and Arranging Rows |
Conditions: Comparison, AND, OR, BETWEEN, IN |
Searching for Character Strings: LIKE |
Negative Conditions: NOT |
Creating Groups: GROUP BY, HAVING |
Arithmetic Operations |
Functions |
Set Functions |
Date and Time Calculations |
Converting Values |
Changing Character Strings |
Information About Character Strings |
Subquery: Internal Queries |
Joins: Information from Several Tables |
Set Operations: UNION, INTERSECT, EXCEPT |
Data Definition |
Tables |
Constraints |
Primary Key |
Foreign Key Dependencies Between Tables |
View Tables |
Indexes |
Domains |
Database Procedures |
Database Functions |
Database Triggers |
Number Generators for Tables |
Number Generator for a Single Table Column |
Data Manipulation |
Inserting, Changing, and Deleting Rows |
Authorization |
Database Users and Their Privileges |
Roles |
Evaluating System Tables (Examples) |
Reference Manual |
Data definition |
Ensuring Data Integrity |
CREATE TABLE statement |
Column Definition (column_definition) |
Data Type (data_type) |
CHAR[ACTER]![Leaving Level 8 Node CHAR[ACTER]](../../images/1x1.gif) |
VARCHAR |
LONG[VARCHAR]![Leaving Level 8 Node LONG[VARCHAR]](../../images/1x1.gif) |
Code Attribute |
BOOLEAN |
FIXED |
FLOAT |
INT[EGER]![Leaving Level 8 Node INT[EGER]](../../images/1x1.gif) |
SMALLINT |
DATE (Date Value) |
TIME (Time Value) |
TIMESTAMP (Time Stamp Value) |
NULL Value |
Special NULL value |
Number |
Character String |
Column Attributes (column_attributes) |
CONSTRAINT definition |
Referential CONSTRAINT Definition (referential_constraint_defini |
Key definition |
UNIQUE Definition (unique_definition) |
DROP TABLE statement |
ALTER TABLE statement |
ADD Definition (add_definition) |
ALTER Definition (alter_definition) |
COLUMN Change Definition (column_change_definition) |
DROP definition |
MODIFY Definition (modify_definition) |
RENAME TABLE statement |
RENAME COLUMN Statement (rename_column_statement) |
EXISTS TABLE Statement (exists_table_statement) |
CREATE SCHEMA Statement (create_schema_statement) |
RENAME SCHEMA Statement (rename_schema_statement) |
DROP SCHEMA Statement (drop_schema_statement) |
CREATE DOMAIN statement |
DROP DOMAIN Statement (drop_domain_statement) |
CREATE SEQUENCE Statement (create_sequence_statement) |
DROP SEQUENCE statement) |
CREATE SYNONYM Statement (create_synonym_statement) |
DROP SYNONYM Statement (drop_synonym_statement) |
RENAME SYNONYM Statement (rename_synonym_statement) |
CREATE VIEW Statement (create_view_statement) |
INSERT/UPDATE/DELETE Privilege for Owners of View Tables |
Updateable Join View Table |
DROP VIEW Statement (drop_view_statement) |
RENAME VIEW Statement (rename_view_statement) |
CREATE INDEX Statement (create_index_statement) |
DROP INDEX statement |
ALTER INDEX Statement (alter_index_statement) |
RENAME INDEX Statement (rename_index_statement) |
CREATE DBPROC[EDURE] Statement (create_dbproc_statement)![Leaving Level 5 Node CREATE DBPROC[EDURE] Statement (create_dbproc_statement)](../../images/1x1.gif) |
Routine (routine) |
General CASE Statement (searched_case_statement) |
Simple CASE Statement (simple_case_statement) |
DROP DBPROC[EDURE] Statement (drop_dbproc_statement)![Leaving Level 5 Node DROP DBPROC[EDURE] Statement (drop_dbproc_statement)](../../images/1x1.gif) |
CREATE SYSTEM TRIGGER Statement (create_system_trigger_statement |
DROP SYSTEM TRIGGER Statement (drop_system_trigger_statement) |
CREATE FUNCTION Statement (create_function_statement) |
DROP FUNCTION Statement (drop_function_statement) |
CREATE TRIGGER Statement (create_trigger_statement) |
DROP TRIGGER statement |
COMMENT ON Statement (comment_on_statement) |
Authorization |
CREATE USER Statement (create_user_statement) |
CREATE USERGROUP Statement (create_usergroup_statement) |
DROP USER Statement (drop_user_statement) |
DROP USERGROUP Statement (drop_usergroup_statement) |
ALTER USER Statement (alter_user_statement) |
ALTER USER GROUP Statement (alter_usergroup_statement) |
RENAME USER statement |
RENAME USERGROUP Statement (rename_usergroup_statement) |
GRANT USER Statement (grant_user_statement) |
GRANT USERGROUP Statement (grant_usergroup_statement) |
ALTER PASSWORD Statement |
CREATE ROLE statement |
DROP ROLE statement |
GRANT statement |
REVOKE statement |
Data Manipulation |
INSERT Statement (insert_statement) |
Data Type of the Target Column and Inserted Value |
Join View Table, QUERY Expression, CONSTRAINT Definition, Trigge |
UPDATE Statement (update_statement) |
DELETE Statement (delete_statement) |
NEXT STAMP Statement (next_stamp_statement) |
CALL statement |
Data query |
QUERY Statement (query statement) |
DECLARE CURSOR statement (declare_cursor_statement) |
Recursive DECLARE CURSOR Statement |
SELECT Statement (select_statement) |
QUERY expression (query expression) |
Table Expression (table_expression) |
Subquery (subquery) |
ORDER clause |
UPDATE Clause (update_clause) |
LOCK Option (lock_option) |
FETCH Statement (fetch_statement) |
CLOSE Statement (close_statement) |
SINGLE SELECT statement (single_select_statement) |
EXPLAIN Statement (explain_statement) |
Transactions |
CONNECT Statement (connect_statement) |
SET Statement (set_statement) |
COMMIT Statement (commit_statement) |
ROLLBACK Statement (rollback_statement) |
SUBTRANS Statement (subtrans_statement) |
SAVEPOINT/ROLLBACK TO Statement (savepoint/rollback_to_statement |
LOCK Statement (lock_statement) |
UNLOCK Statement (unlock_statement) |
RELEASE Statement (release_statement) |
Statistics |
UPDATE STATISTICS Statement (update_statistics_statement) |
MONITOR Statement (monitor_statement) |
SQL Statements: Overview |
Comment (sql_comment) |
Frequently Used Syntax Elements: Overview |
CASCADE Option (cascade_option) |
Character |
Column Specification (column spec) |
DEFAULT Specification (default_spec) |
DELETE Rule (delete_rule) |
DISTINCT function (distinct spec) |
DUPLICATES Clause (duplicates_clause) |
Expression |
Specifications of Values (extended_value_spec) |
Function (function spec) |
Arithmetic Function (arithmetic_function) |
ABS(a) |
CEIL(a) |
EXP(a) |
FIXED(a,p,s) |
FLOAT(a,s) |
FLOOR(a) |
INDEX(a,b,p,s) |
LENGTH(a) |
LN(a) |
LOG(a,b) |
NOROUND(a) |
PI |
POWER(a,n) |
ROUND(a,n) |
SIGN(a) |
SQRT(a) |
TRUNC(a,n) |
Conversion Function (conversion_function) |
CHAR(a,t) |
CHR(a,n) |
HEX(a) |
HEXTORAW(a) |
NUM(a) |
Date and Time Format (datetimeformat) |
Date function |
ADDDATE/SUBDATE(t,a) |
DATEDIFF(t,s) |
DAYNAME/MONTHNAME(t) |
DAYOFWEEK/WEEKOFYEAR/DAYOFMONTH/DAYOFYEAR(t) |
MAKEDATE(a,b) |
Database Function Call (dbfunction_call) |
Extraction function |
DATE(a) |
HOUR/MINUTE/SECOND(t) |
MICROSECOND(a) |
TIME(a) |
TIMESTAMP(a,b) |
YEAR/MONTH/DAY(t) |
Special Function (special_function) |
DECODE(x,y(i),...,z) |
GREATEST/LEAST(x,y,...) |
VALUE(x,y,...) |
General CASE Function (searched_case_function) |
Simple CASE Function (simple_case_function) |
String Function (string_function) |
ALPHA(x,n) |
ASCII(x) |
EXPAND(x,n) |
GET_OBJECTNAME(x,o) |
GET_SCHEMA(x,o) |
INITCAP(x) |
LFILL(x,a,n) |
LPAD(x,a,y,n) |
LTRIM(x,y) |
MAPCHAR(x,n,i) |
REPLACE(x,y,z) |
RFILL(x,a,n) |
RPAD(x,a,y,n) |
RTRIM(x,y) |
SOUNDEX(x) |
SUBSTR(x,a,b) |
TRANSLATE(x,y,z) |
TRIM(x,y) |
UPPER/LOWER(x) |
Concatenation |
Time Function (time_function) |
ADDTIME/SUBTIME(t,a) |
MAKETIME(h,m,s) |
TIMEDIFF(t,s) |
Trigonometric Function (trigonometric_function) |
Key Specification (key_spec) |
Literal (literal) |
Fixed Point Number (fixed_point_literal) |
Floating Point Number (floating_point_literal) |
Unsigned integer (unsigned_integer) |
Integer (integer) |
Parameter Specification (parameter spec) |
Predicate |
BETWEEN predicate |
Boolean Predicate (bool_predicate) |
Comparison predicate |
DEFAULT Predicate (default predicate) |
EXISTS predicate |
IN predicate |
JOIN Predicate (join_predicate) |
LIKE Predicate (like_predicate) |
NULL predicate |
Quantified predicate |
ROWNO predicate |
SOUNDS Predicate (sounds_predicate) |
SAMPLE Definition (sample_definition) |
Search Condition (search_condition) |
Selected Column (select_column) |
Set Function (set_function_spec) |
Character Set (token) |
Identifier |
Keyword (key_word) |
Functions: Overview |
Names: Overview |
Alias Name (alias_name) |
Column Name (column_name) |
Constraint Name (constraint_name) |
Name of a Database Function (dbfunction_name) |
Name of a database procedure (dbproc_name) |
Domain Name (domain_name) |
Index Name (index_name) |
Indicator Name (indicator_name) |
MapChar Set Name (mapchar_set_name) |
Password (password) |
Parameter Name (parameter_name) |
Reference Name (reference_name) |
Name of a Referential Constraint (referential_constraint_name) |
Results Table Name (result_table_name) |
Role Name (role_name) |
Schema Name (schema_name) |
Sequence Name (sequence_name) |
Synonym Name (synonym_name) |
Table Name (table_name) |
Trigger Name (trigger_name) |
User Group Name (usergroup_name) |
User Name (user_name) |
Privileges: Overview |
Privilege Specification (priv_spec) |
Privilege Specification for a Schema (schema_priv_spec) |
Syntax List |
add_definition |
alias_name |
all_function |
alter_definition |
alter_index_statement |
alter_password_statement |
alter_table_statement |
alter_user_statement |
alter_usergroup_statement |
argument |
argument1 |
arithmetic_function |
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 |
Syntax Notation |
Syntax Changes |
System Tables |
General Notes |
Database Terms |
Evaluating System Tables (Examples) |
ACTIVECONFIGURATION |
CACHESTATISTICS |
COLUMNS |
CONSTRAINTS |
DATASTATISTICS |
DATAVOLUMES |
DBPROCEDURES |
DBPROCPARAMS |
DOMAINCONSTRAINTS |
DOMAINS |
FOREIGNKEYCOLUMNS |
FOREIGNKEYS |
FUNCTIONS |
INDEXCOLUMNS |
INDEXES |
INSTANCE |
LOCKS |
LOGQUEUESTATISTICS |
LOGSTATISTICS |
MAPCHARSETS |
ROLEPRIVILEGES |
ROLES |
SEQUENCES |
SESSION_ROLES |
SESSIONS |
SYNONYMS |
TABLEPRIVILEGES |
TABLES |
TRIGGERS |
USERS |
VERSION |
VIEWCOLUMNS |
VIEWDEFS |
VIEWS |
Definitions of the System Tables |
ACTIVECONFIGURATION |
BACKUPTHREADS |
CACHESTATISTICS |
CLASSCONTAINER_CHAINS |
CLASSCONTAINER_KEYS |
CLASSCONTAINER_ROOTS |
CLASSCONTAINERS |
COLUMNS |
COMMANDCACHESTATISTICS |
COMMANDSTATISTICS |
CONNECTEDUSERS |
CONNECTPARAMETERS |
CONSISTENTVIEWOPENTRANSACTIONS |
CONSISTENTVIEWS |
CONSTRAINTCOLUMNS |
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 |
REGIONINFORMATION |
RESTARTINFORMATION |
ROLEPRIVILEGES |
ROLES |
SCHEMAPRIVILEGES |
SCHEMAS |
SEQUENCES |
SERVERDBSTATISTICS |
SERVERTASKS |
SESSION_ROLES |
SESSIONS |
SNAPSHOTS |
SPINLOCKPOOLSTATISTICS |
SPINLOCKPOOLSTATISTICSRESET |
SPINLOCKSTATISTICS |
SPINLOCKSTATISTICSRESET |
SYNONYMS |
SYSTEMTRIGGERS |
SYSUPDSTATWANTED |
SYSUPGRADEHISTORY |
TABLEPRIVILEGES |
TABLES |
TABLESTATISTICS |
TASKGROUPSTATISTICS |
TASKGROUPSTATISTICSRESET |
TASKLOADBALANCINGINFORMATION |
TASKLOADBALANCINGTASKGROUPSTATES |
TASKLOADBALANCINGTASKMOVES |
TRANSACTIONHISTORY |
TRANSACTIONS |
TRANSACTIONS |
TRIGGERS |
UNLOADEDSTATEMENTS |
USERS |
USERSTATISTICS |
VERSION |
VERSIONS |
VIEWCOLUMNS |
VIEWDEFS |
VIEWS |
Restrictions for SQL Statements |
ORACLE SQL Mode |
SQL Syntax Elements |
Database Object |
Name |
Namespace |
Access to Objects |
Integer (whole number) |
Number |
Data Type |
Pseudo Column |
Operator |
Function |
Format |
SQL Statements |
alter_cluster_statement |
alter_database_statement |
alter_function_statement |
alter_index_statement |
alter_package_statement |
alter_procedure_statement |
alter_profile_statement |
alter_resource_cost_statement |
alter_role_statement |
alter_rollback_segment_statement |
alter_sequence_statement |
alter_snapshot_statement |
alter_snapshot_log_statement |
alter_system_statement |
alter_table_statement |
alter_tablespace_statement |
alter_trigger_statement |
alter_user_statement |
alter_view_statement |
analyze_statement |
audit_statement |
commit_statement |
constraint_clause |
create_cluster_statement |
create_controlfile_statement |
create_database_statement |
create_database_link_statement |
create_index_statement |
create_package_statement |
create_package_body_statement |
create_procedure_statement |
create_profile_statement |
create_rollback_segment_statement |
create_sequence_statement |
create_snapshot_statement |
create_snapshot_log_statement |
create_synonym_statement |
create_table_statement |
create_tablespace_statement |
create_trigger_statement |
create_user_statement |
create_view_statement |
declare_statement |
declare_table_statement |
delete_statement |
describe_statement |
drop_cluster_statement |
drop_database_link_statement |
drop_index_statement |
drop_procedure_statement |
drop_profile_statement |
drop_rollback_segment_statement |
drop_snapshot_statement |
drop_snapshot_log_statement |
drop_table_statement |
drop_tablespace_statement |
drop_trigger_statement |
drop_view_statement |
execute_statement |
explain_plan_statement |
grant_statement |
insert_statement (embedded SQL) |
lock_table_statement |
noaudit_statement |
rename_statement |
revoke_statement |
rollback_statement |
select_statement |
set_transaction_statement |
truncate_statement |
update_statement |
System Tables |
Error Messages |
Variables and Examples |
SQLDBC Manual |
Structure of SQLDBC |
SQLDBC Classes |
SQLDBC Traces |
sqldbc_cons |
JDBC Manual |
Adding the JDBC Driver to the Environment Variable CLASSPATH |
Registering the JDBC Driver in the JDBC Driver Manager |
Connecting to the Database Instance |
Defining the Connection URL |
Specifying Other Connection Options |
Setting Up an SSL Connection |
Calling the Method java.sql.DriverManager.getConnection |
Examples for Connecting to the Database Instance |
Exceptions |
Example of a Database Query |
Database Administration with Java |
Connecting to the Database Manager with Java |
Connecting to an Existing Database Instance |
Connection with a Specific Software Version |
Executing DBM Commands with Java |
Ending the Connection to the Database Manager |
Error Handling for Database Manager Errors |
Example for Displaying the Operational State of a Database Insta |
Exporting and Importing Data with Java |
Connecting to the Loader with Java |
Executing Loader Commands and SQL Statements with Java |
Ending the Connection to the Loader |
Error Handling for Loader Errors |
Example for Creating a Table with Java |
Variables and Examples |
ODBC Manual |
Supported ODBC Versions |
Properties of the MaxDB ODBC Driver |
Supported Data Types |
SQL Data Types |
C Data Types |
Conversion of SQL and C Data Types |
Processing SQL Statements |
Database Procedures |
Cursor Functions |
ODBC-API Compatibility |
Core API |
Level 1 API |
Remark for SQLGetConnectAttr |
Remark for SQLGetFunctions |
Remark for SQLGetInfo |
Level 2 API |
UNICODE Support |
The MaxDB ODBC Driver on Microsoft Windows |
Installation on Microsoft Windows |
Creating Data Sources on Microsoft Windows |
Options for Data Sources (Microsoft Windows) |
SQL Mode (Microsoft Windows) |
Isolation Level (Microsoft Windows) |
Logging SQL Statements (Microsoft Windows) |
Installed Files (Microsoft Windows) |
MaxDB ODBC Driver on UNIX/Linux |
Installation on UNIX/Linux |
Integration of the MaxDB ODBC driver |
Creating and Changing Data Sources on UNIX/Linux |
Options for Data Sources (UNIX/Linux) |
SQL Mode (UNIX/Linux) |
Isolation Level (UNIX/Linux) |
Logging SQL Statements (UNIX/Linux) |
Installed Files (UNIX/Linux) |
Perl Manual |
Configuring the Perl Modules |
Module SAP::DBTech::dbm |
DBM Class |
Method cmd |
Method rawCmd |
Method release |
Examples for the SAP::DBTech::dbm Module |
Troubleshooting for the Module SAP::DBTech::dbm |
Exception CommunicationError |
Exception DBMServError |
SAP::DBTech::loader Module |
Class Loader |
Method cmd |
Method rawCmd |
Method sql |
Method release |
Troubleshooting for the Module SAP::DBTech::loader |
Exception CommunicationError |
Exception LoaderError |
Examples for the SAP::DBTech::loader Module |
PHP Manual |
Python Manual |
Configuring the Python Modules |
sdb.dbm Module |
Class DBM |
cmd Method |
Method rawCmd |
Method release |
Error Handling for the sdb.dbm Module |
Class CommunicationError |
Class DBMServError |
Examples for the sdb.dbm Module |
Calling and Ending the Database Manager |
Displaying a list of all registered database instances |
Handling Error Situations |
sdb.loader Module |
Class Loader |
cmd Method |
Method rawCmd |
sql Method |
Method release |
Troubleshooting for the sdb.loader Module |
CommunicationError Class |
LoaderError Class |
Example 1 |
Example 2 |
Example 3 |
sdb.sql Module |
connect Method |
SapDB_Session Class |
Method sql |
Method sqlX |
Method prepare |
Method release |
Method commit |
Method rollback |
SapDB_ResultSet Class |
Method next |
Method previous |
Method relative |
Method absolute |
Method first |
Method last |
Method current |
Method __getitem__ |
Method getDescription |
Examples for SapDB_ResultSet |
SapDB_Prepared Class |
Method execute |
Method getDescription |
SapDB_Result Class |
Method getResultSet |
Method getOutputParameters |
Method getRowsAffected |
Method getLastSerial |
Method getFirstSerial |
SapDB_LongReader Class |
Method read |
Error Handling for the sdb.sql Module |
Class CommunicationError |
Class SQLError |
Possible SQL Results |
Examples for the sdb.sql Module |
CONNECT Statement |
Select Statement and Calling the Result Set Step-by-Step |
SELECT Statement and Calling the Result Set in a For Loop |
SELECT Statement and Displaying the Structure of the Result Set |
Executing an INSERT Statement Multiple Times With Different Para |
Handling Error Situations |
WebDAV |
Calling the WebDAV Servlet |
Checklist |