Migration of Oracle SQL to DB2 SQL

The following articles describe how to quickly migrate Oracle SQL to DB2 SQL. The following describes how to port Oracle SQL to DB2 SQL, I hope you will have a better understanding of it after browsing.

SQL, Oracle, port SQL, Oracle, Port

Migration from Oracle SQL to DB2 SQL: 1. Solutions for "decode" DB2 in Oracle El: completed using the "case" conditional expression. "Case" two syntax modes: (1) case when condition THEN result 1 ELSE result 2 END

(2) CASE expression 1 WHEN expression 2 THEN result 1 ELSE result 2 END

The above WHEN can be repeated multiple times, just like the expression of SWITCH... CASE in C. For example:

 
 

  
  
SELECT ORDNO,CUSNO, CASE MONTH(SHIPDATE) WHEN ''01'' THEN ''Jan'' WHEN ''02'' THEN ''Feb'' 
WHEN ''03'' THEN ''Mar'' WHEN ''04'' THEN ''Apr'' WHEN ''05'' THEN ''May'' WHEN ''06'' THEN ''
Jun'' WHEN ''07'' THEN ''Jul'' WHEN ''08'' THEN ''Aug'' WHEN ''09'' THEN ''Sep'' WHEN ''10'' 
THEN ''Oct'' WHEN ''11'' THEN ''Nov'' WHEN ''12'' THEN ''Dec'' END FROM FILE 
 
 

Application instance:

 
 

  
  
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 how to quickly learn how to port Oracle SQL to DB2 SQL. I hope you will gain some benefits.

The above content is to teach you how to quickly master the migration from Oracle SQL to DB2 SQL, and hope to bring you some help in this aspect.