sqlcmd

Hello I have Dec/alpha UNIX OSF1 V 4.0 alpha, Informix Dynamic Server 7.31 and CSDK 2.40. I have a problem in compiling sqlcmd-57 utility: I compile the software using the following commands (with output): compile loading cache ./config.cache checking for gawk... (cached) gawk checking for gcc... (cached) cc checking whether the C compiler (cc ) works... yes checking whether the C compiler (cc ) is a cross-compiler... no checking whether we are using GNU C... (cached) no checking whether cc accepts -g... (cached) yes checking for a BSD compatible install... ./install-sh -c checking whether ln -s works... (cached) yes checking for ranlib... (cached) ranlib checking for bison... no checking for byacc... no checking how to run the C preprocessor... (cached) cc -E checking for ANSI C header files... (cached) yes checking for limits.h... (cached) yes checking for sys/time.h... (cached) yes checking for unistd.h... (cached) yes checking for search.h... (cached) yes checking for working const... (cached) yes checking return type of signal handlers... (cached) void checking for size_t... (cached) yes checking whether time.h and sys/time.h may both be included... (cached) yes checking whether struct tm is in sys/time.h or time.h... (cached) time.h checking for strftime... (cached) yes checking for vprintf... (cached) yes checking for strdup... (cached) yes checking for strerror... (cached) yes checking for strtod... (cached) yes checking for strtol... (cached) yes checking for memmove... (cached) yes checking for lfind... (cached) yes checking for sleep... (cached) yes checking for isatty... (cached) yes checking for mkfifo... (cached) yes checking for tgoto in -lcurses... (cached) yes checking for readline in -lreadline... (cached) no checking for /dev/stdin, /dev/stdout, /dev/stderr... (cached) no checking for INFORMIXDIR... /clivet/users/informix checking for ESQL/C compiler and version... esql (version 930) checking ESQL/C Features... esqlinfo.h unchanged checking for ESQL/C header directory... /clivet/users/informix/incl/esql checking for ESQL/C varchar.h header... yes checking host system type... alpha-dec-osf4.0f checking target system type... alpha-dec-osf4.0f checking build system type... alpha-dec-osf4.0f checking for loc_t problems on AIX... no, thank goodness! checking for working const... (cached) yes checking for fine-resolution timing checking for clock_gettime... (cached) no checking for gettimeofday... (cached) yes Fine-resolution timing will use Unix-98 gettimeofday() creating ./config.status creating Makefile creating sqlcmd.ins creating config.h config.h is unchanged make cc -DESQLC_VERSION=930 -I. -I/clivet/users/informix/incl/esql -O2 - DHAVE_CONFc cc -DESQLC_VERSION=930 -I. -I/clivet/users/informix/incl/esql -O2 - DHAVE_CONFc cc -DESQLC_VERSION=930 -I. -I/clivet/users/informix/incl/esql -O2 - DHAVE_CONFc cc -DESQLC_VERSION=930 -I. -I/clivet/users/informix/incl/esql -O2 - DHAVE_CONFc cc -DESQLC_VERSION=930 -I. -I/clivet/users/informix/incl/esql -O2 - DHAVE_CONFc cc -DESQLC_VERSION=930 -I. -I/clivet/users/informix/incl/esql -O2 - DHAVE_CONFc cc -DESQLC_VERSION=930 -I. -I/clivet/users/informix/incl/esql -O2 - DHAVE_CONFc cc -DESQLC_VERSION=930 -I. -I/clivet/users/informix/incl/esql -O2 - DHAVE_CONFc cc -DESQLC_VERSION=930 -I. -I/clivet/users/informix/incl/esql -O2 - DHAVE_CONFc INFORMIXC="cc" esql -DESQLC_VERSION=930 -I. -I/clivet/users/informix/incl/esqc rm -f describe.c INFORMIXC="cc" esql -DESQLC_VERSION=930 -I. -I/clivet/users/informix/incl/esqc rm -f dumpblob.c INFORMIXC="cc" esql -DESQLC_VERSION=930 -I. -I/clivet/users/informix/incl/esqc rm -f dumpdec.c INFORMIXC="cc" esql -DESQLC_VERSION=930 -I. -I/clivet/users/informix/incl/esqc rm -f dumpdtime.c INFORMIXC="cc" esql -DESQLC_VERSION=930 -I. -I/clivet/users/informix/incl/esqc rm -f dumpintvl.c INFORMIXC="cc" esql -DESQLC_VERSION=930 -I. -I/clivet/users/informix/incl/esqc cc: Warning: dumpsqlca.ec, line 62: In this statement, the referenced type of t) lptr = &psqlca->sqlerrd[0]; --------^ rm -f dumpsqlca.c INFORMIXC="cc" esql -DESQLC_VERSION=930 -I. -I/clivet/users/informix/incl/esqc rm -f dumpsqlda.c INFORMIXC="cc" esql -DESQLC_VERSION=930 -I. -I/clivet/users/informix/incl/esqc rm -f dumpvalue.c cc -DESQLC_VERSION=930 -I. -I/clivet/users/informix/incl/esql -O2 - DHAVE_CONFc cc -DESQLC_VERSION=930 -I. -I/clivet/users/informix/incl/esql -O2 - DHAVE_CONFc INFORMIXC="cc" esql -DESQLC_VERSION=930 -I. -I/clivet/users/informix/incl/esqc rm -f esqlcver.c cc -DESQLC_VERSION=930 -I. -I/clivet/users/informix/incl/esql -O2 - DHAVE_CONFc cc -DESQLC_VERSION=930 -I. -I/clivet/users/informix/incl/esql -O2 - DHAVE_CONFc cc -DESQLC_VERSION=930 -I. -I/clivet/users/informix/incl/esql -O2 - DHAVE_CONFc cc -DESQLC_VERSION=930 -I. -I/clivet/users/informix/incl/esql -O2 - DHAVE_CONFc cc -DESQLC_VERSION=930 -I. -I/clivet/users/informix/incl/esql -O2 - DHAVE_CONFc INFORMIXC="cc" esql -DESQLC_VERSION=930 -I. -I/clivet/users/informix/incl/esqc cc: Error: ixblob.ec, line 85: In this statement, "mktemp(...)" and "(char ...)) if (mktemp(tmp) == (char *)0) ------------^ *** Exit 1 Stop. I have tried with sqlcmd-52A and the compilation (command: make) executes succesfully (only warnings) but the installation (command: make install) terminates with: ls -il histdump mkproc sqlclean sqlclient sqlcmd sqlreload sqlserver newsl 9185 -rwxrwxrwx 1 informix system 57344 Dec 7 14:19 histdump 9186 -rwxrwxrwx 1 informix system 49152 Dec 7 14:19 mkproc 9197 -r-xr-xr-x 1 informix system 213 Dec 7 14:20 newserver 9188 -r-xr-xr-x 1 informix system 2556 Dec 7 14:19 sqlclean 9191 -r-xr-xr-x 1 informix system 711 Dec 7 14:19 sqlclient 9196 -rwxrwxrwx 3 informix system 212992 Dec 7 14:20 sqlcmd 9196 -rwxrwxrwx 3 informix system 212992 Dec 7 14:20 sqlreload 9194 -r-xr-xr-x 1 informix system 673 Dec 7 14:20 sqlserver 9196 -rwxrwxrwx 3 informix system 212992 Dec 7 14:20 sqlunload 8571 -rwxrwxrwx 1 informix system 172032 Dec 7 14:20 sqlupload 8572 -rwxrwxrwx 1 informix system 49152 Dec 7 14:20 updblob LOCK: -d /clivet/users/informix/bin || mkdir /clivet/users/informix/bin sh: syntax error at line 1 : `*** Exit 2 Stop. Anyway the executable files are created, but when I execute command sqlunload on big table those errors occur: Unaligned access pid=6464 <sqlunload> va=0x14001a184 pc=0x1200170f4 ra=0x1200170 10411000727928|3905524963251063160|C6360180|1.111|C6360180|0.001|1| Unaligned access pid=6464 <sqlunload> va=0x14001a184 pc=0x1200170f4 ra=0x1200170 3451637582573635|3905524963251864383|C6360180|2.222|C6360180|0.001|1| Unaligned access pid=6464 <sqlunload> va=0x14001a184 pc=0x1200170f4 ra=0x1200170 644253684372072|3905549221226498546|SL360147|1.000|SL360147|2.000|1| and the unload file is not correct.

