DB2 RazorSQL Import Data Choose the location from where you want to import data. Let’s import “FRESHERS.XML” file. You can see that…
DB 2 Tutorial
-
-
Check Database Authority Use the following syntax to check the database authority which are granted to PUBLIC on the non-restrictive database: 1.…
-
DB2 RazorSQL Copy The Copy option is used to copy your table into a new table. For example: Let’s copy thable “FRESHERS”…
-
DB2 RazorSQL QueryBuilder Open RazorSQL and then connect to the database. Now right click on the selected table. You will see query…
-
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…