E_R=1 \
> -DHAVE_DECL_STRERROR_R=1 \
> -DHAVE_STRERROR_R=1 \
> -D_REENTRANT=1 \
> -DSQLITE_THREADSAFE=1 \
> -DSQLITE_ENABLE_FTS3 \
> -DSQLITE_ENABLE_RTREE \
> -O3 \
> -I. -V \
> -DSQLITE_OMIT_MERGE_SORT \
> -DSQLITE_MAX_MMAPSIZE=1048576 \
> -qTARG=zOSV1R11 \
> -q
Roland,
Congrads on getting something to work with sqlite and z/OS. ?How did you
resolve the file I/O issues, or did you have any. ?I figured sqlite should be
able to run on z/OS a few years back due to the portable nature of the code I
saw. ? But the?mainframe guys who supposedly knew, told
t;
> -Original Message-
> From: drhsqlite at gmail.com [mailto:drhsqlite at gmail.com] On Behalf Of
> Richard Hipp
> Sent: Wednesday, December 30, 2015 9:08 AM
> To: SQLite mailing list
> Cc: rolandsmartin at gmail.com
> Subject: Re: [sqlite] Function patternCompar
X_C_SOURCE=200112L \
-D_XOPEN_SOURCE=600 \
-c \
-o shell.o shell.c
Linking the two together for a sqlite3 executable:
xlc -q64 -o sqlite3 shell.o sqlite3.o
Hope this helps - Roland
-----Original Message-
From: mbezzi [mailto:mbe...@tiscali.it]
Sent: Wednesday, December 30, 2015 11:21 AM
To: SQLite ma
On Wed, Dec 30, 2015 at 9:55 AM, Roland Martin
wrote:
> I have tested the code change on z/OS and it works.
>
?Any chance that I could beg the source and executable code from you?
>
> Thanks for the quick turnaround!
>
> Roland Martin
>
>
--
Computer Science is the only discipline in which
at gmail.com
Subject: Re: [sqlite] Function patternCompare() not EBCDIC friendly
On 12/30/15, Roland Martin wrote:
> Working with version 3.9.2 on IBM z/OS case insensitive LIKE queries
> do not work if case does not match.
Please test and let us know if the
https://www.sqlite.org/sr
On 12/30/15, Roland Martin wrote:
> Working with version 3.9.2 on IBM z/OS case insensitive LIKE queries do not
> work if case does not match.
Please test and let us know if the
https://www.sqlite.org/src/info/0a99a8c4facf65ec check-in fixes your
problem.
--
D. Richard Hipp
drh at sqlite.org
Working with version 3.9.2 on IBM z/OS case insensitive LIKE queries do not
work if case does not match. The following #if defined(SQLITE_EBCDIC) is
important:
/*
** For LIKE and GLOB matching on EBCDIC machines, assume that every
** character is exactly one byte in size. Also, provde the
8 matches
Mail list logo