Hi, In DB2 if we want to set default value as null for a column, do we need to specify it explicitly?. According to the following[1] blog we don't need to specify the NULL as default since it will implicitly take the default value as NULL if we didn't specify it.
For the following script do we need to specify the default value as null for the column *REMAINING_SETS?* CREATE TABLE IDN_RECOVERY_DATA ( USER_NAME VARCHAR(255) NOT NULL, USER_DOMAIN VARCHAR(127) NOT NULL, TENANT_ID INTEGER DEFAULT -1 NOT NULL, CODE VARCHAR(255) NOT NULL, SCENARIO VARCHAR(255) NOT NULL, STEP VARCHAR(127) NOT NULL, TIME_CREATED TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, * REMAINING_SETS VARCHAR(2500) WITH DEFAULT NULL,* PRIMARY KEY(USER_NAME, USER_DOMAIN, TENANT_ID, SCENARIO,STEP), UNIQUE(CODE)) [1] https://www.datavail.com/blog/using-nulls-db2/ -- Nilasini Thirunavukkarasu Software Engineer - WSO2 Email : [email protected] Mobile : +94775241823 Web : http://wso2.com/ <http://wso2.com/signature>
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
