RE: Please Problem With ESQL/C

Read the machine notes for ESQL/C on AIX. This header file is discussed -- and if I recall correctly, there is a work-around. -----Original Message----- From: Jonathan Leffler [mailto:jleffler@earthlink.net] Sent: Sunday, June 04, 2000 9:55 AM To: informix-list@iiug.org Subject: Re: Please Problem With ESQL/C Daniel Esquerre Fernandez wrote: > I am trying to use ESQL for firt time > we have IDS 2000 in a RS/6000( AIX 4.3.2) > > dev/pts/4> esql -V > INFORMIX-ESQL Version 7.24.UC5 > Software Serial Number ACN#J266163 > > we never use before ESQL/C ( we develop lots apps in 4GL > we want use de Art S. Kagel's dbcopy util from the IIUG > when we try to compile we get : > > /dev/pts/4> esql dbcopy.ec -o dbcopy > dbcopy.ec:136: warning: `_H_LOCALEDEF' redefined > *Initialization*:1: warning: this is the location of the previous definition > /dev/pts/4> > > when we try to use it we get some like: > > Error fetching row! Code=-403, ISAM=0. > Input: 0 records. > Copied: 0 records to silex_ds@silac_tcp:tareas. > Logged: 0 records to error log. > > /dev/pts/4> finderr -403 > -403 The size of a received row disagrees with the expected > size. > > This internal error indicates a problem in the communication between > the database server and the library functions that call it. Check that > your program is at the same software level as the database server in > use. If the error recurs, please note all circumstances, and contact > the Informix Technical Support Department. > Avi Abrami suggested that you have an incompatible version of ESQL/C, and given that you're using ESQL/C 7.24 with IDS.2000, he's probably right. You should be using Client SDK 2.40, I think; certainly, some version of CSDK. It is available free of charge from the Intraware site (http://www.intraware.com/), as Avi said. Most 7.24 ESQL/C application should be able to talk to the IDS.2000 DBMS without major problems. However, dbcopy isn't an ordinary ESQL/C application; it copies the entire database and therefore has, in theory, to deal with all the data types used in those databases, and there is room to think that Art has not yet done that work for the IUS data types -- I know I've not yet done it for my SQLCMD program, mainly because it is rather hard to do it properly. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v1.00.PC1 -- see http://www.perl.com/CPAN #include <disclaimer.h> This e-mail is sent by a law firm and may contain information that is privileged or confidential. If you are not the intended recipient, please delete the e-mail and any attachments and notify us immediately.