Understanding DB2®: Learning Visually with Examples
by Raul F. Chong, Clara Liu, Sylvia F. Qi, Dwaine R. Snow
2.8. Summary
This chapter provided an overview of the DB2 core concepts using a “big picture” approach. It introduced SQL statements and their classification in Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL).
DB2 commands are classified into two groups—system commands and CLP commands—and several examples were provided, like the command to start an instance, db2start.
You need an interface to issue SQL statements and commands to the DB2 engine. This interface was provided by using the DB2 tools available with the product. Two text-based interfaces were mentioned, the Command Line Processor (CLP) and the Command Window. The Control Center was noted as being the most important administration graphical ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access