db2 tutorial

DB2 RazorSQL GUI DB2 is little bit complicated to use at command line. You can use it GUI by downloading RazorSQL. What…

DB2 Datatypes In DB2 Database tables, each column has its own data type depending on developer’s requirements. The data type is said…

Connect to the Database Once the database is created, you have to connect or start database to make it in use. Syntax:…

DB2 RazorSQL CREATE The CREATE option facilitates you to create many things in DB2 database i.e. create table, create view, create index,…

DB2 RazorSQL Search The Search option facilitates you to search for any column in the table. For example: You can search for…

Create a Bufferpool If you want to create a new bufferpool for database server, you just need two parameters named “bufferpool name”…

DB2 RazorSQL View A view is used to define an alternative way of representing the data stored in a table. A view…

DB2 RazorSQL Show Info Show info is used to retrieve all information of the table. i.e. table owner, table name, create time,…

DB2 Create Database CREATE DATABASE command is used to create a database in an instance. All databases are created with the default…

DB2 RazorSQL Database Conversion Database Conversion is used to change the database in other format. For example: You can change DB2 database…