eonder@my-deja.com wrote: > I have Dec/alpha UNIX OSF1 V 4.0 alpha, Informix Dynamic Server 7.31 > and CSDK 2.40. > I have a problem in compiling sqlcmd-57 utility: I guess I'm going to need to answer this...it's my problem. The other problem I have will be getting access to a suitable DEC machine for testing. I think I'm missing some information from the compilation warnings. > I compile the software using the following commands (with output): > compile > loading cache ./config.cache > checking for gawk... (cached) gawk >[...] > INFORMIXC="cc" esql -DESQLC_VERSION=930 -I. -> I/clivet/users/informix/incl/esqc > cc: Warning: dumpsqlca.ec, line 62: In this statement, the referenced > type of t) > lptr = &psqlca->sqlerrd[0]; > --------^ > rm -f dumpsqlca.c >[...] > INFORMIXC="cc" esql -DESQLC_VERSION=930 -I. -> I/clivet/users/informix/incl/esqc > cc: Error: ixblob.ec, line 85: In this statement, "mktemp(...)" > and "(char ...)) > if (mktemp(tmp) == (char *)0) > ------------^ > *** Exit 1 > Stop. Please can you send the complete error messages; it looks to me like things are being truncated on the right after about 80 characters... > I have tried with sqlcmd-52A and the compilation (command: make) > executes succesfully (only warnings) but the installation (command: > make install) terminates with: > ls -il histdump mkproc sqlclean sqlclient sqlcmd sqlreload > sqlserver newsl > 9185 -rwxrwxrwx 1 informix system 57344 Dec 7 14:19 histdump > 9186 -rwxrwxrwx 1 informix system 49152 Dec 7 14:19 mkproc > 9197 -r-xr-xr-x 1 informix system 213 Dec 7 14:20 newserver > 9188 -r-xr-xr-x 1 informix system 2556 Dec 7 14:19 sqlclean > 9191 -r-xr-xr-x 1 informix system 711 Dec 7 14:19 sqlclient > 9196 -rwxrwxrwx 3 informix system 212992 Dec 7 14:20 sqlcmd > 9196 -rwxrwxrwx 3 informix system 212992 Dec 7 14:20 sqlreload > 9194 -r-xr-xr-x 1 informix system 673 Dec 7 14:20 sqlserver > 9196 -rwxrwxrwx 3 informix system 212992 Dec 7 14:20 sqlunload > 8571 -rwxrwxrwx 1 informix system 172032 Dec 7 14:20 sqlupload > 8572 -rwxrwxrwx 1 informix system 49152 Dec 7 14:20 updblob > LOCK: -d /clivet/users/informix/bin > || mkdir /clivet/users/informix/bin > sh: syntax error at line 1 : `*** Exit 2 > Stop. That's probably a straight bug in the code. I'll need to see what is happening, but the -d suggests it is meant to be a test operation (and I probably need to use 'test' in place of '['). > Anyway the executable files are created, but when I execute command > sqlunload on big table those errors occur: > Unaligned access pid=6464 <sqlunload> va=0x14001a184 pc=0x1200170f4 > ra=0x1200170 > 10411000727928|3905524963251063160|C6360180|1.111|C6360180|0.001|1| > Unaligned access pid=6464 <sqlunload> va=0x14001a184 pc=0x1200170f4 > ra=0x1200170 > 3451637582573635|3905524963251864383|C6360180|2.222|C6360180|0.001|1| > Unaligned access pid=6464 <sqlunload> va=0x14001a184 pc=0x1200170f4 > ra=0x1200170 > 644253684372072|3905549221226498546|SL360147|1.000|SL360147|2.000|1| I think unaligned accesses are mainly warnings, but they are severe performance hits too (it takes time to print all that information out). I would be greatly helped by having the schema for the table which causes this trouble, and a few rows of sample data that shows the unaligned access messages. Then, maybe, I can track it down. > and the unload file is not correct. In what sense? > Can anyone help me in this matter? Please Unless there's someone out there who's done the donkey work to fix it on DEC Alpha, I think you're stuck with just me. I do have a bug report from someone about DEC Alpha problems, but not this problem. -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"