**************************************************************
This is just a person usually summed up, if there is a better welcome to tell me, together learn to grow together
**************************************************************
The DB2 database writes SQL scripts by adding ";" before the script.
eg
--------------------------------Script starts----------------------------------
;
--Delete the DB2 database table field
ALTER TABLE db2inst1.student drop column age;
--Modify the length of the DB2 database table field
ALTER TABLE db2inst1.student ALTER NAME SET data type varchar (100);
--DB2 Database Student Table new fields
ALTER TABLE db2inst1.student Add column class varchar (30);
--------------------------------End of script--------------------------------------------
Db2inst1 is the schema of the DB2 database, and you need to modify which schema to precede the table name with the schema
DB2 Data Common directives