Today, we will mainly describe some of the problems that we often encounter when migrating Oracle to a DB2 database. The following is a description of some of the problems that we often encounter when migrating Oracle to a DB2 database, I hope you will have a better understanding of it after browsing.
Oracle, port Oracle, Port
This is the SQL statement used to create a package found in Oracle. All the data types that cannot be used have been replaced, but it cannot be used in db2. What is the correct method?
- CREATE OR REPLACE PACKAGE "CRM_PLOG"
- as
- procedure ETL_ FO(in i_crm_name varchar,
- in i_crm_type varchar,
- in i_crm_ fo varchar,
- in i_crm_start timestamp,
- in i_crm_end timestamp);
- end CRM_PLOG;
Error message:
Sql00000n finds the exception mark "CRM_PLOG" after "create package ". Expected tags may include: "JION"
The above content is an introduction to the problems that Oracle has encountered when porting to the DB2 database.
The above content describes the problems encountered when Oracle is transplanted to the DB2 database. We hope to provide you with some help in this regard.