Oninit cdi / Archive
Talk to an expert →

FGLSCHEMA ERROR INFORMIX 7.25UC5

Posted in 2005

Topics: Installation, Setup & Upgrades, Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration, Networking & sqlhosts Configuration, Licensing & Editions, Internationalization & Character Sets

Trane — — source: Usenet: comp.databases.informix

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.... Thanks in advance Regards Jim

↪ replying to Trane
Jonathan Leffler — — source: Usenet: comp.databases.informix

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/

Glossary