SQLCMD - Having issues building sqlcmd-86.00
Posted in 2009
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Platform-Specific Issues
Hey all!
I am trying to build sqlcmd...I have tried various flags and settings
that have worked for me building other
utilities on this system, but sqlcmd is winning at this point. ;)
HP-UX 11.23 Itanium
IBM/Informix-Client SDK Version 3.00.FC3
informix 11.10FC2W2
cc: HP aC++/ANSI C B3910B A.06.10 [Mar 22 2006]
I used the configurator straight, also tried : CC="cc -O -Ae +DD64 "
./configure
Also tried messing with Makefile...following error real consistent for
- Hide quoted text -
me:
make
INFORMIXC="cc" esql -DESQLC_VERSION=300 -O -Ae +DD64 -I.-I/opt/isv/ifx_cphpad2c/informix_11.1FC2/incl/esql -O -
DHAVE_CONFIG_H
-g -O -Ae +DD64 -c reload.ec
"reload.ec", line 104: error #2029: expected an expression
{ [T_IDENT] = S1, [T_SQS] = S2,
^
"reload.ec", line 104: error #2029: expected an expression
{ [T_IDENT] = S1, [T_SQS] = S2,
^
"reload.ec", line 105: error #2029: expected an expression
[T_DQS] = S3, [T_AT] = SX,
^
"reload.ec", line 105: error #2029: expected an expression
[T_DQS] = S3, [T_AT] = SX,
^
"reload.ec", line 106: error #2029: expected an expression
[T_COLON] = SX, [T_DOT] = SX,
^
>>snip<<
^
"reload.ec", line 142: error #2029: expected an expression
[T_PAREN] = S5,
^
56 errors detected in the compilation of "reload.c".
*** Error exit code 2
Stop.
code snippet:
/* Token types and state names */
/* NB: assumes delimited identifiers are OK - they are not always. */
enum { T_IDENT, T_SQS, T_DQS, T_AT, T_COLON, T_DOT, T_PAREN,
T_ERROR };
enum { S0, S1, S2, S3, S4, S5, S6, S7, SX, SF, SS, SP };
static const char stt[8][7] =
{
{ [T_IDENT] = S1, [T_SQS] = S2,
[T_DQS] = S3, [T_AT] = SX,
[T_COLON] = SX, [T_DOT] = SX,
[T_PAREN] = SX,
},
{ [T_IDENT] = SX, [T_SQS] = SX,
[T_DQS] = SX, [T_AT] = S4,
[T_COLON] = S5, [T_DOT] = S6,
[T_PAREN] = SP,
},
{ [T_IDENT] = SX, [T_SQS] = SX,
[T_DQS] = SX, [T_AT] = SX,
[T_COLON] = SX, [T_DOT] = S6,
[T_PAREN] = SX,
},
{ [T_IDENT] = SX, [T_SQS] = SX,
[T_DQS] = SX, [T_AT] = SX,
[T_COLON] = SX, [T_DOT] = S6,
[T_PAREN] = SP,
},
{ [T_IDENT] = S7, [T_SQS] = SX,
[T_DQS] = SX, [T_AT] = SX,
[T_COLON] = SX, [T_DOT] = SX,
[T_PAREN] = SX,
},
{ [T_IDENT] = S3, [T_SQS] = S2,
[T_DQS] = S3, [T_AT] = SX,
[T_COLON] = SX, [T_DOT] = SX,
[T_PAREN] = SX,
},
{ [T_IDENT] = SF, [T_SQS] = SX,
[T_DQS] = SS, [T_AT] = SX,
[T_COLON] = SX, [T_DOT] = SX,
[T_PAREN] = SX,
},
{ [T_IDENT] = SX, [T_SQS] = SX,
[T_DQS] = SX, [T_AT] = SX,
[T_COLON] = S5, [T_DOT] = S5,
[T_PAREN] = S5,
},
};
--
Sam Gentsch
in4mix@gmail.com
Sqlcmd comes with a configure script and a make file. If you run configure
it will write out an ideal makefile and even modify some of the include
files to make sqlcmd compile just fine on your platform.
Art
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.
On Tue, Jun 9, 2009 at 5:43 PM, in4mix <in4mix@gmail.com> wrote:
> Hey all!
>
> I am trying to build sqlcmd...I have tried various flags and settings
> that have worked for me building other
> utilities on this system, but sqlcmd is winning at this point. ;)
>
> HP-UX 11.23 Itanium
> IBM/Informix-Client SDK Version 3.00.FC3
> informix 11.10FC2W2
> cc: HP aC++/ANSI C B3910B A.06.10 [Mar 22 2006]
>
> I used the configurator straight, also tried : CC="cc -O -Ae +DD64 "
> ./configure
> Also tried messing with Makefile...following error real consistent for
> - Hide quoted text -
> me:
>
> make
> INFORMIXC="cc" esql -DESQLC_VERSION=300 -O -Ae +DD64 -I.> -I/opt/isv/ifx_cphpad2c/informix_11.1FC2/incl/esql -O -
> DHAVE_CONFIG_H
> -g -O -Ae +DD64 -c reload.ec
> "reload.ec", line 104: error #2029: expected an expression
> { [T_IDENT] = S1, [T_SQS] = S2,
> ^
>
> "reload.ec", line 104: error #2029: expected an expression
> { [T_IDENT] = S1, [T_SQS] = S2,
> ^
>
> "reload.ec", line 105: error #2029: expected an expression
> [T_DQS] = S3, [T_AT] = SX,
> ^
>
> "reload.ec", line 105: error #2029: expected an expression
> [T_DQS] = S3, [T_AT] = SX,
> ^
>
> "reload.ec", line 106: error #2029: expected an expression
> [T_COLON] = SX, [T_DOT] = SX,
> ^
> >>snip<<
> ^
>
> "reload.ec", line 142: error #2029: expected an expression
> [T_PAREN] = S5,
> ^
>
> 56 errors detected in the compilation of "reload.c".
> *** Error exit code 2
>
> Stop.
>
> code snippet:
> /* Token types and state names */
> /* NB: assumes delimited identifiers are OK - they are not always. */
> enum { T_IDENT, T_SQS, T_DQS, T_AT, T_COLON, T_DOT, T_PAREN,
> T_ERROR };
> enum { S0, S1, S2, S3, S4, S5, S6, S7, SX, SF, SS, SP };
>
> static const char stt[8][7] =
> {
> { [T_IDENT] = S1, [T_SQS] = S2,
> [T_DQS] = S3, [T_AT] = SX,
> [T_COLON] = SX, [T_DOT] = SX,
> [T_PAREN] = SX,
> },
> { [T_IDENT] = SX, [T_SQS] = SX,
> [T_DQS] = SX, [T_AT] = S4,
> [T_COLON] = S5, [T_DOT] = S6,
> [T_PAREN] = SP,
> },
> { [T_IDENT] = SX, [T_SQS] = SX,
> [T_DQS] = SX, [T_AT] = SX,
> [T_COLON] = SX, [T_DOT] = S6,
> [T_PAREN] = SX,
> },
> { [T_IDENT] = SX, [T_SQS] = SX,
> [T_DQS] = SX, [T_AT] = SX,
> [T_COLON] = SX, [T_DOT] = S6,
> [T_PAREN] = SP,
> },
> { [T_IDENT] = S7, [T_SQS] = SX,
> [T_DQS] = SX, [T_AT] = SX,
> [T_COLON] = SX, [T_DOT] = SX,
> [T_PAREN] = SX,
> },
> { [T_IDENT] = S3, [T_SQS] = S2,
> [T_DQS] = S3, [T_AT] = SX,
> [T_COLON] = SX, [T_DOT] = SX,
> [T_PAREN] = SX,
> },
> { [T_IDENT] = SF, [T_SQS] = SX,
> [T_DQS] = SS, [T_AT] = SX,
> [T_COLON] = SX, [T_DOT] = SX,
> [T_PAREN] = SX,
> },
> { [T_IDENT] = SX, [T_SQS] = SX,
> [T_DQS] = SX, [T_AT] = SX,
> [T_COLON] = S5, [T_DOT] = S5,
> [T_PAREN] = S5,
> },
> };
>
>
>
> --
> Sam Gentsch
> in4mix@gmail.com
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
Oh believe me, I read the documentation, and I used the configurator
(./configure), no joy.
I did set the 64 bit flag the first time, like the INSTALL doc
instructed. NO joy.
Unset the 64 bit flag and ran ./configure again..No joy.
Then I tried other things that worked when I compiled your utilities.
I can start fresh and try again.
On Jun 9, 6:01 pm, Art Kagel <art.ka...@gmail.com> wrote:
> Sqlcmd comes with a configure script and a make file. If you run configure
> it will write out an ideal makefile and even modify some of the include
> files to make sqlcmd compile just fine on your platform.
>
> Art
>
> Art S. Kagel
> Oninit (www.oninit.com)
> IIUG Board of Directors (a...@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.
>
> On Tue, Jun 9, 2009 at 5:43 PM, in4mix <in4...@gmail.com> wrote:
> > Hey all!
>
> > I am trying to build sqlcmd...I have tried various flags and settings
> > that have worked for me building other
> > utilities on this system, but sqlcmd is winning at this point. ;)
>
> > HP-UX 11.23 Itanium
> > IBM/Informix-Client SDK Version 3.00.FC3
> > informix 11.10FC2W2
> > cc: HP aC++/ANSI C B3910B A.06.10 [Mar 22 2006]
>
> > I used the configurator straight, also tried : CC="cc -O -Ae +DD64 "
> > ./configure
> > Also tried messing with Makefile...following error real consistent for
> > - Hide quoted text -
> > me:
>
> > make
> > INFORMIXC="cc" esql -DESQLC_VERSION=300 -O -Ae +DD64 -I.> > -I/opt/isv/ifx_cphpad2c/informix_11.1FC2/incl/esql -O -
> > DHAVE_CONFIG_H
> > -g -O -Ae +DD64 -c reload.ec
> > "reload.ec", line 104: error #2029: expected an expression
> > { [T_IDENT] = S1, [T_SQS] = S2,
> > ^
>
> > "reload.ec", line 104: error #2029: expected an expression
> > { [T_IDENT] = S1, [T_SQS] = S2,
> > ^
>
> > "reload.ec", line 105: error #2029: expected an expression
> > [T_DQS] = S3, [T_AT] = SX,
> > ^
>
> > "reload.ec", line 105: error #2029: expected an expression
> > [T_DQS] = S3, [T_AT] = SX,
> > ^
>
> > "reload.ec", line 106: error #2029: expected an expression
> > [T_COLON] = SX, [T_DOT] = SX,
> > ^
> > >>snip<<
> > ^
>
> > "reload.ec", line 142: error #2029: expected an expression
> > [T_PAREN] = S5,
> > ^
>
> > 56 errors detected in the compilation of "reload.c".
> > *** Error exit code 2
>
> > Stop.
>
> > code snippet:
> > /* Token types and state names */
> > /* NB: assumes delimited identifiers are OK - they are not always. */
> > enum { T_IDENT, T_SQS, T_DQS, T_AT, T_COLON, T_DOT, T_PAREN,
> > T_ERROR };
> > enum { S0, S1, S2, S3, S4, S5, S6, S7, SX, SF, SS, SP };
>
> > static const char stt[8][7] =
> > {
> > { [T_IDENT] = S1, [T_SQS] = S2,
> > [T_DQS] = S3, [T_AT] = SX,
> > [T_COLON] = SX, [T_DOT] = SX,
> > [T_PAREN] = SX,
> > },
> > { [T_IDENT] = SX, [T_SQS] = SX,
> > [T_DQS] = SX, [T_AT] = S4,
> > [T_COLON] = S5, [T_DOT] = S6,
> > [T_PAREN] = SP,
> > },
> > { [T_IDENT] = SX, [T_SQS] = SX,
> > [T_DQS] = SX, [T_AT] = SX,
> > [T_COLON] = SX, [T_DOT] = S6,
> > [T_PAREN] = SX,
> > },
> > { [T_IDENT] = SX, [T_SQS] = SX,
> > [T_DQS] = SX, [T_AT] = SX,
> > [T_COLON] = SX, [T_DOT] = S6,
> > [T_PAREN] = SP,
> > },
> > { [T_IDENT] = S7, [T_SQS] = SX,
> > [T_DQS] = SX, [T_AT] = SX,
> > [T_COLON] = SX, [T_DOT] = SX,
> > [T_PAREN] = SX,
> > },
> > { [T_IDENT] = S3, [T_SQS] = S2,
> > [T_DQS] = S3, [T_AT] = SX,
> > [T_COLON] = SX, [T_DOT] = SX,
> > [T_PAREN] = SX,
> > },
> > { [T_IDENT] = SF, [T_SQS] = SX,
> > [T_DQS] = SS, [T_AT] = SX,
> > [T_COLON] = SX, [T_DOT] = SX,
> > [T_PAREN] = SX,
> > },
> > { [T_IDENT] = SX, [T_SQS] = SX,
> > [T_DQS] = SX, [T_AT] = SX,
> > [T_COLON] = S5, [T_DOT] = S5,
> > [T_PAREN] = S5,
> > },
> > };
>
> > --
> > Sam Gentsch
> > in4...@gmail.com
> > _______________________________________________
> > Informix-list mailing list
> > Informix-l...@iiug.org
> >http://www.iiug.org/mailman/listinfo/informix-list
On Tue, Jun 9, 2009 at 14:43, in4mix<in4mix@gmail.com> wrote:
> Hey all!
>
> I am trying to build sqlcmd...I have tried various flags and settings
> that have worked for me building other
> utilities on this system, but sqlcmd is winning at this point. ;)
>
> HP-UX 11.23 Itanium
> IBM/Informix-Client SDK Version 3.00.FC3
> informix 11.10FC2W2
> cc: HP aC++/ANSI C B3910B A.06.10 [Mar 22 2006]
>
> I used the configurator straight, also tried : CC="cc -O -Ae +DD64 "
> ./configure
> Also tried messing with Makefile...following error real consistent for me:
>
> make
> INFORMIXC="cc" esql -DESQLC_VERSION=300 -O -Ae +DD64 -I.> -I/opt/isv/ifx_cphpad2c/informix_11.1FC2/incl/esql -O -
> DHAVE_CONFIG_H
> -g -O -Ae +DD64 -c reload.ec
> "reload.ec", line 104: error #2029: expected an expression
> { [T_IDENT] = S1, [T_SQS] = S2,
> ^
>
> "reload.ec", line 104: error #2029: expected an expression
That's using C99 notation for the initializer. You should investigate
whether there is an option to the HP-UX compiler that makes it
recognize C99 syntax. If not, get back to me.
I found release notes for A.06.12 at
http://docs.hp.com/en/5991-7408/5991-7408.pdf and it appears that it
does not support C99. Any chance you can upgrade to a more recent
version of the compiler?
(I also found release notes for a version B.11.11.08, for HP-UX 11i
(and you're on a more recent version of HP-UX than that!)
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/
"Blessed are we who can laugh at ourselves, for we shall never cease
to be amused."
NB: Please do not use this email for correspondence.
I don't necessarily read it every week, even.
Dan Quayle - "This President is going to lead us out of this
recovery." - http://www.brainyquote.com/quotes/authors/d/dan_quayle.html
OK so the C99 magic for HP-UX 11.23 Itanium and cc seems to be:CC="/
opt/aCC/bin/aCC -AC99" ./configure
I also ran into yacc issues (I hate yacc'ing first thing in the
morning)
the INSTALL mentioned yacc free makes, so followed those directions:
specifically: mv connecty.y old.connecty.y ;mv connecty.c.std
connecty.c
I seem to have a solid build, and was able to select from a table on a
remote Instance. Woo!
For others building, I should mention make clean between botched
attempts does wonders also.
Thanks so much for the help.
Sam
On Jun 9, 8:53 pm, Jonathan Leffler <jleffler.i...@gmail.com> wrote:
> On Tue, Jun 9, 2009 at 14:43, in4mix<in4...@gmail.com> wrote:
> > Hey all!
>
> > I am trying to build sqlcmd...I have tried various flags and settings
> > that have worked for me building other
> > utilities on this system, but sqlcmd is winning at this point. ;)
>
> > HP-UX 11.23 Itanium
> > IBM/Informix-Client SDK Version 3.00.FC3
> > informix 11.10FC2W2
> > cc: HP aC++/ANSI C B3910B A.06.10 [Mar 22 2006]
>
> > I used the configurator straight, also tried : CC="cc -O -Ae +DD64 "
> > ./configure
> > Also tried messing with Makefile...following error real consistent for me:
>
> > make
> > INFORMIXC="cc" esql -DESQLC_VERSION=300 -O -Ae +DD64 -I.> > -I/opt/isv/ifx_cphpad2c/informix_11.1FC2/incl/esql -O -
> > DHAVE_CONFIG_H
> > -g -O -Ae +DD64 -c reload.ec
> > "reload.ec", line 104: error #2029: expected an expression
> > { [T_IDENT] = S1, [T_SQS] = S2,
> > ^
>
> > "reload.ec", line 104: error #2029: expected an expression
>
> That's using C99 notation for the initializer. You should investigate
> whether there is an option to the HP-UX compiler that makes it
> recognize C99 syntax. If not, get back to me.
>
> I found release notes for A.06.12 athttp://docs.hp.com/en/5991-7408/5991-7408.pdfand it appears that it
> does not support C99. Any chance you can upgrade to a more recent
> version of the compiler?
>
> (I also found release notes for a version B.11.11.08, for HP-UX 11i
> (and you're on a more recent version of HP-UX than that!)
>
> --
> Jonathan Leffler #include <disclaimer.h>
> Email: jleff...@earthlink.net, jleff...@us.ibm.com
> Guardian of DBD::Informix v2008.0513 --http://dbi.perl.org/
> "Blessed are we who can laugh at ourselves, for we shall never cease
> to be amused."
> NB: Please do not use this email for correspondence.
> I don't necessarily read it every week, even.
> Dan Quayle - "This President is going to lead us out of this
> recovery." -http://www.brainyquote.com/quotes/authors/d/dan_quayle.html