Re: SQL query interface for catalogs?

2020-03-29 Thread Salva Carrasco
I wrote a UDTF for Db2 interfacing the CSI and it works fine. But, Db2 is really annoying with user defined functions: -UDTF: only in Assembler or C. -Generic UDTF: only in C. -Parm list for UDF is weird: no number of parm --

Re: SQL query interface for catalogs?

2020-03-20 Thread Rob Schramm
Sounds good to me. It's no worse than a catalog search that returns everything. Rob Schramm On Fri, Mar 20, 2020, 13:10 Massimo Biancucci wrote: > John, > > it seems a nice idea anyway I tend to be cautious in interfacing catalog. > In my experience there's something that can go wrong. > >

Re: SQL query interface for catalogs?

2020-03-20 Thread Massimo Biancucci
John, it seems a nice idea anyway I tend to be cautious in interfacing catalog. In my experience there's something that can go wrong. Years ago we experienced some random delay in DB2 subsystem without having (after tenth of calls to IBM and dump and so on) the ability to diagnose the problem.

SQL query interface for catalogs?

2020-03-20 Thread John McKown
I do tend to come up with weird ideas. But I really like query languages, especially SQL. So I got to wondering if anyone else would like a query language, perhaps based on SQL, which uses the z/OS catalog structure as a data source? It would most likely use IGGCSI00 as its base driver code. Or is