RE: dbschema failed in IDS7.31.UD7

miyaki wrote > I'm having a problem with dbschema where it returns ISAM > error 100 after changing the table structure (either add > column or delete column). Does anyone experience this problem > before? Is it a known problem in UD7? Any resolution? > I would say it is because item is a reservered word in recent version of IDS. It is posssible to use some, but repercussions can be unpredictable Colin Bull > OS = Solaris 2.7 x86 platform > IDS = 7.31.UD7 > > This is how I produce the error. > > 1) Create a table > > create table table1 > ( > item char(15), > fileid char(64), > userid char(10), > primary key (item) constraint "informix".pk_fileid > ) extent size 53 next size 16 lock mode row;> _______________________________________________________________________ This email has been scanned for all known viruses by the MessageLabs Email Security System. _______________________________________________________________________ sending to informix-list