On Wed, Sep 24, 2014 at 9:46 PM, Richard Hipp <d...@sqlite.org> wrote: > Please try the latest version of SQLite on trunk to see if that works > better. Specifically, apply the patch at > > http://www.sqlite.org/src/vpatch?from=b2c89ef49cd1&to=ef30e0352b3d > > -- > D. Richard Hipp > d...@sqlite.org
Dr. Hipp, I did the port of SQLite to z/OS mentioned by the OP. Sorry it took me so long to test the above fix out. I downloaded the latest 3.8.7 amalgamation source and applied that patch to it (actually I looked at what it did and hand edited the files myself). This did indeed fix the compile problem. I hope to be able to do some testing and get your excellent code available to other z/OS users as soon as possible. I don't really have a date in mind. I will also mention that the z/OS xlc compiler has a "problem" with the ./configure script. On z/OS 2.1, the script detects that the fpurge() function exists. But this function did not exist in earlier versions of z/OS. So if, like me, you want to target a prior release (like targeting a lower level kernel that the one you're running on), ./configure sets the HAVE_POSIX_FALLOCATE and so the code precompiles to use fpurge(), but the compiler itself complains that the code is invalid, due to targeting the back level z/OS versions. I have found an easy work around. I simply put the phrase "-DHAVE_POSIX_FALLOCATE=0" in the CFLAGS used by ./configure. This allows a clean compile which does _not_ use the fpurge(). Again my thanks for your excellent work. I did not really have to do _anything_, code wise, to get your program to run on z/OS in an EBCDIC environment. Unfortunately, the ASCII vs. EBCDIC issued _does_ make it impossible to share a single SQLite data base file between z/OS and other ASCII-based SQLite systems. I haven't looked closely enough at the code to see if the big-endian (z/OS) vs. little-endian (Intel) storage of integers would also be a problem. -- The temperature of the aqueous content of an unremittingly ogled culinary vessel will not achieve 100 degrees on the Celsius scale. Maranatha! <>< John McKown _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
