in DB2 V8.1, you may want to turn off logging with the following ALTER TABLE 

statement.

ALTER TABLE  ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE

7.1.10  Built in functions and operators

A function is an operation that is denoted by a function name followed by a pair of 

parentheses enclosing the specification of arguments if arguments are required. 

The following group of tables do not claim to be a complete reference of 

differences in built in functions and operators between MySQL Version 4.0 and 

DB2 UBD Version 8.1. The listed built in functions attempt to highlight those 

differences and map functionality between the two database management 

systems. Grouping the built in functions and operators into ANSI standard, 

ODBC standard and other groups seems somehow arbitrary; however, this is 

one way of dividing the sum of all built in functions into something smaller and 

easier to conquer.

Functions following the ANSI SQL standard

Table 7 3 lists functions specific to the ANSI SQL92 standard.

Table 7 3   SQL 92 functions

MySQL

DB2 equivalent

Description

select bit_length(`abc')

LENGTH(`abc')*8

Result depends on the 

encoding scheme used for 

character data: singly byte, 

double byte, UTF 8

select char_length(b) from 

LENGTH(expr)

Returns the number of 

t1; select 

bytes for expression. For 

character_length(`abcd')

double byte character set 

(DBCS)

the number of 

DBCS characters is 

returned

select extract(minute from 

VALUES 

Extracts part of date/time

timestamp `2000 02 23 

MINUTE(`2000 02 23 

18:43:12.987') 

18:43:12.987'), 

HOUR, YEAR, MONTH, 

DAY

168 

MySQL to DB2 UDB Conversion Guide