DB 2 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 Index Create Index is used to create index for a table. An index is a set of pointers which…

DB2 RazorSQL Row Count Row Count is used to count the number of number of rows in the table. Let’s see the…

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

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…

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

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