Re: Error 461 of Informix

tolga@login.com.tr wrote: > monitor@topaz.hknet.com (CheungYip San) wrote: > > Does anyone see the ISQL Error 461 and ISAM Error 0 or -100? > > > > I ran a 4GL program that include the SQL statement that > > retrieving a single row from the table, but that returns me > > such error. That's fine if I using the ISQL to retreive the > > same row. > > > > The environment I using as follows: > > HPUX 10.20 > > Informix Dynamic Server : 7.30 UC6 > > I4GL : 7.20 UD4 > > ISQL : 7.20 UD3 > > There can be a problem with your 4gl installation. > I had the similiar problem with esqlc. In a sun machine, i run a > esqlc program that is compiled in another machine. Program returns > 461(can not open file) but dbaccess returns no error for the same > sql. I checked the installed products and after installing esqlc > again problem solved. As one or two other people pointed out, this problem appears to be a blob problem - the error message certainly implies as much. However, as Tolga says, it is more typically an install order problem. Did you install either ISQL or I4GL after you installed IDS? If so, that is your problem - reinstall IDS. In my canon of known problems, this one ranks as one of the more confusing -- it typically has nothing whatsoever to do with blobs. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>