Application developer also uses the type 'Registered' and 'Temporary' rather than using 'R' and 'T' in the application. Because of the mismatch in column value in the column and the application, application will not run.
As the occurrences of CUSTOMER_TYPE column in the application is high the DBA has to change data type of column FROM CHAR to VARCHAR and update the column value from 'R' to 'Registered' and 'T' to 'Temporary' to get the application working.
To solve the above problem DB2 9.7 offers SET DATA TYPE Option. Now the DBA can change the data type of a column in the table using SET DATA TYPE option in the ALTER TABLE command. DBA performs below steps to accommodate this requirement.
After running the SQL scripts on the right pane,
Result tab 4 shows a datatype of column nameTYPE
change from CHAR to VARCHAR in the
base table CUSTOMER.