IDS Forum

RE: installing sqlcmd

Posted By: John Adamski (Work Account)
Date: Monday, 3 April 2017, at 9:13 a.m.

In Response To: Re: installing sqlcmd (Jonathan Leffler)

Running the gccpragmata script on esnprintf.c and stderr.c then trying the make process again got it to install correctly.

Thanks for the help.

John

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Jonathan Leffler
Sent: Friday, March 31, 2017 3:01 PM
To: ids@iiug.org
Subject: Re: installing sqlcmd [38843]

Hi John,

Thanks for letting me know about this and I'm sorry for the trouble that's been caused.

It's curious I've not seen that error (about the scope of #pragma). GCC
6.3.0 on a Mac doesn't give it; neither does GCC 5.2.0, nor 4.9.1, nor
4.8.1 (which is as far back as I've still got builds). Oh well!

Do you have a script gccpragmata in the SQLCMD download?

$ gccpragmata -h
Usage: gccpragmata [-clnpu][-hV] [file ...] -c Convert #pragma GCC to a comment -h Print this help message and exit -l List files containing #pragma GCC -n Print line numbers -p Print GCC pragmata lines only (default) -u Convert comments containing #pragma GCC to active code -V Print version information and exit $

In case you haven't got it, I attached it. You'd need to do something like:

gccpragmata -c esnprintf.c > x
mv esnprintf.c esnprintf.c.original
mv x esnprintf.c

This converts the pragmata to comments. I don't know why I haven't implemented a -d option to delete the pragmata. An in-place editing option might be useful too, but isn't simple to do generically across all variants of Unix with standard tools. (I have a shell script that achieves in-place editing, but I didn't want to overburden everyone with all the code I have).

I've since removed the pragmata from the source code (so esnprintf.c 1.9 doesn't have them any more; you must have 1.8 since that's when the pragmata were added). I simply decide that those warnings
(-Wformat-nonliteral) are not sufficiently useful and ignore them via a command-line option when I'm doing my most stringent testing. You can apply the same technique to any other file that gives you the same grief that would be just stderr.c, I think. Only getopt.h has pragmata otherwise, and they're for -Wredundant-decls and aren't in function scope (altogether less likely to cause grief).

Let me know if you have other problems with the build.

On Fri, Mar 31, 2017 at 12:28 PM, John Adamski (Work Account) < adamski@graceland.edu> wrote:

> Suse enterprise 11 sp4
> Informix 12.10.FC6
>
> I'm trying to install sqlcmd on our new suse linux server, and it gets
> an error when I do the make command. The configure step I think looks clean.
>
> Any ideas what I need to do?
>
> nova:/opt/informix/sqlcmd-90.00 # ./configure Configuring sqlcmd
> version 90.00 checking for gawk... gawk checking for gcc... gcc
> checking whether the C compiler works... yes checking for C compiler
> default output file name... a.out checking for suffix of
> executables...
> checking whether we are cross compiling... no checking for suffix of
> object files... o checking whether we are using the GNU C compiler...
> yes checking whether gcc accepts -g... yes checking for gcc option to
> accept ISO C89... none needed checking for gcc option to accept ISO
> C99... -std=gnu99 checking for a BSD-compatible install...
> /usr/bin/install -c checking whether ln -s works... yes checking for
> ranlib... ranlib checking for bison... bison -y checking for perl...
> no checking how to run the C preprocessor... gcc -std=gnu99 -E
> checking for grep that handles long lines and -e... /usr/bin/grep
> checking for egrep... /usr/bin/grep -E checking for ANSI C header
> files... yes checking for sys/types.h... yes checking for
> sys/stat.h... yes checking for stdlib.h... yes checking for
> string.h... yes checking for memory.h... yes checking for strings.h...
> yes checking for inttypes.h... yes checking for stdint.h... yes
> checking for unistd.h... yes checking sys/time.h usability... yes
> checking sys/time.h presence... yes checking for sys/time.h... yes
> checking for unistd.h... (cached) yes checking search.h usability...
> yes checking search.h presence... yes checking for search.h... yes
> checking fcntl.h usability... yes checking fcntl.h presence... yes
> checking for fcntl.h... yes checking for an ANSI C-conforming const...
> yes checking for size_t... yes checking for mode_t... yes checking for
> uintptr_t... yes checking whether time.h and sys/time.h may both be
> included... yes checking whether struct tm is in sys/time.h or
> time.h... time.h checking for strftime... yes checking for vprintf...
> yes checking for _doprnt... no checking for fcntl... yes checking for
> isatty... yes checking for lfind... yes checking for memmove... yes
> checking for mkfifo... yes checking for sigaction... yes checking for
> siglongjmp... yes checking for sleep... yes checking for snprintf...
> yes checking for strerror... yes checking for strftime... (cached) yes
> checking for strtod... yes checking for strtol... yes checking for
> vprintf... (cached) yes checking for clock_nanosleep... no checking
> for nanosleep... yes checking for usleep... yes checking for getopt...
> yes checking for getsubopt... yes checking for popen... yes checking
> for vsnprintf... yes checking for mkstemp... yes checking for
> memmem... yes checking for special C compiler options needed for large
> files... no checking for _FILE_OFFSET_BITS value needed for large
> files... no checking for main in -lreadline... no checking
> readline/readline.h usability... no checking readline/readline.h
> presence... no checking for readline/readline.h... no checking for
> /dev/stdin, /dev/stdout, /dev/stderr... yes checking for
> INFORMIXDIR... /opt/informix checking for ESQL/C compiler and
> version... compiler esql (version 410) checking for 32-bit vs 64-bit
> ESQL/C... 32 bits checking ESQL/C compiler works... OK checking ESQL/C
> Features... esqlinfo.h written checking special C compiler flags for
> ESQL/C... yes ESQLC_CCFLAGS=-m32 checking for ESQL/C header
> directory... /opt/informix/incl/esql checking for ESQL/C varchar.h
> header... yes checking build system type... x86_64-unknown-linux-gnu
> checking host system type... x86_64-unknown-linux-gnu checking target
> system type... x86_64-unknown-linux-gnu checking for loc_t problems on
> AIX... no, thank goodness!
> checking for clock_gettime in -lposix4... no checking for
> fine-resolution timing checking for clock_gettime... no checking for
> gettimeofday... yes Fine-resolution timing will use Unix-98
> gettimeofday()
> configure: creating ./config.status
> config.status: creating Makefile
> config.status: creating sqlcmd.ins
> config.status: creating selmultiblob.mk
> config.status: creating config.h
> nova:/opt/informix/sqlcmd-90.00 # make INFORMIXC="gcc -std=gnu99" esql
> -DESQLC_VERSION=410 -m32 -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c appblob.ec rm
> -f appblob.c INFORMIXC="gcc -std=gnu99" esql -DESQLC_VERSION=410 -m32
> -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c connblob.ec rm
> -f connblob.c gcc -std=gnu99 -DESQLC_VERSION=410 -m32 -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c -o basedigit.o
> basedigit.c gcc -std=gnu99 -DESQLC_VERSION=410 -m32 -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c -o basename.o
> basename.c gcc -std=gnu99 -DESQLC_VERSION=410 -m32 -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c -o chkfifo.o
> chkfifo.c gcc -std=gnu99 -DESQLC_VERSION=410 -m32 -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c -o chktty.o
> chktty.c gcc -std=gnu99 -DESQLC_VERSION=410 -m32 -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c -o chrcstrlit.o
> chrcstrlit.c gcc -std=gnu99 -DESQLC_VERSION=410 -m32 -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c -o cistrcmp.o
> cistrcmp.c gcc -std=gnu99 -DESQLC_VERSION=410 -m32 -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c -o conninfo.o
> conninfo.c gcc -std=gnu99 -DESQLC_VERSION=410 -m32 -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c -o context.o
> context.c gcc -std=gnu99 -DESQLC_VERSION=410 -m32 -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c -o cstrlitchr.o
> cstrlitchr.c gcc -std=gnu99 -DESQLC_VERSION=410 -m32 -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c -o cstrlitstr.o
> cstrlitstr.c gcc -std=gnu99 -DESQLC_VERSION=410 -m32 -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c -o datefmt.o
> datefmt.c gcc -std=gnu99 -DESQLC_VERSION=410 -m32 -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c -o debug.o
> debug.c gcc -std=gnu99 -DESQLC_VERSION=410 -m32 -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c -o decfix.o
> decfix.c gcc -std=gnu99 -DESQLC_VERSION=410 -m32 -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c -o decsci.o
> decsci.c gcc -std=gnu99 -DESQLC_VERSION=410 -m32 -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c -o decsetexp.o
> decsetexp.c INFORMIXC="gcc -std=gnu99" esql -DESQLC_VERSION=410 -m32
> -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c describe.ec rm
> -f describe.c INFORMIXC="gcc -std=gnu99" esql -DESQLC_VERSION=410 -m32
> -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c dumpblob.ec rm
> -f dumpblob.c INFORMIXC="gcc -std=gnu99" esql -DESQLC_VERSION=410 -m32
> -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c dumpdec.ec rm
> -f dumpdec.c INFORMIXC="gcc -std=gnu99" esql -DESQLC_VERSION=410 -m32
> -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c dumpdtime.ec rm
> -f dumpdtime.c gcc -std=gnu99 -DESQLC_VERSION=410 -m32 -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c -o dumpindent.o
> dumpindent.c INFORMIXC="gcc -std=gnu99" esql -DESQLC_VERSION=410 -m32
> -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c dumpintvl.ec rm
> -f dumpintvl.c INFORMIXC="gcc -std=gnu99" esql -DESQLC_VERSION=410
> -m32 -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c dumpsqlca.ec rm
> -f dumpsqlca.c INFORMIXC="gcc -std=gnu99" esql -DESQLC_VERSION=410
> -m32 -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c dumpsqlda.ec rm
> -f dumpsqlda.c INFORMIXC="gcc -std=gnu99" esql -DESQLC_VERSION=410
> -m32 -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c dumpvalue.ec rm
> -f dumpvalue.c gcc -std=gnu99 -DESQLC_VERSION=410 -m32 -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c -o efopen.o
> efopen.c gcc -std=gnu99 -DESQLC_VERSION=410 -m32 -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c -o emalloc.o
> emalloc.c gcc -std=gnu99 -DESQLC_VERSION=410 -m32 -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c -o epopen.o
> epopen.c gcc -std=gnu99 -DESQLC_VERSION=410 -m32 -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c -o errhelp.o
> errhelp.c gcc -std=gnu99 -DESQLC_VERSION=410 -m32 -I.
> -I/opt/informix/incl/esql -O -DHAVE_CONFIG_H -g -O2 -c -o esnprintf.o
> esnprintf.c
> esnprintf.c: In function 'internal_evsnprintf':
> esnprintf.c:29: error: #pragma GCC diagnostic not allowed inside
> functions
> esnprintf.c:30: error: #pragma GCC diagnostic not allowed inside
> functions
> esnprintf.c:32: error: #pragma GCC diagnostic not allowed inside
> functions
> make: *** [esnprintf.o] Error 1
> nova:/opt/informix/sqlcmd-90.00 #
>
> John David Adamski, Sr. Network Specialist Graceland University, 1
> Univeristy Place, Lamoni, IA 50140 adamski@graceland.edu
> 641-784-5267
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--
Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2015.1101 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused."

--001a114122426aee57054c0c42ff

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• installing sqlcmd
  John Adamski (Work Account) -- Friday, 31 March 2017, at 3:28 p.m.
  • Re: installing sqlcmd
    david@smooth1.co.uk -- Friday, 31 March 2017, at 3:37 p.m.
  • Re: installing sqlcmd
    Art Kagel -- Friday, 31 March 2017, at 3:45 p.m.
  • Re: installing sqlcmd
    Jonathan Leffler -- Friday, 31 March 2017, at 4:00 p.m.
    • RE: installing sqlcmd
      John Adamski (Work Account) -- Monday, 3 April 2017, at 9:13 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.