Clive:

Huh. I actually just did a test build yesterday and all went well. I also just tried compiling dbmove using the command line you posted and that worked fine as well. Your versions of gcc and the engine don't look so old that it might cause an issue. OK, let's get the "dumb stuff" out of the way first. Post or email me the output from following:

ident dbmove.ec

esql -V

 If you don't have ident try this instead:

egrep 'Revision:|Header:|Date:' dbmove.ec

Also, I'm assuming you are on Linux. If that's not the case, let me know your platform.

Art

Clive:

Huh. I actually just did a test build yesterday and all went well. I also just tried compiling dbmove using the command line you posted and that worked fine as well. Your versions of gcc and the engine don't look so old that it might cause an issue. OK, let's get the "dumb stuff" out of the way first. Post or email me the output from following:

ident dbmove.ec

esql -V

 If you don't have ident try this instead:

egrep 'Revision:|Header:|Date:' dbmove.ec

Also, I'm assuming you are on Linux. If that's not the case, let me know your platform.

Art

Clive:

OK, so latest utils2_ak package, appropriate ESQL/C compiler. Can you email me the generated dbmove.c file? Maybe I'll see something there.

I assume everything else in the package built OK?

Art

Clive:

Huh. I actually just did a test build yesterday and all went well. I also just tried compiling dbmove using the command line you posted and that worked fine as well. Your versions of gcc and the engine don't look so old that it might cause an issue. OK, let's get the "dumb stuff" out of the way first. Post or email me the output from following:

ident dbmove.ec

esql -V

 If you don't have ident try this instead:

egrep 'Revision:|Header:|Date:' dbmove.ec

Also, I'm assuming you are on Linux. If that's not the case, let me know your platform.

Art

Clive:

OK, so latest utils2_ak package, appropriate ESQL/C compiler. Can you email me the generated dbmove.c file? Maybe I'll see something there.

I assume everything else in the package built OK?

Art

Clive:

Huh. I actually just did a test build yesterday and all went well. I also just tried compiling dbmove using the command line you posted and that worked fine as well. Your versions of gcc and the engine don't look so old that it might cause an issue. OK, let's get the "dumb stuff" out of the way first. Post or email me the output from following:

ident dbmove.ec

esql -V

 If you don't have ident try this instead:

egrep 'Revision:|Header:|Date:' dbmove.ec

Also, I'm assuming you are on Linux. If that's not the case, let me know your platform.

Art

Art,

I can confirm the build failure on Informix 12.10.FC16W2DE with CSDK
installed, just upgraded yesterday.
OS is Slackware 14.1 x86_64 with many upgrades, including gcc 4.9.4.
This system also uses glibc 2.17 so same as RHEL/CentOS 7.

informix$ esql -V
IBM Informix CSDK Version 4.10, IBM Informix-ESQL Version 4.10.FC16W2
Software Serial Number AAA#B000000

Downloaded the latest Utils2_AK package from:
https://www.askdbmgt.com/uploads/4/6/2/4/46246531/utils2_ak.zip

Unzip, cd into directory.

informix$ ident dbmove.ec
dbmove.ec:
     $Header: /home/art/GoogleDrive/Latest\040Art's\040Stuff/RCS/dbmove.ec,v 1.17 2025/02/18 12:12:12 art Exp $
     $Log: dbmove.ec,v $
     $Header: /home/art/GoogleDrive/Latest\040Art's\040Stuff/RCS/dbmove.ec,v 1.17 2025/02/18 12:12:12 art Exp $
     $RCSfile: dbmove.ec,v $
     $Revision: 1.17 $
     $Date: 2025/02/18 12:12:12 $
     $Revision: 1.17 $

