Hi, i'm using Squirrel SQL to manage a db2 database, i'm using jt400.jar from the IBM java Toolkit to connect to the AS400 V5R2, i can execute, more or less common SQL statements, however when i try to add comments to the columns of a table i can't get it works
COMMENT ON MyTable (
field1 IS 'My field 1',
field2 IS 'My field 2');
The problem is both statements run without error throug the JDBC -SQUIrrel and DB2, there is no errer , however when i check the column info on Squirrel i can't see the remarks for every colum. I have authority to alter talbe . any sugestion?