utils2_ak Make

Art, Here are the results from the compile attempt: INFORMIXC=gcc esql -DHAVE_GNU_GETOPT=1 -o listdb7 listdb7.ec getopt.cesqlc: "listdb7.ec", line 241: Error -33200: Invalid statement on symbol 'CONNECT'. esqlc: "listdb7.ec", line 241: Error -33051: Syntax error on identifier or symbol ':'. esqlc: "listdb7.ec", line 257: Error -33200: Invalid statement on symbol 'CONNECT'. esqlc: "listdb7.ec", line 257: Error -33051: Syntax error on identifier or symbol ':'. esqlc: "listdb7.ec", line 363: Error -33051: Syntax error on identifier or symbol 'INTO'. esqlc: "listdb7.ec", line 576: Error -33051: Syntax error on identifier or symbol 'CONNECTION'. esqlc: "listdb7.ec", line 587: Error -33051: Syntax error on identifier or symbol 'CONNECTION'. esqlc: "listdb7.ec", line 764: Error -33051: Syntax error on identifier or symbol 'CONNECTION'. 8 error(s) found make: *** [listdb7] Error 1 Larry

Weird! Works for me on Ubuntu Hardy Heron: art@Galadriel-II:~/Desktop/Latest Art's Stuff$ INFORMIXC=gcc esql -DHAVE_GNU_GETOPT=1 -o listdb7 listdb7.ec getopt.c art@Galadriel-II:~/Desktop/Latest Art's Stuff$ ./listdb7 There are currently 5 databases available: # Database/Table Name === ======================= 1 art 2 sysadmin 3 sysmaster 4 sysuser 5 sysutils What version of ESQL/C are you using? Please run: esql -V and post the output. Also post the output from: head -20 listdb7.ec You should see an entry like: Revision 1.19 2006/01/27 17:30:45 kagel OK, this REALLY fixed the problem. Revision 1.17 2003/10/13 17:06:45 kagel FIxed compilation on Linux. near the bottom of the listing. There was an old problem compiling that file on Linux but was fixed a couple of versions ago. Art On Thu, Oct 16, 2008 at 2:46 PM, LARRY SORENSEN <lsorensen25@msn.com> wrote: > Art, > > Here are the results from the compile attempt: > > INFORMIXC=gcc esql -DHAVE_GNU_GETOPT=1 -o listdb7 listdb7.ec getopt.c> esqlc: "listdb7.ec", line 241: Error -33200: Invalid statement on symbol > 'CONNECT'. > esqlc: "listdb7.ec", line 241: Error -33051: Syntax error on identifier or > symbol ':'. > esqlc: "listdb7.ec", line 257: Error -33200: Invalid statement on symbol > 'CONNECT'. > esqlc: "listdb7.ec", line 257: Error -33051: Syntax error on identifier or > symbol ':'. > esqlc: "listdb7.ec", line 363: Error -33051: Syntax error on identifier or > symbol 'INTO'. > esqlc: "listdb7.ec", line 576: Error -33051: Syntax error on identifier or > symbol 'CONNECTION'. > esqlc: "listdb7.ec", line 587: Error -33051: Syntax error on identifier or > symbol 'CONNECTION'. > esqlc: "listdb7.ec", line 764: Error -33051: Syntax error on identifier or > symbol 'CONNECTION'. > 8 error(s) found > make: *** [listdb7] Error 1 > > Larry > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