informix$ make
...lots of stuff built OK, then dies with same error Clive got...
make[1]: Leaving directory `/data/tmp/ART2/myschema.d'
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbscript dbscript.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbsavail dbsavail.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbmove dbmove.ec getopt.c
esqlc: "dbmove.ec", line 419: Error -33051: Syntax error on identifier or symbol ';'.
1 error(s) found
make: *** [dbmove] Error 1

I have no dbmove.c, just dbmove.ec.
My version of dbmove.ec compares identical to the one Clive posted.

I am able to compile other esql/c simple demo programs on Informix
12.10 and they work OK.

---
On Informix 14.10.FC11W1DE with CSDK, 
also on Slackware 14.1 x86_64 with many upgrades, including gcc 4.9.4:

$ esql -V
IBM Informix CSDK Version 4.50, IBM Informix-ESQL Version 4.50.FC11W1

dbmove builds OK, and dbmove.c is created.

The build ends with:
make[1]: Leaving directory `/data/tmp/ART/myschema.d'
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbscript dbscript.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbsavail dbsavail.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbmove dbmove.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbping dbping.ec
rm bload 2>/dev/null
make: [bload] Error 1 (ignored)
ln ul bload
touch -h bload
rm bunload 2>/dev/null
make: [bunload] Error 1 (ignored)
ln ul bunload
touch -h bunload

but otherwise seems to have built OK.

Something to do with the CSDK version?

Clive:

OK, so latest utils2_ak package, appropriate ESQL/C compiler. Can you email me the generated dbmove.c file? Maybe I'll see something there.

I assume everything else in the package built OK?

Art

Clive:

Huh. I actually just did a test build yesterday and all went well. I also just tried compiling dbmove using the command line you posted and that worked fine as well. Your versions of gcc and the engine don't look so old that it might cause an issue. OK, let's get the "dumb stuff" out of the way first. Post or email me the output from following:

ident dbmove.ec

esql -V

 If you don't have ident try this instead:

egrep 'Revision:|Header:|Date:' dbmove.ec

Also, I'm assuming you are on Linux. If that's not the case, let me know your platform.

Art

Art,

After some experimentation I was able to get dbmove to build on Informix
12.10 with the following patch:

....................cut here....................
--- dbmove.ec.orig      2025-02-18 07:12:25.000000000 -0500
+++ dbmove.ec   2025-05-16 02:10:35.449279393 -0400
@@ -416,7 +416,7 @@
     commit_ok = (sqlca.sqlwarn.sqlwarn1 == 'W');
     begin_ok  = (commit_ok && sqlca.sqlwarn.sqlwarn2 != 'W');
 
