MySQL

DB2 UDB

Comments

LIKE ESCAPE in SELECT

CASE with LIKE and 

Implement using CASE 

ESCAPE

expression and VALUES 

statement

LOG(m,n)

LOG(m)/LOG(n)

To convert logarithm to an 

arbitrary base

NOT in SELECT

CASE

Implement using CASE 

expression and VALUES 

statement

NOT BETWEEN in 

CASE

Implement using CASE 

SELECT

expression and VALUES 

statement

NOT LIKE in SELECT

CASE

Implement using CASE 

expression and VALUES 

statement

PASSWORD

ENCRYPT

For encryption

POW

POWER 

Returns value of arg1 to 

the power of arg2

REGEXP in SELECT

no equivalent in DB2 UDB 

see article on developer 

8.1

works for work around 

http://www 106.ibm.com/

developerworks/db2/libr

ary/techarticle/0301sto

lze/0301stolze.html

ROUND(1 arg)

INT(ROUND(arg1,0))

Round to integer value

VERSION

db2level

To retrieve installed version 

of DBMS

7.2  Application source conversion

Every programming language provides a huge amount of commands and 

possibilities to program a special functionality. It is almost impossible to give a 

migration example for every possible programming approach. Therefore, in this 

section we discuss the most important commands used to access a database, 

which are:

  connecting database

  query statements

  disconnecting database

 Chapter 7. Application porting 

173