In the DB2 database, while structuring tables, data types must be assigned to each and every field. The DB2 datatypes…