-    EXEC SQL SELECT DBINFO( 'version', 'major' ) INTO :major_vers;
+    EXEC SQL SELECT DBINFO( 'version', 'major' ) INTO :major_vers FROM sysdual;
     if (sqlca.sqlcode < 0) {
        fprintf( stdout,
                 "Error determining source server version: %d, %d\n",
....................cut here....................

I'm not sure if sysdual is correct for your application but, when running
the SQL manually in dbaccess I had to specify a FROM clause to get it to work.

scot

Art,

I can confirm the build failure on Informix 12.10.FC16W2DE with CSDK
installed, just upgraded yesterday.
OS is Slackware 14.1 x86_64 with many upgrades, including gcc 4.9.4.
This system also uses glibc 2.17 so same as RHEL/CentOS 7.

informix$ esql -V
IBM Informix CSDK Version 4.10, IBM Informix-ESQL Version 4.10.FC16W2
Software Serial Number AAA#B000000

Downloaded the latest Utils2_AK package from:
https://www.askdbmgt.com/uploads/4/6/2/4/46246531/utils2_ak.zip

Unzip, cd into directory.

informix$ ident dbmove.ec
dbmove.ec:
     $Header: /home/art/GoogleDrive/Latest\040Art's\040Stuff/RCS/dbmove.ec,v 1.17 2025/02/18 12:12:12 art Exp $
     $Log: dbmove.ec,v $
     $Header: /home/art/GoogleDrive/Latest\040Art's\040Stuff/RCS/dbmove.ec,v 1.17 2025/02/18 12:12:12 art Exp $
     $RCSfile: dbmove.ec,v $
     $Revision: 1.17 $
     $Date: 2025/02/18 12:12:12 $
     $Revision: 1.17 $

informix$ make
...lots of stuff built OK, then dies with same error Clive got...
make[1]: Leaving directory `/data/tmp/ART2/myschema.d'
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbscript dbscript.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbsavail dbsavail.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbmove dbmove.ec getopt.c
esqlc: "dbmove.ec", line 419: Error -33051: Syntax error on identifier or symbol ';'.
1 error(s) found
make: *** [dbmove] Error 1

I have no dbmove.c, just dbmove.ec.
My version of dbmove.ec compares identical to the one Clive posted.

I am able to compile other esql/c simple demo programs on Informix
12.10 and they work OK.

---
On Informix 14.10.FC11W1DE with CSDK, 
also on Slackware 14.1 x86_64 with many upgrades, including gcc 4.9.4:

$ esql -V
IBM Informix CSDK Version 4.50, IBM Informix-ESQL Version 4.50.FC11W1

dbmove builds OK, and dbmove.c is created.

The build ends with:
make[1]: Leaving directory `/data/tmp/ART/myschema.d'
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbscript dbscript.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbsavail dbsavail.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbmove dbmove.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbping dbping.ec
rm bload 2>/dev/null
make: [bload] Error 1 (ignored)
ln ul bload
touch -h bload
rm bunload 2>/dev/null
make: [bunload] Error 1 (ignored)
ln ul bunload
touch -h bunload

but otherwise seems to have built OK.

Something to do with the CSDK version?

Clive:

OK, so latest utils2_ak package, appropriate ESQL/C compiler. Can you email me the generated dbmove.c file? Maybe I'll see something there.

I assume everything else in the package built OK?

Art

Clive:

Huh. I actually just did a test build yesterday and all went well. I also just tried compiling dbmove using the command line you posted and that worked fine as well. Your versions of gcc and the engine don't look so old that it might cause an issue. OK, let's get the "dumb stuff" out of the way first. Post or email me the output from following:

ident dbmove.ec

esql -V

 If you don't have ident try this instead:

egrep 'Revision:|Header:|Date:' dbmove.ec

Also, I'm assuming you are on Linux. If that's not the case, let me know your platform.

Art

Art,

After some experimentation I was able to get dbmove to build on Informix
12.10 with the following patch:

....................cut here....................
--- dbmove.ec.orig      2025-02-18 07:12:25.000000000 -0500
+++ dbmove.ec   2025-05-16 02:10:35.449279393 -0400
@@ -416,7 +416,7 @@
     commit_ok = (sqlca.sqlwarn.sqlwarn1 == 'W');
     begin_ok  = (commit_ok && sqlca.sqlwarn.sqlwarn2 != 'W');
 
-    EXEC SQL SELECT DBINFO( 'version', 'major' ) INTO :major_vers;
+    EXEC SQL SELECT DBINFO( 'version', 'major' ) INTO :major_vers FROM sysdual;
     if (sqlca.sqlcode < 0) {
        fprintf( stdout,
                 "Error determining source server version: %d, %d\n",
....................cut here....................

I'm not sure if sysdual is correct for your application but, when running
the SQL manually in dbaccess I had to specify a FROM clause to get it to work.

scot

Art,

I can confirm the build failure on Informix 12.10.FC16W2DE with CSDK
installed, just upgraded yesterday.
OS is Slackware 14.1 x86_64 with many upgrades, including gcc 4.9.4.
This system also uses glibc 2.17 so same as RHEL/CentOS 7.

informix$ esql -V
IBM Informix CSDK Version 4.10, IBM Informix-ESQL Version 4.10.FC16W2
Software Serial Number AAA#B000000

Downloaded the latest Utils2_AK package from:
https://www.askdbmgt.com/uploads/4/6/2/4/46246531/utils2_ak.zip

Unzip, cd into directory.

informix$ ident dbmove.ec
dbmove.ec:
     $Header: /home/art/GoogleDrive/Latest\040Art's\040Stuff/RCS/dbmove.ec,v 1.17 2025/02/18 12:12:12 art Exp $
     $Log: dbmove.ec,v $
     $Header: /home/art/GoogleDrive/Latest\040Art's\040Stuff/RCS/dbmove.ec,v 1.17 2025/02/18 12:12:12 art Exp $
     $RCSfile: dbmove.ec,v $
     $Revision: 1.17 $
     $Date: 2025/02/18 12:12:12 $
     $Revision: 1.17 $

informix$ make
...lots of stuff built OK, then dies with same error Clive got...
make[1]: Leaving directory `/data/tmp/ART2/myschema.d'
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbscript dbscript.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbsavail dbsavail.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbmove dbmove.ec getopt.c
esqlc: "dbmove.ec", line 419: Error -33051: Syntax error on identifier or symbol ';'.
1 error(s) found
make: *** [dbmove] Error 1

I have no dbmove.c, just dbmove.ec.
My version of dbmove.ec compares identical to the one Clive posted.

I am able to compile other esql/c simple demo programs on Informix
12.10 and they work OK.

---
On Informix 14.10.FC11W1DE with CSDK, 
also on Slackware 14.1 x86_64 with many upgrades, including gcc 4.9.4:

$ esql -V
IBM Informix CSDK Version 4.50, IBM Informix-ESQL Version 4.50.FC11W1

dbmove builds OK, and dbmove.c is created.

The build ends with:
make[1]: Leaving directory `/data/tmp/ART/myschema.d'
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbscript dbscript.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbsavail dbsavail.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbmove dbmove.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbping dbping.ec
rm bload 2>/dev/null
make: [bload] Error 1 (ignored)
ln ul bload
touch -h bload
rm bunload 2>/dev/null
make: [bunload] Error 1 (ignored)
ln ul bunload
touch -h bunload

but otherwise seems to have built OK.

Something to do with the CSDK version?

Clive:

OK, so latest utils2_ak package, appropriate ESQL/C compiler. Can you email me the generated dbmove.c file? Maybe I'll see something there.

I assume everything else in the package built OK?

Art

Clive:

Huh. I actually just did a test build yesterday and all went well. I also just tried compiling dbmove using the command line you posted and that worked fine as well. Your versions of gcc and the engine don't look so old that it might cause an issue. OK, let's get the "dumb stuff" out of the way first. Post or email me the output from following:

ident dbmove.ec

esql -V

 If you don't have ident try this instead:

egrep 'Revision:|Header:|Date:' dbmove.ec

Also, I'm assuming you are on Linux. If that's not the case, let me know your platform.

Art

Art,

After some experimentation I was able to get dbmove to build on Informix
12.10 with the following patch:

....................cut here....................
--- dbmove.ec.orig      2025-02-18 07:12:25.000000000 -0500
+++ dbmove.ec   2025-05-16 02:10:35.449279393 -0400
@@ -416,7 +416,7 @@
     commit_ok = (sqlca.sqlwarn.sqlwarn1 == 'W');
     begin_ok  = (commit_ok && sqlca.sqlwarn.sqlwarn2 != 'W');
 
-    EXEC SQL SELECT DBINFO( 'version', 'major' ) INTO :major_vers;
+    EXEC SQL SELECT DBINFO( 'version', 'major' ) INTO :major_vers FROM sysdual;
     if (sqlca.sqlcode < 0) {
        fprintf( stdout,
                 "Error determining source server version: %d, %d\n",
....................cut here....................

I'm not sure if sysdual is correct for your application but, when running
the SQL manually in dbaccess I had to specify a FROM clause to get it to work.

scot

Art,

I can confirm the build failure on Informix 12.10.FC16W2DE with CSDK
installed, just upgraded yesterday.
OS is Slackware 14.1 x86_64 with many upgrades, including gcc 4.9.4.
This system also uses glibc 2.17 so same as RHEL/CentOS 7.

informix$ esql -V
IBM Informix CSDK Version 4.10, IBM Informix-ESQL Version 4.10.FC16W2
Software Serial Number AAA#B000000

Downloaded the latest Utils2_AK package from:
https://www.askdbmgt.com/uploads/4/6/2/4/46246531/utils2_ak.zip

Unzip, cd into directory.

informix$ ident dbmove.ec
dbmove.ec:
     $Header: /home/art/GoogleDrive/Latest\040Art's\040Stuff/RCS/dbmove.ec,v 1.17 2025/02/18 12:12:12 art Exp $
     $Log: dbmove.ec,v $
     $Header: /home/art/GoogleDrive/Latest\040Art's\040Stuff/RCS/dbmove.ec,v 1.17 2025/02/18 12:12:12 art Exp $
     $RCSfile: dbmove.ec,v $
     $Revision: 1.17 $
     $Date: 2025/02/18 12:12:12 $
     $Revision: 1.17 $

informix$ make
...lots of stuff built OK, then dies with same error Clive got...
make[1]: Leaving directory `/data/tmp/ART2/myschema.d'
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbscript dbscript.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbsavail dbsavail.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbmove dbmove.ec getopt.c
esqlc: "dbmove.ec", line 419: Error -33051: Syntax error on identifier or symbol ';'.
1 error(s) found
make: *** [dbmove] Error 1

I have no dbmove.c, just dbmove.ec.
My version of dbmove.ec compares identical to the one Clive posted.

I am able to compile other esql/c simple demo programs on Informix
12.10 and they work OK.

---
On Informix 14.10.FC11W1DE with CSDK, 
also on Slackware 14.1 x86_64 with many upgrades, including gcc 4.9.4:

$ esql -V
IBM Informix CSDK Version 4.50, IBM Informix-ESQL Version 4.50.FC11W1

dbmove builds OK, and dbmove.c is created.

The build ends with:
make[1]: Leaving directory `/data/tmp/ART/myschema.d'
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbscript dbscript.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbsavail dbsavail.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbmove dbmove.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbping dbping.ec
rm bload 2>/dev/null
make: [bload] Error 1 (ignored)
ln ul bload
touch -h bload
rm bunload 2>/dev/null
make: [bunload] Error 1 (ignored)
ln ul bunload
touch -h bunload

but otherwise seems to have built OK.

Something to do with the CSDK version?

Clive:

OK, so latest utils2_ak package, appropriate ESQL/C compiler. Can you email me the generated dbmove.c file? Maybe I'll see something there.

I assume everything else in the package built OK?

Art

Clive:

Huh. I actually just did a test build yesterday and all went well. I also just tried compiling dbmove using the command line you posted and that worked fine as well. Your versions of gcc and the engine don't look so old that it might cause an issue. OK, let's get the "dumb stuff" out of the way first. Post or email me the output from following:

ident dbmove.ec

esql -V

 If you don't have ident try this instead:

egrep 'Revision:|Header:|Date:' dbmove.ec

Also, I'm assuming you are on Linux. If that's not the case, let me know your platform.

Art

Art,

After some experimentation I was able to get dbmove to build on Informix
12.10 with the following patch:

....................cut here....................
--- dbmove.ec.orig      2025-02-18 07:12:25.000000000 -0500
+++ dbmove.ec   2025-05-16 02:10:35.449279393 -0400
@@ -416,7 +416,7 @@
     commit_ok = (sqlca.sqlwarn.sqlwarn1 == 'W');
     begin_ok  = (commit_ok && sqlca.sqlwarn.sqlwarn2 != 'W');
 
-    EXEC SQL SELECT DBINFO( 'version', 'major' ) INTO :major_vers;
+    EXEC SQL SELECT DBINFO( 'version', 'major' ) INTO :major_vers FROM sysdual;
     if (sqlca.sqlcode < 0) {
        fprintf( stdout,
                 "Error determining source server version: %d, %d\n",
....................cut here....................

I'm not sure if sysdual is correct for your application but, when running
the SQL manually in dbaccess I had to specify a FROM clause to get it to work.

scot

Art,

I can confirm the build failure on Informix 12.10.FC16W2DE with CSDK
installed, just upgraded yesterday.
OS is Slackware 14.1 x86_64 with many upgrades, including gcc 4.9.4.
This system also uses glibc 2.17 so same as RHEL/CentOS 7.

informix$ esql -V
IBM Informix CSDK Version 4.10, IBM Informix-ESQL Version 4.10.FC16W2
Software Serial Number AAA#B000000

Downloaded the latest Utils2_AK package from:
https://www.askdbmgt.com/uploads/4/6/2/4/46246531/utils2_ak.zip

Unzip, cd into directory.

informix$ ident dbmove.ec
dbmove.ec:
     $Header: /home/art/GoogleDrive/Latest\040Art's\040Stuff/RCS/dbmove.ec,v 1.17 2025/02/18 12:12:12 art Exp $
     $Log: dbmove.ec,v $
     $Header: /home/art/GoogleDrive/Latest\040Art's\040Stuff/RCS/dbmove.ec,v 1.17 2025/02/18 12:12:12 art Exp $
     $RCSfile: dbmove.ec,v $
     $Revision: 1.17 $
     $Date: 2025/02/18 12:12:12 $
     $Revision: 1.17 $

informix$ make
...lots of stuff built OK, then dies with same error Clive got...
make[1]: Leaving directory `/data/tmp/ART2/myschema.d'
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbscript dbscript.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbsavail dbsavail.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbmove dbmove.ec getopt.c
esqlc: "dbmove.ec", line 419: Error -33051: Syntax error on identifier or symbol ';'.
1 error(s) found
make: *** [dbmove] Error 1

I have no dbmove.c, just dbmove.ec.
My version of dbmove.ec compares identical to the one Clive posted.

I am able to compile other esql/c simple demo programs on Informix
12.10 and they work OK.

---
On Informix 14.10.FC11W1DE with CSDK, 
also on Slackware 14.1 x86_64 with many upgrades, including gcc 4.9.4:

$ esql -V
IBM Informix CSDK Version 4.50, IBM Informix-ESQL Version 4.50.FC11W1

dbmove builds OK, and dbmove.c is created.

The build ends with:
make[1]: Leaving directory `/data/tmp/ART/myschema.d'
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbscript dbscript.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbsavail dbsavail.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbmove dbmove.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbping dbping.ec
rm bload 2>/dev/null
make: [bload] Error 1 (ignored)
ln ul bload
touch -h bload
rm bunload 2>/dev/null
make: [bunload] Error 1 (ignored)
ln ul bunload
touch -h bunload

but otherwise seems to have built OK.

Something to do with the CSDK version?

Clive:

OK, so latest utils2_ak package, appropriate ESQL/C compiler. Can you email me the generated dbmove.c file? Maybe I'll see something there.

I assume everything else in the package built OK?

Art

Clive:

Huh. I actually just did a test build yesterday and all went well. I also just tried compiling dbmove using the command line you posted and that worked fine as well. Your versions of gcc and the engine don't look so old that it might cause an issue. OK, let's get the "dumb stuff" out of the way first. Post or email me the output from following:

ident dbmove.ec

esql -V

 If you don't have ident try this instead:

egrep 'Revision:|Header:|Date:' dbmove.ec

Also, I'm assuming you are on Linux. If that's not the case, let me know your platform.

Art

Scot, Clive:

YES! Constant queries with no FROM clause is first supported in CSDK 4.50!!!! 

OK, I will apply that patch and post an update! I'll post here once it's online.

Thanks for figuring this out for me!!!

Art

Art,

After some experimentation I was able to get dbmove to build on Informix
12.10 with the following patch:

....................cut here....................
--- dbmove.ec.orig      2025-02-18 07:12:25.000000000 -0500
+++ dbmove.ec   2025-05-16 02:10:35.449279393 -0400
@@ -416,7 +416,7 @@
     commit_ok = (sqlca.sqlwarn.sqlwarn1 == 'W');
     begin_ok  = (commit_ok && sqlca.sqlwarn.sqlwarn2 != 'W');
 
-    EXEC SQL SELECT DBINFO( 'version', 'major' ) INTO :major_vers;
+    EXEC SQL SELECT DBINFO( 'version', 'major' ) INTO :major_vers FROM sysdual;
     if (sqlca.sqlcode < 0) {
        fprintf( stdout,
                 "Error determining source server version: %d, %d\n",
....................cut here....................

I'm not sure if sysdual is correct for your application but, when running
the SQL manually in dbaccess I had to specify a FROM clause to get it to work.

scot

Art,

I can confirm the build failure on Informix 12.10.FC16W2DE with CSDK
installed, just upgraded yesterday.
OS is Slackware 14.1 x86_64 with many upgrades, including gcc 4.9.4.
This system also uses glibc 2.17 so same as RHEL/CentOS 7.

informix$ esql -V
IBM Informix CSDK Version 4.10, IBM Informix-ESQL Version 4.10.FC16W2
Software Serial Number AAA#B000000

Downloaded the latest Utils2_AK package from:
https://www.askdbmgt.com/uploads/4/6/2/4/46246531/utils2_ak.zip

Unzip, cd into directory.

informix$ ident dbmove.ec
dbmove.ec:
     $Header: /home/art/GoogleDrive/Latest\040Art's\040Stuff/RCS/dbmove.ec,v 1.17 2025/02/18 12:12:12 art Exp $
     $Log: dbmove.ec,v $
     $Header: /home/art/GoogleDrive/Latest\040Art's\040Stuff/RCS/dbmove.ec,v 1.17 2025/02/18 12:12:12 art Exp $
     $RCSfile: dbmove.ec,v $
     $Revision: 1.17 $
     $Date: 2025/02/18 12:12:12 $
     $Revision: 1.17 $

informix$ make
...lots of stuff built OK, then dies with same error Clive got...
make[1]: Leaving directory `/data/tmp/ART2/myschema.d'
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbscript dbscript.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbsavail dbsavail.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbmove dbmove.ec getopt.c
esqlc: "dbmove.ec", line 419: Error -33051: Syntax error on identifier or symbol ';'.
1 error(s) found
make: *** [dbmove] Error 1

I have no dbmove.c, just dbmove.ec.
My version of dbmove.ec compares identical to the one Clive posted.

I am able to compile other esql/c simple demo programs on Informix
12.10 and they work OK.

---
On Informix 14.10.FC11W1DE with CSDK, 
also on Slackware 14.1 x86_64 with many upgrades, including gcc 4.9.4:

$ esql -V
IBM Informix CSDK Version 4.50, IBM Informix-ESQL Version 4.50.FC11W1

dbmove builds OK, and dbmove.c is created.

The build ends with:
make[1]: Leaving directory `/data/tmp/ART/myschema.d'
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbscript dbscript.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbsavail dbsavail.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbmove dbmove.ec getopt.c
INFORMIXC=gcc              esql  -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1   -o dbping dbping.ec
rm bload 2>/dev/null
make: [bload] Error 1 (ignored)
ln ul bload
touch -h bload
rm bunload 2>/dev/null
make: [bunload] Error 1 (ignored)
ln ul bunload
touch -h bunload

but otherwise seems to have built OK.

Something to do with the CSDK version?

Clive:

OK, so latest utils2_ak package, appropriate ESQL/C compiler. Can you email me the generated dbmove.c file? Maybe I'll see something there.

I assume everything else in the package built OK?

Art

Clive:

Huh. I actually just did a test build yesterday and all went well. I also just tried compiling dbmove using the command line you posted and that worked fine as well. Your versions of gcc and the engine don't look so old that it might cause an issue. OK, let's get the "dumb stuff" out of the way first. Post or email me the output from following:

ident dbmove.ec

esql -V

 If you don't have ident try this instead:

egrep 'Revision:|Header:|Date:' dbmove.ec

Also, I'm assuming you are on Linux. If that's not the case, let me know your platform.

Art