Post Upgrade ESQLC issue
Posted in 2010
Topics: High Availability & Replication, Installation, Setup & Upgrades, Connectivity: ESQL/C, 4GL & Embedded SQL, Data Types & Schema Design, Versions, Editions & End-of-Life
IDS 11.50.UC6W2X2
ESQLC 3.50.UC6
After upgrading our dev server to 11.50.UC6W2X2 are developers hollered that
they cannot compile .ec files anymore. I tried compiling one of the demo
programs, $INFORMIXDIR/demo/esqlc/varchar.c and got the same errors as the
developers. I am swamped with other issues pertaining to the upgrade and at
the moment cannot look into this one - any help is appreciated. Here is a
sample of the errors returned:
esql /opt/informix/demo/esqlc/varchar.ec -o vchar.exe
/opt/informix/11.5/incl/esql/sqlhdr.h", line 399: warning: const is a keyword
in ANSI C
/opt/informix/11.5/incl/esql/sqlhdr.h", line 399: syntax error before or at:
bigint
/opt/informix/11.5/incl/esql/sqlhdr.h", line 399: warning: undefined or
missing type for: bigint
/opt/informix/11.5/incl/esql/sqlhdr.h", line 399: warning: undefined or
missing type for: int2
/opt/informix/11.5/incl/esql/sqlhdr.h", line 401: syntax error before or at:
int2
/opt/informix/11.5/incl/esql/sqlhdr.h", line 401: warning: undefined or
missing type for: int2
/opt/informix/11.5/incl/esql/sqlhdr.h", line 401: warning: undefined or
missing type for: bigint
/opt/informix/11.5/incl/esql/sqlhdr.h", line 403: syntax error before or at:
bigint
/opt/informix/11.5/incl/esql/sqlhdr.h", line 403: warning: undefined or
missing type for: bigint
/opt/informix/11.5/incl/esql/sqlhdr.h", line 403: warning: undefined or
missing type for: int4
/opt/informix/11.5/incl/esql/sqlhdr.h", line 405: syntax error before or at:
int4
These errors continue for various other types, etc
.
And then it changes to a diff include file:
"/opt/informix/11.5/incl/esql/sqliapi.h", line 35: syntax error before or at:
char
"/opt/informix/11.5/incl/esql/sqliapi.h", line 35: warning: undefined or
missing type for: char
"/opt/informix/11.5/incl/esql/sqliapi.h", line 35: warning: undefined or
missing type for: mint
"/opt/informix/11.5/incl/esql/sqliapi.h", line 36: syntax error before or at:
char
"/opt/informix/11.5/incl/esql/sqliapi.h", line 36: warning: undefined or
missing type for: char
"/opt/informix/11.5/incl/esql/sqliapi.h", line 37: syntax error before or at:
const
"/opt/informix/11.5/incl/esql/sqliapi.h", line 37: warning: undefined or
missing type for: const
"/opt/informix/11.5/incl/esql/sqliapi.h", line 37: warning: undefined or
missing type for: mint
"/opt/informix/11.5/incl/esql/sqliapi.h", line 37: warning: undefined or
missing type for: ifx_hostv
ar_t
"/opt/informix/11.5/incl/esql/sqliapi.h", line 37: warning: undefined or
missing type for: mint
"/opt/informix/11.5/incl/esql/sqliapi.h", line 38: syntax error before or at:
const
"/opt/informix/11.5/incl/esql/sqliapi.h", line 38: warning: undefined or
missing type for: const
This also continues with additional missing types, etc.
Version info:
informix@rmkc00b/opt/informix/11.5/demo/esqlc>esql -V
IBM Informix CSDK Version 3.50, IBM Informix-ESQL Version 3.50.UC6
Software Serial Number AAA#B000000
informix@rmkc00b/opt/informix/11.5/demo/esqlc>oninit -V
IBM Informix Dynamic Server Version 11.50.UC6W2X2 Software Serial Number
AAA#B000000
Thu May 6 18:07:01 CDT 2010
It looks like your developers are still seeing the older esql executables
but looking at the newer header files. Check their login paths in
/etc/profile, their private profiles, or other environment set up file. It
could be as simple as that no ones has logged out and back in to reset their
PATH to the new $INFORMXIDIR/bin
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.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, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. 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 Wed, May 19, 2010 at 11:18 AM, MIKE MAGIE <jmmagie@yahoo.com> wrote:
> IDS 11.50.UC6W2X2
> ESQLC 3.50.UC6
>
> After upgrading our dev server to 11.50.UC6W2X2 are developers hollered
> that
> they cannot compile .ec files anymore. I tried compiling one of the demo
> programs, $INFORMIXDIR/demo/esqlc/varchar.c and got the same errors as the
> developers. I am swamped with other issues pertaining to the upgrade and at
> the moment cannot look into this one - any help is appreciated. Here is a
> sample of the errors returned:
>
> esql /opt/informix/demo/esqlc/varchar.ec -o vchar.exe
>
> /opt/informix/11.5/incl/esql/sqlhdr.h", line 399: warning: const is a
> keyword
> in ANSI C
> /opt/informix/11.5/incl/esql/sqlhdr.h", line 399: syntax error before or
> at:
> bigint
> /opt/informix/11.5/incl/esql/sqlhdr.h", line 399: warning: undefined or
> missing type for: bigint
> /opt/informix/11.5/incl/esql/sqlhdr.h", line 399: warning: undefined or
> missing type for: int2
> /opt/informix/11.5/incl/esql/sqlhdr.h", line 401: syntax error before or
> at:
> int2
> /opt/informix/11.5/incl/esql/sqlhdr.h", line 401: warning: undefined or
> missing type for: int2
> /opt/informix/11.5/incl/esql/sqlhdr.h", line 401: warning: undefined or
> missing type for: bigint
> /opt/informix/11.5/incl/esql/sqlhdr.h", line 403: syntax error before or
> at:
> bigint
> /opt/informix/11.5/incl/esql/sqlhdr.h", line 403: warning: undefined or
> missing type for: bigint
> /opt/informix/11.5/incl/esql/sqlhdr.h", line 403: warning: undefined or
> missing type for: int4
> /opt/informix/11.5/incl/esql/sqlhdr.h", line 405: syntax error before or
> at:
> int4
>
> These errors continue for various other types, etc
.
>
> And then it changes to a diff include file:
>
> "/opt/informix/11.5/incl/esql/sqliapi.h", line 35: syntax error before or
> at:
> char
> "/opt/informix/11.5/incl/esql/sqliapi.h", line 35: warning: undefined or
> missing type for: char
> "/opt/informix/11.5/incl/esql/sqliapi.h", line 35: warning: undefined or
> missing type for: mint
> "/opt/informix/11.5/incl/esql/sqliapi.h", line 36: syntax error before or
> at:
> char
> "/opt/informix/11.5/incl/esql/sqliapi.h", line 36: warning: undefined or
> missing type for: char
> "/opt/informix/11.5/incl/esql/sqliapi.h", line 37: syntax error before or
> at:
> const
> "/opt/informix/11.5/incl/esql/sqliapi.h", line 37: warning: undefined or
> missing type for: const
> "/opt/informix/11.5/incl/esql/sqliapi.h", line 37: warning: undefined or
> missing type for: mint
> "/opt/informix/11.5/incl/esql/sqliapi.h", line 37: warning: undefined or
> missing type for: ifx_hostv
> ar_t
> "/opt/informix/11.5/incl/esql/sqliapi.h", line 37: warning: undefined or
> missing type for: mint
> "/opt/informix/11.5/incl/esql/sqliapi.h", line 38: syntax error before or
> at:
> const
> "/opt/informix/11.5/incl/esql/sqliapi.h", line 38: warning: undefined or
> missing type for: const
>
> This also continues with additional missing types, etc.
>
> Version info:
>
> informix@rmkc00b/opt/informix/11.5/demo/esqlc>esql -V
> IBM Informix CSDK Version 3.50, IBM Informix-ESQL Version 3.50.UC6
> Software Serial Number AAA#B000000
>
> informix@rmkc00b/opt/informix/11.5/demo/esqlc>oninit -V
> IBM Informix Dynamic Server Version 11.50.UC6W2X2 Software Serial Number
> AAA#B000000
> Thu May 6 18:07:01 CDT 2010
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--00504502c09c7cb0b904871c548b
Did you get this sorted out?
What was the old version of ESQL/C that you were using before?
Are you on HP-UX?
Are you using the bundled C compiler - as opposed to the purchasable ANSI C
compiler?
Do you have a sufficiently modern C compiler installed?
Are you able to establish whether the errors come from the ESQL/C compiler
($INFORMIXDIR/lib/esql/esqlc) or from the C compiler?
On Wed, May 19, 2010 at 08:18, MIKE MAGIE <jmmagie@yahoo.com> wrote:
> IDS 11.50.UC6W2X2
> ESQLC 3.50.UC6
>
> After upgrading our dev server to 11.50.UC6W2X2 are developers hollered
> that
> they cannot compile .ec files anymore. I tried compiling one of the demo
> programs, $INFORMIXDIR/demo/esqlc/varchar.c and got the same errors as the
> developers. I am swamped with other issues pertaining to the upgrade and at
> the moment cannot look into this one - any help is appreciated. Here is a
> sample of the errors returned:
>
> esql /opt/informix/demo/esqlc/varchar.ec -o vchar.exe
>
> /opt/informix/11.5/incl/esql/sqlhdr.h", line 399: warning: const is a
> keyword
> in ANSI C
> /opt/informix/11.5/incl/esql/sqlhdr.h", line 399: syntax error before or
> at:
> bigint
> /opt/informix/11.5/incl/esql/sqlhdr.h", line 399: warning: undefined or
> missing type for: bigint
> /opt/informix/11.5/incl/esql/sqlhdr.h", line 399: warning: undefined or
> missing type for: int2
> /opt/informix/11.5/incl/esql/sqlhdr.h", line 401: syntax error before or
> at:
> int2
> /opt/informix/11.5/incl/esql/sqlhdr.h", line 401: warning: undefined or
> missing type for: int2
> /opt/informix/11.5/incl/esql/sqlhdr.h", line 401: warning: undefined or
> missing type for: bigint
> /opt/informix/11.5/incl/esql/sqlhdr.h", line 403: syntax error before or
> at:
> bigint
> /opt/informix/11.5/incl/esql/sqlhdr.h", line 403: warning: undefined or
> missing type for: bigint
> /opt/informix/11.5/incl/esql/sqlhdr.h", line 403: warning: undefined or
> missing type for: int4
> /opt/informix/11.5/incl/esql/sqlhdr.h", line 405: syntax error before or
> at:
> int4
>
> These errors continue for various other types, etc
.
>
> And then it changes to a diff include file:
>
> "/opt/informix/11.5/incl/esql/sqliapi.h", line 35: syntax error before or
> at:
> char
> "/opt/informix/11.5/incl/esql/sqliapi.h", line 35: warning: undefined or
> missing type for: char
> "/opt/informix/11.5/incl/esql/sqliapi.h", line 35: warning: undefined or
> missing type for: mint
> "/opt/informix/11.5/incl/esql/sqliapi.h", line 36: syntax error before or
> at:
> char
> "/opt/informix/11.5/incl/esql/sqliapi.h", line 36: warning: undefined or
> missing type for: char
> "/opt/informix/11.5/incl/esql/sqliapi.h", line 37: syntax error before or
> at:
> const
> "/opt/informix/11.5/incl/esql/sqliapi.h", line 37: warning: undefined or
> missing type for: const
> "/opt/informix/11.5/incl/esql/sqliapi.h", line 37: warning: undefined or
> missing type for: mint
> "/opt/informix/11.5/incl/esql/sqliapi.h", line 37: warning: undefined or
> missing type for: ifx_hostv
> ar_t
> "/opt/informix/11.5/incl/esql/sqliapi.h", line 37: warning: undefined or
> missing type for: mint
> "/opt/informix/11.5/incl/esql/sqliapi.h", line 38: syntax error before or
> at:
> const
> "/opt/informix/11.5/incl/esql/sqliapi.h", line 38: warning: undefined or
> missing type for: const
>
> This also continues with additional missing types, etc.
>
> Version info:
>
> informix@rmkc00b/opt/informix/11.5/demo/esqlc>esql -V
> IBM Informix CSDK Version 3.50, IBM Informix-ESQL Version 3.50.UC6
> Software Serial Number AAA#B000000
>
> informix@rmkc00b/opt/informix/11.5/demo/esqlc>oninit -V
> IBM Informix Dynamic Server Version 11.50.UC6W2X2 Software Serial Number
> AAA#B000000
> Thu May 6 18:07:01 CDT 2010
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
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.
--0050450143d1b6dee70487dd0a20