MySQL 4.1
DB2 UDB 8.1
TIMESTAMP
TIMESTAMP
TIME
TIME
YEAR
SMALLINT with check constraint
CHAR
CHAR
VARCHAR
VARCHAR
TINYBLOB
BLOB(255)
TINYTEXT
CLOB(255)
BLOB BLOB(65K)
TEXT VARCHAR2,
CLOB(65K)
MEDIUMBLOB BLOB(16M)
MEDIUMTEXT CLOB(16M)
LONGBLOB
BLOB(2G) NOT LOGGED
LONGTEXT RAW,
CLOB(2G) NOT LOGGED
ENUM VARCHAR2,
VARCHAR() with check constraints
SET VARCHAR2,
VARCHAR() with check constraints
5.2  Data Definition Language differences
In this section we address the Data Definition Language (DDL) syntax difference 
between MySQL and DB2 DDL statements, and provide the DB2 UDB 
conversion. These differences can be syntactical, semantic, or functional.
Both MySQL and DB2 UDB follows structured query language (SQL), 
standardized language used to access databases, and is defined by the 
ANSI/ISO. 
The data definition language is a subset of SQL, which serves to create or delete 
a database and its structure (tables, views, and indexes); to grant or revoke user 
privileges; and to define referential integrity rules.
 Chapter 5. Database porting 
95






footer




 

 

 

 

 Home | About Us | Network | Services | Support | FAQ | Control Panel | Order Online | Sitemap | Contact

san diego web hosting

 

Our partners: PHP: Hypertext Preprocessor Cheap Web Hosting JSP Web Hosting Ontario Web Hosting  Jsp Web Hosting

Cheapest Web Hosting Java Hosting Cheapest Hosting

Visionwebhosting.net Business web hosting division of Vision Web Hosting Inc.. All rights reserved