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.
It is probably getting upset about "text" as a column name. Change that
name and retry.
MW
> -----Original Message-----
> From: owner-informix-list@iiug.org
> [mailto:owner-informix-list@iiug.org]On Behalf Of R'gis
> Sent: Tuesday, 27 May 2003 7:31 p.m.
> To: informix-list@iiug.org
> Subject: Re: 407: Error number zero received from the sqlexec process.
>
> [cut]
> I wrote a script which runs an update statistics high for
> each table in the
> database separately. I found the only one table on which the
> process fails
> with error 407.
> Same problem after drop/create/load from.
> secheck found no error.
>
> Here is the schema of the table:
>
> drop table tttxt010;>
> create table tttxt010(
> ctxt integer,
> clan char(1),
> seqe integer,
> text char(240)
> );>
> load from "/usr/data/load/mk/ttttxt010700.S"> delimiter "$"
> insert into tttxt010;>
> create index tttxt010_ix01 on tttxt010 (ctxt);
> create index tttxt010_ix02 on tttxt010 (clan);
> create index tttxt010_ix03 on tttxt010 (seqe);>
>
>
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.