Re: [sqlite] sqlite on IBM z/OS Unix

2018-08-30 Thread Don V Nielsen
This is what I was trying to remember. It is for calling LE Cobol, but it demonstrates the use of the CEEENTRY and CEETERM macro that are used to establish the environment without having to use a LE C stub program. I used to use the Cobol stub method in the past. https://www.ibm.com/support/knowle

[sqlite] sqlite on IBM z/OS Unix

2018-08-30 Thread David Jackson
Thanks for the various replies to this question. I have my link working now. It starts off wit a basic 3 line c program (to establish the LE enclave) that then calls an Asm program that passes the SQL that then loads and branches to a c program to do the grunt work. There is an example IBM program

Re: [sqlite] sqlite on IBM z/OS Unix

2018-08-30 Thread John McKown
On Thu, Aug 30, 2018 at 11:12 AM Don V Nielsen wrote: > "Having successfully ported sqlite to z/OS Unix as a 32 bit app" > > Totally Awesome! Do I have a solution? No. But I'll bet John McKown will. I > believe he is a guru with the mainframe. > I don't know about being a "guru". Personally, all

Re: [sqlite] sqlite on IBM z/OS Unix

2018-08-30 Thread Don V Nielsen
"Having successfully ported sqlite to z/OS Unix as a 32 bit app" Totally Awesome! Do I have a solution? No. But I'll bet John McKown will. I believe he is a guru with the mainframe. It is not SqlLite. It is that communication mechanism between the non-LE program calling into the LE environment. A

Re: [sqlite] sqlite on IBM z/OS Unix

2018-08-29 Thread Keith Medcalf
linglists.sqlite.org] On Behalf Of David Jackson >Sent: Wednesday, 29 August, 2018 16:26 >To: sqlite-users@mailinglists.sqlite.org >Subject: [sqlite] sqlite on IBM z/OS Unix > >Having successfully ported sqlite to z/OS Unix as a 32 bit app, I am >now >looking at a c program to make S

Re: [sqlite] sqlite on IBM z/OS Unix

2018-08-29 Thread Chris Brody
It is not clear to me why your program closes the sqlite3 database at the end of each C function invocation. AFAIK sqlite3 should not close any database connection unless your program invokes sqlite3_close. If something in the "Language Environment" closes and releases internal resources at the end

[sqlite] sqlite on IBM z/OS Unix

2018-08-29 Thread David Jackson
Having successfully ported sqlite to z/OS Unix as a 32 bit app, I am now looking at a c program to make SQL calls to this. Starting with an Assembler routine that runs within z/OS (not Unix), which is not LE (Language Environment)enabled, we then call a c routine (numerous times) that is LE enabled