I am using version 5.20.UC2 > To: ids@iiug.org> From: art.kagel@gmail.com> Subject: Re: utils2_ak Make [13720]> Date: Thu, 16 Oct 2008 15:42:48 -0400> > Weird! Works for me on Ubuntu Hardy Heron: > > art@Galadriel-II:~/Desktop/Latest Art's Stuff$ INFORMIXC=gcc esql > -DHAVE_GNU_GETOPT=1 -o listdb7 listdb7.ec getopt.c >art@Galadriel-II:~/Desktop/Latest Art's Stuff$ ./listdb7 > There are currently 5 databases available: > > # Database/Table Name > === ======================= > 1 art > 2 sysadmin > 3 sysmaster > 4 sysuser > 5 sysutils > > What version of ESQL/C are you using? Please run: > > esql -V > > and post the output. Also post the output from: > > head -20 listdb7.ec You should see an entry like: > > Revision 1.19 2006/01/27 17:30:45 kagel > > OK, this REALLY fixed the problem. > > Revision 1.17 2003/10/13 17:06:45 kagel > > FIxed compilation on Linux. > > near the bottom of the listing. There was an old problem compiling that > file on Linux but was fixed a couple of versions ago. > > Art > > On Thu, Oct 16, 2008 at 2:46 PM, LARRY SORENSEN <lsorensen25@msn.com> wrote: > > > Art, > > > > Here are the results from the compile attempt: > > > > INFORMIXC=gcc esql -DHAVE_GNU_GETOPT=1 -o listdb7 listdb7.ec getopt.c > >esqlc: "listdb7.ec", line 241: Error -33200: Invalid statement on symbol > > 'CONNECT'. > > esqlc: "listdb7.ec", line 241: Error -33051: Syntax error on identifier or > > symbol ':'. > > esqlc: "listdb7.ec", line 257: Error -33200: Invalid statement on symbol > > 'CONNECT'. > > esqlc: "listdb7.ec", line 257: Error -33051: Syntax error on identifier or > > symbol ':'. > > esqlc: "listdb7.ec", line 363: Error -33051: Syntax error on identifier or > > symbol 'INTO'. > > esqlc: "listdb7.ec", line 576: Error -33051: Syntax error on identifier or > > symbol 'CONNECTION'. > > esqlc: "listdb7.ec", line 587: Error -33051: Syntax error on identifier or > > symbol 'CONNECTION'. > > esqlc: "listdb7.ec", line 764: Error -33051: Syntax error on identifier or > > symbol 'CONNECTION'. > > 8 error(s) found > > make: *** [listdb7] Error 1 > > > > Larry > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > Art S. Kagel > Oninit (www.oninit.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my own opinions and > do not reflect on my employer, Oninit, the IIUG, nor any other organization > with which I am associated either explicitly or implicitly. Neither do > those opinions reflect those of other individuals affiliated with any entity > with which I am affiliated nor those of the entities themselves. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

To show you what changes that I have made to the original Makefile I did a diff with the following output: < #CFLAGS=-O < CFLAGS=-O3 # For GNU C (gcc) to maximize code optimization --- > CFLAGS=-O > # CFLAGS=-O3 # For GNU C (gcc) to maximize code optimization 42,43c42,43 < #GEN=-L/usr/lib -lgen # Library containing the function basename(). < GEN=-lc # On AIX and some other BSD UNIXes the libgen funcs are in libc --- > GEN=-L/usr/lib -lgen # Library containing the function basename(). > # GEN=-lc # On AIX and some other BSD UNIXes the libgen funcs are in libc ---------------------------------------- > To: ids@iiug.org > From: art.kagel@gmail.com > Subject: Re: utils2_ak Make [13720] > Date: Thu, 16 Oct 2008 15:42:48 -0400 > > Weird! Works for me on Ubuntu Hardy Heron: > > art@Galadriel-II:~/Desktop/Latest Art's Stuff$ INFORMIXC=gcc esql > -DHAVE_GNU_GETOPT=1 -o listdb7 listdb7.ec getopt.c > art@Galadriel-II:~/Desktop/Latest Art's Stuff$ ./listdb7 > There are currently 5 databases available: > > # Database/Table Name > === ======================= > 1 art > 2 sysadmin > 3 sysmaster > 4 sysuser > 5 sysutils > > What version of ESQL/C are you using? Please run: > > esql -V > > and post the output. Also post the output from: > > head -20 listdb7.ec You should see an entry like: > > Revision 1.19 2006/01/27 17:30:45 kagel > > OK, this REALLY fixed the problem. > > Revision 1.17 2003/10/13 17:06:45 kagel > > FIxed compilation on Linux. > > near the bottom of the listing. There was an old problem compiling that > file on Linux but was fixed a couple of versions ago. > > Art > > On Thu, Oct 16, 2008 at 2:46 PM, LARRY SORENSEN wrote: > >> Art, >> >> Here are the results from the compile attempt: >> >> INFORMIXC=gcc esql -DHAVE_GNU_GETOPT=1 -o listdb7 listdb7.ec getopt.c>> esqlc: "listdb7.ec", line 241: Error -33200: Invalid statement on symbol >> 'CONNECT'. >> esqlc: "listdb7.ec", line 241: Error -33051: Syntax error on identifier or >> symbol ':'. >> esqlc: "listdb7.ec", line 257: Error -33200: Invalid statement on symbol >> 'CONNECT'. >> esqlc: "listdb7.ec", line 257: Error -33051: Syntax error on identifier or >> symbol ':'. >> esqlc: "listdb7.ec", line 363: Error -33051: Syntax error on identifier or >> symbol 'INTO'. >> esqlc: "listdb7.ec", line 576: Error -33051: Syntax error on identifier or >> symbol 'CONNECTION'. >> esqlc: "listdb7.ec", line 587: Error -33051: Syntax error on identifier or >> symbol 'CONNECTION'. >> esqlc: "listdb7.ec", line 764: Error -33051: Syntax error on identifier or >> symbol 'CONNECTION'. >> 8 error(s) found >> make: *** [listdb7] Error 1 >> >> Larry >> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > -- > Art S. Kagel > Oninit (www.oninit.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my own opinions and > do not reflect on my employer, Oninit, the IIUG, nor any other organization > with which I am associated either explicitly or implicitly. Neither do > those opinions reflect those of other individuals affiliated with any entity > with which I am affiliated nor those of the entities themselves. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

