RE: 407: Error number zero received from the sqlexec process.
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);>
>
>