Adabas D vs. MaxDB

Diese Seite enthält einen Vergleich der SQL-Syntax von Adabas D (Version 13) mit der Syntax von MaxDB. Die Gegenüberstellung soll Adabas D-Anwender bei der Migration zu MaxDB unterstützen.

Die tabellarische Darstellung listet alle SQL-Syntaxelemente alphabetisch auf. Die rechte Spalte (Remark) zeigt an, ob die Syntax beider Systeme für die jeweiligen Elemente identisch ist oder voneinander abweicht. Kommandos, die es nur in dem einen oder dem andern System gibt, sind per se „different“.

Ein Klick auf einen Kommandoeintrag zeigt die vollständige Syntax in BNF-Form, und zwar für beide Systeme (Adabas D: Grammar1 vs. MaxDB: Grammar2), wobei die Ableitungsregeln als Hyperlinks implementiert sind. Die Link-Listen unter der jeweiligen Zwischenüberschrift Referenced by: zeigen die Kommandos, die das aktuelle Statement verwenden können. Die symbolische Darstellung ist in Form von interaktiven SVG-Grafiken hinterlegt.

Anmerkung: Die Vergleichsliste ist aus der Perspektive von Adabas D organisiert. Kommandos, die es in SAP MaxDB, aber nicht in Adabas gibt, finden sich daher am Ende der Liste.

Index AdabasD V13 versus MaxDB V7.6