AHHHHH!!! ESQL/C v 5.xx did not support the CONNECT verb, that's why you are having trouble. I don't remember there ever being an esql/c v 5.20! The last 5.xx specific esql/c that I remember was v 5.12 or 13 before it was replaced by ESQL/C v6.01 and a year later with v7.10. Of course I'm getting older .... What version of the database engine are you running? If you are running OnLine 5.xx then you don't need listdb7.ec anyway, it depends on features not in OL5.xx, but the listdb.ec will work fine with that server. Just comment out the lines in the makefile that depend on listdb7.ec. If you are running IDS 7.xx, 9.xx, 10.00, or 11.xx you shouldn't be using such an old ESQL/C compiler anyway. You will not be able to compile most of the rest of the package either with that old version of ESQL/C. You will have to download the CSDK v 3.50 (the latest) from the IBM web site and install it in a separate directory from the database engine. Put a copy of the sqlhosts file into the etc subdirectory under where you've installed the CSDK and you'll be able to run my tools (once they are compiled) from that directory tree. Art On Thu, Oct 16, 2008 at 3:47 PM, LARRY SORENSEN <lsorensen25@msn.com> wrote: > I am using version 5.20.UC2 > > To: ids@iiug.org> From: art.kagel@gmail.com> Subject: Re: utils2_ak Make > [13720]> Date: Thu, 16 Oct 2008 15:42:48 -0400> > Weird! Works for me on > Ubuntu Hardy Heron: > > art@Galadriel-II:~/Desktop/Latest Art's Stuff$ > INFORMIXC=gcc esql > -DHAVE_GNU_GETOPT=1 -o listdb7 listdb7.ec getopt.c >> art@Galadriel-II:~/Desktop/Latest Art's Stuff$ ./listdb7 > There are > currently > 5 databases available: > > # Database/Table Name > === > ======================= > > 1 art > 2 sysadmin > 3 sysmaster > 4 sysuser > 5 sysutils > > What > version > of ESQL/C are you using? Please run: > > esql -V > > and post the output. > Also > post the output from: > > head -20 listdb7.ec You should see an entry > like: > > > Revision 1.19 2006/01/27 17:30:45 kagel > > OK, this REALLY fixed the > problem. > > Revision 1.17 2003/10/13 17:06:45 kagel > > FIxed compilation > on > Linux. > > near the bottom of the listing. There was an old problem > compiling > that > file on Linux but was fixed a couple of versions ago. > > Art > > On > Thu, Oct 16, 2008 at 2:46 PM, LARRY SORENSEN <lsorensen25@msn.com> wrote: > > > > > Art, > > > > Here are the results from the compile attempt: > > > > > INFORMIXC=gcc esql -DHAVE_GNU_GETOPT=1 -o listdb7 listdb7.ec getopt.c > >> esqlc: "listdb7.ec", line 241: Error -33200: Invalid statement on symbol > > > > 'CONNECT'. > > esqlc: "listdb7.ec", line 241: Error -33051: Syntax error > on > identifier or > > symbol ':'. > > esqlc: "listdb7.ec", line 257: Error > -33200: > Invalid statement on symbol > > 'CONNECT'. > > esqlc: "listdb7.ec", line > 257: > Error -33051: Syntax error on identifier or > > symbol ':'. > > esqlc: > "listdb7.ec", line 363: Error -33051: Syntax error on identifier or > > > symbol > 'INTO'. > > esqlc: "listdb7.ec", line 576: Error -33051: Syntax error on > identifier or > > symbol 'CONNECTION'. > > esqlc: "listdb7.ec", line 587: > Error -33051: Syntax error on identifier or > > symbol 'CONNECTION'. > > > esqlc: "listdb7.ec", line 764: Error -33051: Syntax error on identifier or > > > > symbol 'CONNECTION'. > > 8 error(s) found > > make: *** [listdb7] Error 1 > > > > > > Larry > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > -- > Art S. Kagel > Oninit (www.oninit.com) > IIUG Board of > Directors > (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions > are my > own opinions and > do not reflect on my employer, Oninit, the IIUG, nor any > other organization > with which I am associated either explicitly or > implicitly. Neither do > those opinions reflect those of other individuals > affiliated with any entity > with which I am affiliated nor those of the > entities themselves. > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

