The correct solution to port Orac database to DB2

This article mainly describes the correct solution to port the Orac database to DB2. To better express it, we use the instance method to better describe it. The following is a detailed description of the main content of the article. We hope you will have a better understanding of it after browsing.

Oracle SQL:

 
 

  
  
select decode(t.organtypecode, ''D'', t.parent, ''S'', t.parent, t.id)  
  
  
from A_ORGAN t  
  
  
where t.parent = 35 
  
  
DB2 SQL：  
  
  
select case x.organtypecode  
  
  
when ''D'' then  
  
  
x.parent  
  
  
when ''S'' then  
  
  
x.parent  
  
  
else  
  
  
x.id  
  
  
end  
  
  
from a_Organ x  
  
  
where x.parent = 35;  
 
 

The above content is an introduction to the Application Instances of the Oracle-to-DB2 migration solution. I hope you will have some gains.

 

The above content describes the application instances for migrating solutions from Oracle to DB2, hoping to help you in this regard.