AdabasD V13 MaxDB V7.6 Remark
add_definition add_definition different
alias_name alias_name identical
all_function all_function identical
alter_data_type different
alter_definition alter_definition identical
alter_password_statement alter_password_statement identical
alter_table_statement alter_table_statement different
alter_user_statement alter_user_statement different
alter_usergroup_statement alter_usergroup_statement different
arithmetic_function arithmetic_function different
between_predicate between_predicate identical
bool_predicate bool_predicate identical
boolean_factor boolean_factor identical
boolean_term boolean_term identical
cascade_option cascade_option identical
character character identical
check_expression check_expression identical
clear_snapshot_log_statement different
close_statement close_statement identical
column_attributes column_attributes different
column_change_definition column_change_definition different
column_definition column_definition identical
column_name column_name identical
column_spec column_spec identical
comment comment identical
comment_on_statement comment_on_statement identical
commit_statement commit_statement different
comp_op comp_op different
comparison_predicate comparison_predicate identical
complement_sign different
connect_statement connect_statement different
constraint_definition constraint_definition identical
constraint_name constraint_name identical
conversion_function conversion_function different
create_domain_statement create_domain_statement identical
create_index_statement create_index_statement different
create_snapshot_log_statement different
create_snapshot_statement different
create_synonym_statement create_synonym_statement different
create_table_statement create_table_statement different
create_user_statement create_user_statement different
create_usergroup_statement create_usergroup_statement different
create_view_statement create_view_statement identical
data_type data_type different
date_function date_function identical
date_or_timestamp_expression date_or_timestamp_expression identical
datetimeformat datetimeformat identical
db_procedure different
declare_cursor_statement declare_cursor_statement identical
default_expression default_expression identical
default_predicate default_predicate identical
default_spec default_spec different
delete_rule delete_rule identical
delete_statement delete_statement different
delimiter_token delimiter_token different
derived_column different
digit digit identical
digit_sequence digit_sequence identical
dir1_spec different
dir2_spec different
distinct_function distinct_function identical
distinct_spec distinct_spec identical
domain_name domain_name different
double_quotes double_quotes identical
drop_definition drop_definition different
drop_domain_statement drop_domain_statement identical
drop_index_statement drop_index_statement different
drop_snapshot_log_statement different
drop_snapshot_statement different
drop_synonym_statement drop_synonym_statement different
drop_table_statement drop_table_statement identical
drop_user_statement drop_user_statement identical
drop_usergroup_statement drop_usergroup_statement identical
drop_view_statement drop_view_statement identical
duplicates_clause duplicates_clause identical
equal_or_not equal_or_not identical
exists_predicate exists_predicate identical
exists_table_statement exists_table_statement identical
explain_statement explain_statement identical
exponent exponent identical
expression expression identical
expression_list expression_list identical
extended_expression extended_expression identical
extended_letter extended_letter identical
extended_value_spec extended_value_spec identical
extraction_function extraction_function identical
factor factor different
fetch_statement fetch_statement identical
first_character first_character identical
first_password_character first_password_character identical
fixed_point_literal fixed_point_literal identical
floating_point_literal floating_point_literal identical
from_clause from_clause identical
from_table_spec from_table_spec different
function_spec function_spec different
grant_statement grant_statement different
grant_user_statement grant_user_statement identical
grant_usergroup_statement grant_usergroup_statement identical
granted_usergroups granted_usergroups identical
granted_users granted_users identical
grantee grantee different
group_clause group_clause identical
having_clause having_clause identical
hex_digit hex_digit identical
hex_digit_seq hex_digit_seq identical
hex_literal hex_literal identical
hours hours identical
identifier identifier identical
identifier_tail_character identifier_tail_character identical
in_predicate in_predicate identical
index_name index_name identical
index_name_spec different
index_pos_spec different
indicator_name indicator_name identical
insert_statement insert_statement different
join_predicate join_predicate identical
key_definition key_definition identical
key_or_not_null_spec key_or_not_null_spec identical
key_spec key_spec identical
key_word key_word different
language_specific_character language_specific_character different
letter letter identical
like_expression like_expression identical
like_predicate like_predicate identical
literal literal identical
lock_option lock_option different
lock_spec lock_spec identical
lock_statement lock_statement identical
mantissa mantissa identical
mapchar_set_name mapchar_set_name identical
match_char match_char different
match_class different
match_element different
match_range different
match_set match_set different
match_string match_string different
minutes minutes identical
monitor_statement monitor_statement different
named_query_expression different
named_query_primary different
named_query_spec different
named_query_term different
named_select_statement different
new_password new_password identical
new_synonym_name new_synonym_name different
new_table_name new_table_name different
next_stamp_statement next_stamp_statement different
not_restricted_key_word different
null_predicate null_predicate identical
numeric_literal numeric_literal identical
object_spec object_spec different
old_password old_password identical
old_synonym_name old_synonym_name different
old_table_name old_table_name identical
open_cursor_statement different
order_clause order_clause identical
outer_join_indicator outer_join_indicator identical
owner different
parameter_name parameter_name different
parameter_spec parameter_spec identical
password password identical
password_spec different
pattern_element pattern_element identical
pos1_spec different
pos2_spec different
position position different
predicate predicate identical
priv_spec priv_spec different
privilege privilege different
procedure_name different
program_name different
quantified_predicate quantified_predicate different
quantifier different
query_expression query_expression identical
query_primary query_primary identical
query_spec query_spec identical
query_statement query_statement different
query_term query_term identical
reference_name reference_name identical
referenced_column referenced_column identical
referenced_table referenced_table identical
referencing_column referencing_column identical
referential_constraint_definition referential_constraint_definition identical
referential_constraint_name referential_constraint_name identical
refresh_statement different
regular_token regular_token identical
release_statement release_statement identical
rename_column_statement rename_column_statement identical
rename_synonym_statement rename_synonym_statement different
rename_table_statement rename_table_statement identical
rename_view_statement rename_view_statement identical
reserved_key_word reserved_key_word different
restricted_key_word different
result_column_name result_column_name identical
result_expression result_expression identical
result_table_name result_table_name identical
revoke_statement revoke_statement different
rollback_statement rollback_statement different
row_spec row_spec identical
rowno_column different
rowno_predicate rowno_predicate different
rowno_spec different
search_and_result_spec search_and_result_spec identical
search_condition search_condition identical
search_expression search_expression identical
seconds seconds identical
select_column select_column different
select_direct_statement_positioned different
select_direct_statement_searched different
select_ordered_format1_positioned different
select_ordered_format1_searched different
select_ordered_format2_positioned different
select_ordered_format2_searched different
select_ordered_statement_positioned different
select_ordered_statement_searched different
select_statement select_statement different
set_function_name set_function_name different
set_function_spec set_function_spec identical
set_insert_clause set_insert_clause identical
set_update_clause set_update_clause different
sign sign identical
simple_identifier simple_identifier identical
single_select_statement single_select_statement different
sort_option different
sort_spec sort_spec different
sound_predicate sound_predicate identical
source_table different
source_user source_user identical
special_character special_character different
special_function special_function different
special_identifier special_identifier identical
special_identifier_character special_identifier_character different
sql_statement sql_statement different
stamp_column different
start_value different
string_function string_function different
string_literal string_literal different
string_spec string_spec identical
subquery subquery identical
subtrans_statement subtrans_statement identical
synonym_name synonym_name identical
table_columns different
table_description_element table_description_element different
table_expression table_expression identical
table_name table_name different
table_option different
table_privileges different
term term identical
termchar_set_name different
time_expression time_expression identical
time_function time_function different
time_or_timestamp_expression time_or_timestamp_expression identical
token token identical
trigger_name trigger_name identical
trigonometric_function trigonometric_function identical
underscore underscore identical
unique_definition unique_definition different
unlock_statement unlock_statement identical
unsigned_integer unsigned_integer different
update_clause update_clause different
update_columns_and_values different
update_statement update_statement different
update_statistics_statement update_statistics_statement different
user_mode different
user_name user_name identical
userdefined_function different
usergroup_mode different
usergroup_name usergroup_name identical
value_spec value_spec different
where_clause where_clause identical
alter_index_statement different
argument different
argument1 different
assignment_statement different
call_statement different
case_function different
case_statement different
column_list different
connect_mode different
create_dbproc_statement different
create_function_statement different
create_role_statement different
create_schema_statement different
create_sequence_statement different
create_system_trigger_statement different
create_table_temp different
create_trigger_statement different
dbfunction_call different
dbfunction_name different
dbproc_name different
drop_dbproc_statement different
drop_function_statement different
drop_role_statement different
drop_schema_statement different
drop_sequence_statement different
drop_system_trigger_statement different
drop_table_temp different
drop_trigger_statement different
final_select different
formal_parameter different
formal_parameter1 different
if_statement different
initial_select different
insert_expression different
integer different
join_spec different
joined_table different
local_variable different
local_variable_list different
local_variables different
modify_column_definition different
modify_definition different
new_index_name different
new_schema_name different
new_user_name different
new_usergroup_name different
not_reserved_key_word different
old_index_name different
recursive_declare_cursor_statement different
recursive_select different
rename_index_statement different
rename_schema_statement different
rename_user_statement different
rename_usergroup_statement different
role_name different
rollback_to_statement different
routine different
routine_sql_statement different
sample_definition different
savepoint_statement different
scalar_subquery different
schema_authorization_identifier different
schema_element different
schema_name different
schema_name_clause different
schema_priv_spec different
searched_case_function different
searched_case_statement different
sequence_name different
set_statement different
simple_case_function different
simple_case_statement different
sql_comment different
sql_comment_text different
sql_savepoint_name different
statement different
statement_list different
trigger_event different
variable_name different
vertical_slash different
while_statement different