DB2 RazorSQL GUI DB2 is little bit complicated to use at command line. You can use it GUI by downloading RazorSQL. What…
Tag:
what is db2
-
-
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…
Newer Posts