Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Colin Bull — — source: Usenet: comp.databases.informix
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.