Related Topics For more information about using DEFAULT within the SELECT statement, see: “WHERE Clause” on page 101. “HAVING Clause” on page 146. “Rules and Restrictions for the QUALIFY Clause” on page 150. “Rules for Using the DEFAULT Function as a Search Condition for an Outer Join ON Clause” on page 243. “Inserting When Using a DEFAULT Function” on page 361. “Rules for Using the DEFAULT Function With MERGE Requests” on page 433. “Rules for Using the DEFAULT Function With Update” on page 483.