Übersetzung von Oracle SQL-Statement in IBM DB2
Hallo Zusammen,
ich würde gerne den nachfolgenden SQL-Statement, welches in Oracle Dialekt ist, in die IBM DB2 Dialekt übersetzen. Leider habe ich keinen Plan.
Wenn mir hier jemand helfen kann, dann wäre ich sehr dankbar.
Hier das SQL-Statement:
select
chap.q_chapter_id as CHAP_Q_CHAPTER_ID,
chap.numeration as CHAP_NUMERATION,
chap.description as CHAP_DESCRIPTION,
chap.name as CHAP_NAME,
chap.weight as CHAP_WEIGHT,
chap.identifier as CHAP_IDENTIFIER,
chap.threshold as CHAP_THRESHOLD,
sect.q_section_id as SECT_Q_SECTION_ID,
sect.description as SECT_DESCRIPTION,
sect.numeration as SECT_NUMERATION,
sect.name as SECT_NAME,
sect.weight as SECT_WEIGHT,
sect.threshold as SECT_THRESHOLD,
sect.identifier as SECT_IDENTIFIER,
groups.q_question_group_id as GROUPS_Q_QUESTION_GROUP_ID,
groups.description as GROUPS_DESCRIPTION,
groups.numeration as GROUPS_NUMERATION,
groups.weight as GROUPS_WEIGHT,
groups.name as GROUPS_NAME,
groups.identifier as GROUPS_IDENTIFIER,
grpval.q_question_group_id as GRPVAL_Q_QUESTION_GROUP_ID,
grpval.q_questionnaire_statistics_id as GRPVAL_Q_QUESTSTAT_ID,
grpval.value as GRPVAL_VALUE,
grpval.to_be_clarified as GRPVAL_TO_BE_CLARIFIED,
grpval.os_value as GRPVAL_OS_VALUE
from
q_chapters chap, q_sections sect, q_question_groups groups, q_question_group_values grpval
where
chap.q_questionnaire_id = :questionnaireId
and sect.q_chapter_id(+) = chap.q_chapter_id
and groups.q_section_id(+) = sect.q_section_id
and grpval.q_question_group_id(+) = groups.q_question_group_id
and grpval.q_questionnaire_statistics_id(+) = :questStaticId
order by
CHAP_Q_CHAPTER_ID, SECT_Q_SECTION_ID, GROUPS_Q_QUESTION_GROUP_ID, GRPVAL_Q_QUESTION_GROUP_ID
;
Viele Grüße,
Kafftarbaz
ich würde gerne den nachfolgenden SQL-Statement, welches in Oracle Dialekt ist, in die IBM DB2 Dialekt übersetzen. Leider habe ich keinen Plan.
Wenn mir hier jemand helfen kann, dann wäre ich sehr dankbar.
Hier das SQL-Statement:
select
chap.q_chapter_id as CHAP_Q_CHAPTER_ID,
chap.numeration as CHAP_NUMERATION,
chap.description as CHAP_DESCRIPTION,
chap.name as CHAP_NAME,
chap.weight as CHAP_WEIGHT,
chap.identifier as CHAP_IDENTIFIER,
chap.threshold as CHAP_THRESHOLD,
sect.q_section_id as SECT_Q_SECTION_ID,
sect.description as SECT_DESCRIPTION,
sect.numeration as SECT_NUMERATION,
sect.name as SECT_NAME,
sect.weight as SECT_WEIGHT,
sect.threshold as SECT_THRESHOLD,
sect.identifier as SECT_IDENTIFIER,
groups.q_question_group_id as GROUPS_Q_QUESTION_GROUP_ID,
groups.description as GROUPS_DESCRIPTION,
groups.numeration as GROUPS_NUMERATION,
groups.weight as GROUPS_WEIGHT,
groups.name as GROUPS_NAME,
groups.identifier as GROUPS_IDENTIFIER,
grpval.q_question_group_id as GRPVAL_Q_QUESTION_GROUP_ID,
grpval.q_questionnaire_statistics_id as GRPVAL_Q_QUESTSTAT_ID,
grpval.value as GRPVAL_VALUE,
grpval.to_be_clarified as GRPVAL_TO_BE_CLARIFIED,
grpval.os_value as GRPVAL_OS_VALUE
from
q_chapters chap, q_sections sect, q_question_groups groups, q_question_group_values grpval
where
chap.q_questionnaire_id = :questionnaireId
and sect.q_chapter_id(+) = chap.q_chapter_id
and groups.q_section_id(+) = sect.q_section_id
and grpval.q_question_group_id(+) = groups.q_question_group_id
and grpval.q_questionnaire_statistics_id(+) = :questStaticId
order by
CHAP_Q_CHAPTER_ID, SECT_Q_SECTION_ID, GROUPS_Q_QUESTION_GROUP_ID, GRPVAL_Q_QUESTION_GROUP_ID
;
Viele Grüße,
Kafftarbaz
Please also mark the comments that contributed to the solution of the article
Content-Key: 79324
Url: https://administrator.de/contentid/79324
Printed on: April 23, 2024 at 06:04 o'clock
1 Comment