Error -103 Informix SE
Hi All
Versions:
SCO Unix vers 5.0.5
Informix SE 5.08.UD1
SQL vers 4.17.UC1
RDS vers 4.17.UC1
I receive error -103 and -245 when running the following
select from SQL or 4gl.
select shmtdqty,shmtdcst,shmtdval,shcust,shwh,shprod
from opsasummm
where shwh = "11"
and shprod = "07982-12942"
and shcust = "125202"
If I replace the last line in the wherepart with
and shcust matches "*125202*"
everything runs fine.
The unique key on the C-ISAM file is shwh char(2) shprod char(20) and shcust
char(8)
The table contains:
5970 Rows
11 Columns
I ran bcheck on the file and all reported 100% fine.
Any idees.
Cheers
Franz
sending to informix-list
Franz Gr'tzmacher wrote:
>
> Hi All
>
> Versions:
> SCO Unix vers 5.0.5
> Informix SE 5.08.UD1
> SQL vers 4.17.UC1
> RDS vers 4.17.UC1
>
> I receive error -103 and -245 when running the following
> select from SQL or 4gl.
>
> select shmtdqty,shmtdcst,shmtdval,shcust,shwh,shprod
> from opsasummm
> where shwh = "11"
> and shprod = "07982-12942"
> and shcust = "125202">
> If I replace the last line in the wherepart with
> and shcust matches "*125202*"
> everything runs fine.
>
> The unique key on the C-ISAM file is shwh char(2) shprod char(20) and
> shcust char(8)
> The table contains:
> 5970 Rows
> 11 Columns
>
> I ran bcheck on the file and all reported 100% fine.
Drop and recreate the index? Unload the table and rebuild it from scratch?
--
"C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule"
- Coluche