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 ...
Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
