Re: [sqlite] SQLite4 version

2019-05-29 Thread Mario Bezzi
On top of https://sqlite.org/src4/doc/trunk/www/index.wiki, the statement "/All development work on SQLite has ended." /should hopefully be/ / /"///All development work on SQLite4 has ended."// :-) Thank you, mario// // On 5/29/19 3:17 PM, Simon Slavin wrote: On 29 May 2019, at 2:12pm,

Re: [sqlite] SQLite 3.21.0 for z/OS UNIX - installation issues

2019-01-08 Thread Mario Bezzi
script. Thanks again. mario On 1/4/19 10:51 PM, James K. Lowden wrote: On Fri, 4 Jan 2019 16:14:22 +0100 Mario Bezzi wrote: awk '($0  ~ /^CC = /) { $0 = "CC = xlc" } ($0  ~ /^CFLAGS = /) { $0 = "CFLAGS = -O2 -q32 -qfloat=ieee -qnolist" } ($0  ~ /^LDFLAGS = /) { $0 = &q

Re: [sqlite] SQLite 3.21.0 for z/OS UNIX - installation issues

2019-01-04 Thread Mario Bezzi
Hi, I am sorry, I can't help on the specific topic, maybe John is around and can chime in. But.. I have been working trying to allow SQLite to compile and work unchanged under z/OS USS. I think there is a bug in sqlite3.c which should be fixed. I've posted a message to the list a couple of

[sqlite] SQLite EBCDIC glitch?

2018-12-11 Thread Mario Bezzi
Hello, I have been working on making SQLite usable on IBM z/OS. Apart from a different compile process, I think there is a glitch in sqlite's management of EBCDIC which should be fixed. It is about newline character management. Below my analysis of the problem: - Routine local_getline in

[sqlite] SQLite 3.21 on IBM Mainframe - z/OS

2017-12-25 Thread Mario Bezzi
Hello, SQLite 3.21 autoconf (sqlite-autoconf-321.zip) compiles and runs successfully on z/OS 2.2 with few minor modifications which I would like the developers to consider for integration into the code base. Namely: 1 - In sqlite3.c, in the code section coming from tokenize.c, the

[sqlite] Cost of function call in a WHERE clause

2017-12-21 Thread Mario Bezzi
Hello, I would like to use a user defined scalar function in a where clause, something like: SELECT ColumnA, ColumnB, ColumnC FROM Table1 WHERE ColumnA = myfunct(X); X is constant.  I am concerned by the performance of such a query as I wonder if myfunct is called just once or once for

[sqlite] Function patternCompare() not EBCDIC friendly

2015-12-31 Thread mario bezzi
Roland, thank you VERY much for sharing your findings. Appreciated! I think that the ability to compile SQLite on z/OS out of the box is a great achievement. We'll need to make sure that this will still hold true for future releases. While using your dump procedure allows exchanging