Re: FGLSCHEMA ERROR INFORMIX 7.25UC5

Jonathan Leffler wrote: > Trane wrote: > > Hi all > > > > When I run fglschema I get the following error > > fglschema maindb > > ERROR: "maindb" The cursor or statement is not available. > > > > Installed fjs-fgl-1.31.2d-lnxlc22.sh for GENERO > > > > System Info: > > RedHat 8 > > Informix SE 7.25 UC5 > > > > uname -a > > Linux Genero 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386 > > GNU/Linux > > > > env | grep INF > > INFORMIXSERVER=demo_se > > INFORMIXDIR=/home/Informix> > > > cat sqlhosts > > demo_se sesoctcp Genero sqlexec > > > > tail -1 /etc/services > > sqlexec 1526/tcp # SE Informix > > > > esql -V > > IBM Informix CSDK Version 2.81, IBM Informix-ESQL Version 9.53.UC3 > > > > LD_LIBRARY_PATH=/home/informix/lib:/home/informix/lib/esql> > > > To make runner > > fglmkrun -o fglrun -d ix914 -l esql > > > > Runner successfully created. > > > > env | grep FGL > > FGLRUN=fglrun > > FGLDBPATH=/usr/local/sport/schema > > FGLLDPATH=/usr/local/sport/winds:/usr/local/sport/prog > > FGLDIR=/usr/fgl > > > > fglnodb -V > > fglrun 620.267 > > Built Mar 1 2005 18:39:33 > > (c) 1989-2005 Four J's Development Tools > > Database interface: <nodb> > > > > fglWrt -a see > > License : TAB#EFF0008U > > Product : Four J's Demonstration Program > > Type : Test version for 5 week(s) > > > > > > I can connect to my database located in /usr/local/sport with > > dbaccess maindb@demo_se > > DBPATH=/usr/local/sport:/usr/local/sport/forms> > > > But cannot run the fglschema as the error is "ERROR: "maindb" The > > cursor or statement is not available." > > > > anyhelp would be greatly apprciated as i am stuck.... > > Contact 4J's? > > If I had to guess, I'd suspect that something was using a construct only > available in IDS and not in SE, and not checking sufficiently carefully > for failure to prepare a statement or declare a cursor. But it is only > a guess; there is insufficient information in the quoted error message > to identify the culprit. > > > > -- > Jonathan Leffler #include <disclaimer.h> > Email: jleffler@earthlink.net, jleffler@us.ibm.com > Guardian of DBD::Informix v2005.01 -- http://dbi.perl.org/ Thanks for the reply jonathan. We have created a test esql program that was only five lines, which you will see below a little ec program: We contacted 4Js and they say it's an informix problem To test our esql, see below a little ec program: Then run the following commands: prompt> esql -o maindb maindb.ec prompt> ./maindb $ cat maindb.ec int main(void) { $DATABASE maindb; printf("Code retour: %d\\n",sqlca.sqlcode); return(0); } $ ./maindb Code retour: -1290 We have tried 3 different CSDK's (8.1,7&6) all to no avail. We are not sure if we have missed something with the enviroment setup. Is there any additonal information that I can you provide you that will assist? Regards Jim -- jim@transacct.com.au

Another thing is we get a different return error number on each CSDK's, as i mentioned earlier we can run dbaccess but not the fglschema. 4js supplied us the CSDK 2.70 Our CSDK 2.80 is located in /home/Informix/bin/esql Our CSDK 2.70 is located in $ type esql esql is /opt/informix/bin/esql $ esql -V INFORMIX-ESQL Version 9.50.UC1 When we try running the test maindb.ec program with CSDK 2.70 We get a different error all together $ esql -o maindb maindb.ec /opt/informix/lib/esql/libifos.so: the use of `mktemp' is dangerous, better use `mkstemp' $ ./maindb Code retour: -908 Any thoughts...... Thanks Regards Jim