The SQL language provides for data definition, retrieval, update, and control operations from within an application. Table 22 shows the SQL statements supported by the DB2 product and whether the statement is supported dynamically, through the CLP, or through the CLI. You can use Table 22 as a quick reference aid. For a complete discussion of all the statements, including their syntax, see the SQL Reference.