Default value: NO If DEFER=YES, the connection to the DBMS occurs when the first Pass-Through statement is executed. If DEFER=NO, the connection to the DBMS occurs when the CONNECT statement occurs.

Using default values on database columns helps to insulate database design issues from application code. Find out how to change a column's default value at a later date using a single command.