File #965 on the http://cbttape.org/updates.htm page is now available. I did the "port" (basically just a compile since Dr. Hipp already had EBCDIC support in the source code). I downloaded the zip file; unzipped it; then did a TSO RECEIVE to verify that it worked on my z/OS system. In my, very _minor_, testing, I had no problems.
The straight scoop on the system is at http://www.sqlite.org . Dr. Hipp has written some really GOOD code and very generously donated it to the Public Domain. So, yes, you can use it on your system. You can embedded it in your application. You can distribute your binary (compiled) application. And all of this with no worries about any kind of license or requirement to "open up" you own, possibly proprietary, source code. For those unaware of this, SQLite3 is an _embedded_ SQL engine. That is, there is no "started task" or "UNIX daemon" doing the work. It just a _really large_ C subroutine library which does its own I/O to it own UNIX file structure. Yes, I said "UNIX file structure". Actually it is in a single _UNIX_ file. No, I don't really have any plans to try to make it use a "normal" legacy data set such as PS, ESDS, or LDS. The SQL language in SQLite3 is fairly close to the ANSI standard. But one very large "lack" is that the system does not enforce any kind of "type consistency". Basically the data is stored as you present it to SQLite3 without verification against the schema. For example, a program can store a character string into a field declared as an integer and the character string will be accepted. There is no _formal_ support included with this. I will accept an email telling me about any problems. If they are in my code, I will try to fix it (no promises!). If they are in the SQLite3 code, then I will report that on the sqlite3 development forum. Again, no promises, but Dr. Hipp has usually responded with either a fix or an explanation of why it is not a "bug". Such as storing a string value, like "AxCD" in an INT column is not a bug. Of course, once Dr. Hipp has a solution, it will take me time to implement it and get the update onto the CBTtape.org site. In regards to the above about support and possible delays. If you're really "hot" on something, you need to understand how to get the most current version from Dr. Hipp's "fossil repository" and how to use it to create the files in the "amalgamation" distribution. This is well beyond what I plan to document here. Perhaps I'll make a "HOWTO" in the future to help. But once you have the "amalgamation" distribution file, the COMPILE member should allow you to update your version. You will need to read from the web site about how to do this. Try: http://www.sqlite.org/amalgamation.html -- I have a theory that it's impossible to prove anything, but I can't prove it. Maranatha! <>< John McKown ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
