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

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/

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

Trane wrote:
> 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......


Not really. I haven't located error -1290 here at home.

-908 is 'Attempt to connect to database server (%s) failed.'

I've forgotten whether you can somehow connect to the database without
using fglschema - but it certainly appears that there is something up
with your server, or maybe with the connectivity.

With luck, you got this solved long ago. I would look at the server
installation very carefully, then at the sqlhosts file.


--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2005.01 -- http://dbi.perl.org/