Art, Thanks for your response. I am not sure how I got a hold of such an old ESQL/C. As far as installing into a directory separate from the engine, is that just a recommendation or does it have to be installed in a separate directory? Are you just saying this so that the engine libraries will not be clobbered with the install? ---------------------------------------- > To: ids@iiug.org > From: art.kagel@gmail.com > Subject: Re: utils2_ak Make [13723] > Date: Thu, 16 Oct 2008 16:09:26 -0400 > > AHHHHH!!! ESQL/C v 5.xx did not support the CONNECT verb, that's why you > are having trouble. I don't remember there ever being an esql/c v 5.20! > The last 5.xx specific esql/c that I remember was v 5.12 or 13 before it was > replaced by ESQL/C v6.01 and a year later with v7.10. Of course I'm getting > older .... > > What version of the database engine are you running? If you are running > OnLine 5.xx then you don't need listdb7.ec anyway, it depends on features > not in OL5.xx, but the listdb.ec will work fine with that server. Just > comment out the lines in the makefile that depend on listdb7.ec. > > If you are running IDS 7.xx, 9.xx, 10.00, or 11.xx you shouldn't be using > such an old ESQL/C compiler anyway. > > You will not be able to compile most of the rest of the package either with > that old version of ESQL/C. You will have to download the CSDK v 3.50 (the > latest) from the IBM web site and install it in a separate directory from > the database engine. Put a copy of the sqlhosts file into the etc > subdirectory under where you've installed the CSDK and you'll be able to run > my tools (once they are compiled) from that directory tree. > > Art > > On Thu, Oct 16, 2008 at 3:47 PM, LARRY SORENSEN wrote: > >> I am using version 5.20.UC2 >>> To: ids@iiug.org> From: art.kagel@gmail.com> Subject: Re: utils2_ak Make >> [13720]> Date: Thu, 16 Oct 2008 15:42:48 -0400>> Weird! Works for me on >> Ubuntu Hardy Heron:>> art@Galadriel-II:~/Desktop/Latest Art's Stuff$ >> INFORMIXC=gcc esql> -DHAVE_GNU_GETOPT=1 -o listdb7 listdb7.ec getopt.c>>> art@Galadriel-II:~/Desktop/Latest Art's Stuff$ ./listdb7> There are >> currently >> 5 databases available:>> # Database/Table Name> === >> ======================= >>> 1 art> 2 sysadmin> 3 sysmaster> 4 sysuser> 5 sysutils>> What >> version >> of ESQL/C are you using? Please run:>> esql -V>> and post the output. >> Also >> post the output from:>> head -20 listdb7.ec You should see an entry >> like:> >>> Revision 1.19 2006/01/27 17:30:45 kagel>> OK, this REALLY fixed the >> problem.>> Revision 1.17 2003/10/13 17:06:45 kagel>> FIxed compilation >> on >> Linux.>> near the bottom of the listing. There was an old problem >> compiling >> that> file on Linux but was fixed a couple of versions ago.>> Art>> On >> Thu, Oct 16, 2008 at 2:46 PM, LARRY SORENSEN wrote: >>>> >>> Art,>>>> Here are the results from the compile attempt:>>>> >> INFORMIXC=gcc esql -DHAVE_GNU_GETOPT=1 -o listdb7 listdb7.ec getopt.c>>>> esqlc: "listdb7.ec", line 241: Error -33200: Invalid statement on symbol> >>> >> 'CONNECT'.>> esqlc: "listdb7.ec", line 241: Error -33051: Syntax error >> on >> identifier or>> symbol ':'.>> esqlc: "listdb7.ec", line 257: Error >> -33200: >> Invalid statement on symbol>> 'CONNECT'.>> esqlc: "listdb7.ec", line >> 257: >> Error -33051: Syntax error on identifier or>> symbol ':'.>> esqlc: >> "listdb7.ec", line 363: Error -33051: Syntax error on identifier or>> >> symbol >> 'INTO'.>> esqlc: "listdb7.ec", line 576: Error -33051: Syntax error on >> identifier or>> symbol 'CONNECTION'.>> esqlc: "listdb7.ec", line 587: >> Error -33051: Syntax error on identifier or>> symbol 'CONNECTION'.>> >> esqlc: "listdb7.ec", line 764: Error -33051: Syntax error on identifier or >>>> >> symbol 'CONNECTION'.>> 8 error(s) found>> make: *** [listdb7] Error 1> >>> >>>> Larry>>>>>>>>> >> >> > ******************************************************************************* >>>> Forum Note: Use "Reply" to post a response in the discussion forum.>> >>> >>>>> --> Art S. Kagel> Oninit (www.oninit.com)> IIUG Board of >> Directors >> (art@iiug.org)>> Disclaimer: Please keep in mind that my own opinions >> are my >> own opinions and> do not reflect on my employer, Oninit, the IIUG, nor any >> other organization> with which I am associated either explicitly or >> implicitly. Neither do> those opinions reflect those of other individuals >> affiliated with any entity> with which I am affiliated nor those of the >> entities themselves.>>> >> >> > ******************************************************************************* >>> Forum Note: Use "Reply" to post a response in the discussion forum.> >> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > -- > Art S. Kagel > Oninit (www.oninit.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my own opinions and > do not reflect on my employer, Oninit, the IIUG, nor any other organization > with which I am associated either explicitly or implicitly. Neither do > those opinions reflect those of other individuals affiliated with any entity > with which I am affiliated nor those of the entities themselves. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Art, I have downloaded CSDK 3.50.UC1 and UC1 for linux. When I run the installclientsdk for either, I get the following message: The wizard cannot continue because of the following error: could not load wizard specified in /wizard.inf (104) Any suggestions? ---------------------------------------- > To: ids@iiug.org > From: art.kagel@gmail.com > Subject: Re: utils2_ak Make [13723] > Date: Thu, 16 Oct 2008 16:09:26 -0400 > > AHHHHH!!! ESQL/C v 5.xx did not support the CONNECT verb, that's why you > are having trouble. I don't remember there ever being an esql/c v 5.20! > The last 5.xx specific esql/c that I remember was v 5.12 or 13 before it was > replaced by ESQL/C v6.01 and a year later with v7.10. Of course I'm getting > older .... > > What version of the database engine are you running? If you are running > OnLine 5.xx then you don't need listdb7.ec anyway, it depends on features > not in OL5.xx, but the listdb.ec will work fine with that server. Just > comment out the lines in the makefile that depend on listdb7.ec. > > If you are running IDS 7.xx, 9.xx, 10.00, or 11.xx you shouldn't be using > such an old ESQL/C compiler anyway. > > You will not be able to compile most of the rest of the package either with > that old version of ESQL/C. You will have to download the CSDK v 3.50 (the > latest) from the IBM web site and install it in a separate directory from > the database engine. Put a copy of the sqlhosts file into the etc > subdirectory under where you've installed the CSDK and you'll be able to run > my tools (once they are compiled) from that directory tree. > > Art > > On Thu, Oct 16, 2008 at 3:47 PM, LARRY SORENSEN wrote: > >> I am using version 5.20.UC2 >>> To: ids@iiug.org> From: art.kagel@gmail.com> Subject: Re: utils2_ak Make >> [13720]> Date: Thu, 16 Oct 2008 15:42:48 -0400>> Weird! Works for me on >> Ubuntu Hardy Heron:>> art@Galadriel-II:~/Desktop/Latest Art's Stuff$ >> INFORMIXC=gcc esql> -DHAVE_GNU_GETOPT=1 -o listdb7 listdb7.ec getopt.c>>> art@Galadriel-II:~/Desktop/Latest Art's Stuff$ ./listdb7> There are >> currently >> 5 databases available:>> # Database/Table Name> === >> ======================= >>> 1 art> 2 sysadmin> 3 sysmaster> 4 sysuser> 5 sysutils>> What >> version >> of ESQL/C are you using? Please run:>> esql -V>> and post the output. >> Also >> post the output from:>> head -20 listdb7.ec You should see an entry >> like:> >>> Revision 1.19 2006/01/27 17:30:45 kagel>> OK, this REALLY fixed the >> problem.>> Revision 1.17 2003/10/13 17:06:45 kagel>> FIxed compilation >> on >> Linux.>> near the bottom of the listing. There was an old problem >> compiling >> that> file on Linux but was fixed a couple of versions ago.>> Art>> On >> Thu, Oct 16, 2008 at 2:46 PM, LARRY SORENSEN wrote: >>>> >>> Art,>>>> Here are the results from the compile attempt:>>>> >> INFORMIXC=gcc esql -DHAVE_GNU_GETOPT=1 -o listdb7 listdb7.ec getopt.c>>>> esqlc: "listdb7.ec", line 241: Error -33200: Invalid statement on symbol> >>> >> 'CONNECT'.>> esqlc: "listdb7.ec", line 241: Error -33051: Syntax error >> on >> identifier or>> symbol ':'.>> esqlc: "listdb7.ec", line 257: Error >> -33200: >> Invalid statement on symbol>> 'CONNECT'.>> esqlc: "listdb7.ec", line >> 257: >> Error -33051: Syntax error on identifier or>> symbol ':'.>> esqlc: >> "listdb7.ec", line 363: Error -33051: Syntax error on identifier or>> >> symbol >> 'INTO'.>> esqlc: "listdb7.ec", line 576: Error -33051: Syntax error on >> identifier or>> symbol 'CONNECTION'.>> esqlc: "listdb7.ec", line 587: >> Error -33051: Syntax error on identifier or>> symbol 'CONNECTION'.>> >> esqlc: "listdb7.ec", line 764: Error -33051: Syntax error on identifier or >>>> >> symbol 'CONNECTION'.>> 8 error(s) found>> make: *** [listdb7] Error 1> >>> >>>> Larry>>>>>>>>> >> >> > ******************************************************************************* >>>> Forum Note: Use "Reply" to post a response in the discussion forum.>> >>> >>>>> --> Art S. Kagel> Oninit (www.oninit.com)> IIUG Board of >> Directors >> (art@iiug.org)>> Disclaimer: Please keep in mind that my own opinions >> are my >> own opinions and> do not reflect on my employer, Oninit, the IIUG, nor any >> other organization> with which I am associated either explicitly or >> implicitly. Neither do> those opinions reflect those of other individuals >> affiliated with any entity> with which I am affiliated nor those of the >> entities themselves.>>> >> >> > ******************************************************************************* >>> Forum Note: Use "Reply" to post a response in the discussion forum.> >> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > -- > Art S. Kagel > Oninit (www.oninit.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my own opinions and > do not reflect on my employer, Oninit, the IIUG, nor any other organization > with which I am associated either explicitly or implicitly. Neither do > those opinions reflect those of other individuals affiliated with any entity > with which I am affiliated nor those of the entities themselves. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

