MySQL

DB2 UDB

Comments

BIT_COUNT

no equivalent, implement 

Refer to BIT_CNT UDF in 

using UDF

Appendix A.6,  Sample 

code for BIT_COUNT  on 

page 359

ENCRYPT

ENCRYPT

DB2 requires encryption 

password

FIELD

CASE

Implement using CASE 

expression and VALUES 

statement

GREATEST

FnGratst

See UDF example in 

Appendix A.4,  Sample 

code for GREATEST 

function  on page 346

IF

CASE

Implement using CASE 

expression and VALUES 

statement

IN on numbers in SELECT

CASE

Implement using CASE 

expression and VALUES 

statement

IN on strings in SELECT

CASE

Implement using CASE 

expression and VALUES 

statement

LOCATE as INSTR

LOCATE

Arguments are swapped

INTERVAL

CASE

Implement using CASE 

expression and VALUES 

statement

LAST_INSERT_ID

IDENTITY_VAL_LOCAL

DB2 returns NULL, 

MySQL return zero if not 

set

LEAST

FnLeastN

See UDF example in 

Appendix A.5,  Sample 

code for LEAST  on 

page 353

LIKE in SELECT

CASE with LIKE

Implement using CASE 

expression and VALUES 

statement

172 

MySQL to DB2 UDB Conversion Guide