I tried to alter a null column of a table into a not null column in the local server using an alter statement. The table is empty. But the query I executed is not giving the actual result.
The query I tried
ALTER TABLE DEPT1 ALTER COLUMN DEPTNO SET NOT NULL WITH DEFAULT;
the result i got is
DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "NOT". SOME SYMBOLS THAT MIGHT
BE LEGAL ARE: CYCLE, NOCYCLE, ORDER, NOCACHE, NOORDER, NOMINVALUE,
I think your DB2 is out of service. Anyway, the manuals are still there. What did you try to resolve this? There's a big clue in the message about what is the SQL processor thinks is wrong with that line, but you need some research.