As long as you install an SDK at least as recent as the engine itself the libraries are safe, so you CAN install over the existing instance and ESQL. Just a suggestion in case you didn't want to have to recompile any existing ESQL source since the new shared libraries are definitely not compatible with the older ESQL 5.xx executables. If you are not using ESQL/C for anything but utilities and there aren't so many as to make rebuilding them all a burden, feel free and safe installing into the existing INFORMIXDIR. Prudence suggests doing so during off hours but otherwise it should be painless and harmless. Art On Thu, Oct 16, 2008 at 4:45 PM, LARRY SORENSEN <lsorensen25@msn.com> wrote: > Art, > > Thanks for your response. I am not sure how I got a hold of such an old > ESQL/C. As far as installing into a directory separate from the engine, is > that just a recommendation or does it have to be installed in a separate > directory? Are you just saying this so that the engine libraries will not > be > clobbered with the install? > > ---------------------------------------- > > To: ids@iiug.org > > From: art.kagel@gmail.com > > Subject: Re: utils2_ak Make [13723] > > Date: Thu, 16 Oct 2008 16:09:26 -0400 > > > > AHHHHH!!! ESQL/C v 5.xx did not support the CONNECT verb, that's why you > > are having trouble. I don't remember there ever being an esql/c v 5.20! > > The last 5.xx specific esql/c that I remember was v 5.12 or 13 before it > was > > replaced by ESQL/C v6.01 and a year later with v7.10. Of course I'm > getting > > older .... > > > > What version of the database engine are you running? If you are running > > OnLine 5.xx then you don't need listdb7.ec anyway, it depends on > features > > not in OL5.xx, but the listdb.ec will work fine with that server. Just > > comment out the lines in the makefile that depend on listdb7.ec. > > > > If you are running IDS 7.xx, 9.xx, 10.00, or 11.xx you shouldn't be using > > such an old ESQL/C compiler anyway. > > > > You will not be able to compile most of the rest of the package either > with > > that old version of ESQL/C. You will have to download the CSDK v 3.50 > (the > > latest) from the IBM web site and install it in a separate directory from > > the database engine. Put a copy of the sqlhosts file into the etc > > subdirectory under where you've installed the CSDK and you'll be able to > run > > my tools (once they are compiled) from that directory tree. > > > > Art > > > > On Thu, Oct 16, 2008 at 3:47 PM, LARRY SORENSEN wrote: > > > >> I am using version 5.20.UC2 > >>> To: ids@iiug.org> From: art.kagel@gmail.com> Subject: Re: utils2_ak > Make > >> [13720]> Date: Thu, 16 Oct 2008 15:42:48 -0400>> Weird! Works for me on > >> Ubuntu Hardy Heron:>> art@Galadriel-II:~/Desktop/Latest Art's Stuff$ > >> INFORMIXC=gcc esql> -DHAVE_GNU_GETOPT=1 -o listdb7 listdb7.ec getopt.c>> >> art@Galadriel-II:~/Desktop/Latest Art's Stuff$ ./listdb7> There are > >> currently > >> 5 databases available:>> # Database/Table Name> === > >> ======================= > >>> 1 art> 2 sysadmin> 3 sysmaster> 4 sysuser> 5 sysutils>> What > >> version > >> of ESQL/C are you using? Please run:>> esql -V>> and post the output. > >> Also > >> post the output from:>> head -20 listdb7.ec You should see an entry > >> like:> > >>> Revision 1.19 2006/01/27 17:30:45 kagel>> OK, this REALLY fixed the > >> problem.>> Revision 1.17 2003/10/13 17:06:45 kagel>> FIxed compilation > >> on > >> Linux.>> near the bottom of the listing. There was an old problem > >> compiling > >> that> file on Linux but was fixed a couple of versions ago.>> Art>> On > >> Thu, Oct 16, 2008 at 2:46 PM, LARRY SORENSEN wrote: > >>>> > >>> Art,>>>> Here are the results from the compile attempt:>>>> > >> INFORMIXC=gcc esql -DHAVE_GNU_GETOPT=1 -o listdb7 listdb7.ec getopt.c>>> >> esqlc: "listdb7.ec", line 241: Error -33200: Invalid statement on > symbol> > >>> > >> 'CONNECT'.>> esqlc: "listdb7.ec", line 241: Error -33051: Syntax error > >> on > >> identifier or>> symbol ':'.>> esqlc: "listdb7.ec", line 257: Error > >> -33200: > >> Invalid statement on symbol>> 'CONNECT'.>> esqlc: "listdb7.ec", line > >> 257: > >> Error -33051: Syntax error on identifier or>> symbol ':'.>> esqlc: > >> "listdb7.ec", line 363: Error -33051: Syntax error on identifier or>> > >> symbol > >> 'INTO'.>> esqlc: "listdb7.ec", line 576: Error -33051: Syntax error on > >> identifier or>> symbol 'CONNECTION'.>> esqlc: "listdb7.ec", line 587: > >> Error -33051: Syntax error on identifier or>> symbol 'CONNECTION'.>> > >> esqlc: "listdb7.ec", line 764: Error -33051: Syntax error on identifier > or > >>>> > >> symbol 'CONNECTION'.>> 8 error(s) found>> make: *** [listdb7] Error 1> > >>> > >>>> Larry>>>>>>>>> > >> > >> > > > > ******************************************************************************* > >>>> Forum Note: Use "Reply" to post a response in the discussion forum.>> > >>> > >>>>> --> Art S. Kagel> Oninit (www.oninit.com)> IIUG Board of > >> Directors > >> (art@iiug.org)>> Disclaimer: Please keep in mind that my own opinions > >> are my > >> own opinions and> do not reflect on my employer, Oninit, the IIUG, nor > any > >> other organization> with which I am associated either explicitly or > >> implicitly. Neither do> those opinions reflect those of other > individuals > >> affiliated with any entity> with which I am affiliated nor those of the > >> entities themselves.>>> > >> > >> > > > > ******************************************************************************* > >>> Forum Note: Use "Reply" to post a response in the discussion forum.> > >> > >> > >> > >> > > > > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. > >> > >> > > > > -- > > Art S. Kagel > > Oninit (www.oninit.com) > > IIUG Board of Directors (art@iiug.org) > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > > do not reflect on my employer, Oninit, the IIUG, nor any other > organization > > with which I am associated either explicitly or implicitly. Neither do > > those opinions reflect those of other individuals affiliated with any > entity > > with which I am affiliated nor those of the entities themselves. > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with whi

