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