DB2 TUTORIAL

 - Suchen Oguri
In this tutorial I’m going to tell you how to create database, tables and inserting values into tables.
Follow these simple steps….
-          Open the DB2 Control Panel (Run as admin).
-          Right Click on the All Databases tab and select create --> standard



-          In the opened window, enter the Database name and click on the finish button.





-          It waits and creates database.

-          To create a table, expand the databases and right click on our database and select create.



-          In the opened window enter the table name.



-          Next it prompts to enter the columns information
-          On the right side , Click on the add, it opens a small window


-          Enter the column information and click on the Apply.




-          After creating all columns click on the cancel. And then finish.
-          To enter the values in the created table, find the table and double click on it.



-          It opens a window to enter the values by creating required number of rows.


-          Finally click on the commit. And then finish.



Thank you