Field name
Data type
Length
Nullable
vse
char
1
yes
windows
char
1
yes
other
char
1
yes
username
varchar
20
no
The username field will be the search key in this table; hence, we will also
allocate it to be the primary key in the table.
USERORDERS
This contains the user orders. Each order, apart from having the username,
product_id ordered, and a timestamp for the order, will also have a unique
order_id. The fields for the USERORDERS table are shown in Table 4.
Table 4. The USERORDERS database table
Field name
Data type
Length
Nullable
username
varchar
20
no
order_timestamp
timestamp
no
product_id
varchar
20
no
order_id
int
no
The order_id field will be the search key in this table; hence, we will also
allocate it to be the primary key in the table.
We require all fields in this table be filled.
3.3.2 Creating the database
Creating the database consists of the following steps:
  Creating the DB2 database
  Creating the DB2 tables in the database
We assume DB2 has been installed, and the installation has been verified
successfully as discussed in Section 2.4.1,  DB2  on page 15.
3.3.2.1 Creating the DB2 database
We can create the DB2 database using either the DB2 Control Center GUI
interface or via the command line.
66
Linux Web Hosting with WebSphere, DB2, and Domino




  

Home

About Services Network Support FAQ Order Contact
 

Linux Web Hosting

Our partners:Jsp Web Hosting Unlimited Web Hosting Cheapest Web Hosting  Java Web Hosting Web Templates Best Web Templates PHP Mysql Web Hosting Interland Web Hosting Cheap Web Hosting PHP Web Hosting Tomcat Web Hosting Quality Web Hosting Best Web Hosting  Mac Web Hosting 

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