Call IBM. There have been some issues with the new installer for Linux and you do get installation support for free: 1-800-426-7378 Art On Thu, Oct 16, 2008 at 6:03 PM, LARRY SORENSEN <lsorensen25@msn.com> wrote: > Art, > > I have downloaded CSDK 3.50.UC1 and UC1 for linux. When I run the > installclientsdk for either, I get the following message: > > The wizard cannot continue because of the following error: could not load > wizard specified in /wizard.inf (104) > > Any suggestions? > > ---------------------------------------- > > To: ids@iiug.org > > From: art.kagel@gmail.com > > Subject: Re: utils2_ak Make [13723] > > Date: Thu, 16 Oct 2008 16:09:26 -0400 > > > > AHHHHH!!! ESQL/C v 5.xx did not support the CONNECT verb, that's why you > > are having trouble. I don't remember there ever being an esql/c v 5.20! > > The last 5.xx specific esql/c that I remember was v 5.12 or 13 before it > was > > replaced by ESQL/C v6.01 and a year later with v7.10. Of course I'm > getting > > older .... > > > > What version of the database engine are you running? If you are running > > OnLine 5.xx then you don't need listdb7.ec anyway, it depends on > features > > not in OL5.xx, but the listdb.ec will work fine with that server. Just > > comment out the lines in the makefile that depend on listdb7.ec. > > > > If you are running IDS 7.xx, 9.xx, 10.00, or 11.xx you shouldn't be using > > such an old ESQL/C compiler anyway. > > > > You will not be able to compile most of the rest of the package either > with > > that old version of ESQL/C. You will have to download the CSDK v 3.50 > (the > > latest) from the IBM web site and install it in a separate directory from > > the database engine. Put a copy of the sqlhosts file into the etc > > subdirectory under where you've installed the CSDK and you'll be able to > run > > my tools (once they are compiled) from that directory tree. > > > > Art > > > > On Thu, Oct 16, 2008 at 3:47 PM, LARRY SORENSEN wrote: > > > >> I am using version 5.20.UC2 > >>> To: ids@iiug.org> From: art.kagel@gmail.com> Subject: Re: utils2_ak > Make > >> [13720]> Date: Thu, 16 Oct 2008 15:42:48 -0400>> Weird! Works for me on > >> Ubuntu Hardy Heron:>> art@Galadriel-II:~/Desktop/Latest Art's Stuff$ > >> INFORMIXC=gcc esql> -DHAVE_GNU_GETOPT=1 -o listdb7 listdb7.ec getopt.c>> >> art@Galadriel-II:~/Desktop/Latest Art's Stuff$ ./listdb7> There are > >> currently > >> 5 databases available:>> # Database/Table Name> === > >> ======================= > >>> 1 art> 2 sysadmin> 3 sysmaster> 4 sysuser> 5 sysutils>> What > >> version > >> of ESQL/C are you using? Please run:>> esql -V>> and post the output. > >> Also > >> post the output from:>> head -20 listdb7.ec You should see an entry > >> like:> > >>> Revision 1.19 2006/01/27 17:30:45 kagel>> OK, this REALLY fixed the > >> problem.>> Revision 1.17 2003/10/13 17:06:45 kagel>> FIxed compilation > >> on > >> Linux.>> near the bottom of the listing. There was an old problem > >> compiling > >> that> file on Linux but was fixed a couple of versions ago.>> Art>> On > >> Thu, Oct 16, 2008 at 2:46 PM, LARRY SORENSEN wrote: > >>>> > >>> Art,>>>> Here are the results from the compile attempt:>>>> > >> INFORMIXC=gcc esql -DHAVE_GNU_GETOPT=1 -o listdb7 listdb7.ec getopt.c>>> >> esqlc: "listdb7.ec", line 241: Error -33200: Invalid statement on > symbol> > >>> > >> 'CONNECT'.>> esqlc: "listdb7.ec", line 241: Error -33051: Syntax error > >> on > >> identifier or>> symbol ':'.>> esqlc: "listdb7.ec", line 257: Error > >> -33200: > >> Invalid statement on symbol>> 'CONNECT'.>> esqlc: "listdb7.ec", line > >> 257: > >> Error -33051: Syntax error on identifier or>> symbol ':'.>> esqlc: > >> "listdb7.ec", line 363: Error -33051: Syntax error on identifier or>> > >> symbol > >> 'INTO'.>> esqlc: "listdb7.ec", line 576: Error -33051: Syntax error on > >> identifier or>> symbol 'CONNECTION'.>> esqlc: "listdb7.ec", line 587: > >> Error -33051: Syntax error on identifier or>> symbol 'CONNECTION'.>> > >> esqlc: "listdb7.ec", line 764: Error -33051: Syntax error on identifier > or > >>>> > >> symbol 'CONNECTION'.>> 8 error(s) found>> make: *** [listdb7] Error 1> > >>> > >>>> Larry>>>>>>>>> > >> > >> > > > > ******************************************************************************* > >>>> Forum Note: Use "Reply" to post a response in the discussion forum.>> > >>> > >>>>> --> Art S. Kagel> Oninit (www.oninit.com)> IIUG Board of > >> Directors > >> (art@iiug.org)>> Disclaimer: Please keep in mind that my own opinions > >> are my > >> own opinions and> do not reflect on my employer, Oninit, the IIUG, nor > any > >> other organization> with which I am associated either explicitly or > >> implicitly. Neither do> those opinions reflect those of other > individuals > >> affiliated with any entity> with which I am affiliated nor those of the > >> entities themselves.>>> > >> > >> > > > > ******************************************************************************* > >>> Forum Note: Use "Reply" to post a response in the discussion forum.> > >> > >> > >> > >> > > > > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. > >> > >> > > > > -- > > Art S. Kagel > > Oninit (www.oninit.com) > > IIUG Board of Directors (art@iiug.org) > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > > do not reflect on my employer, Oninit, the IIUG, nor any other > organization > > with which I am associated either explicitly or implicitly. Neither do > > those opinions reflect those of other individuals affiliated with any > entity > > with which I am affiliated nor those of the entities themselves. > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.