Alter Table in AS400
Posted on 2004-04-23
Hi.. I want to ask to You.
How syntac ALTER TABLE in DB2 (AS 400 Server / STRSQL)
My syntax is :
ALTER TABLE tristotr ADD COLUMN fieldtest DEC (18,2) NOT NULL WITH DEFAULT
that syntax is correct but IF I again INSERT FIELD IN TRISTOTR
ALTER TABLE tristotr ADD COLUMN fieldtest2 DEC (18,2) NOT NULL
I get error “SQL SYSTEM ERROR” , what's wrong ?