Hi all!
I have created a couple of new Aha Ideas for "problems" all around RESTful and Trigger packages. When these were first created IBM obviously took the "quick-and-dirty" approach. I think it is time that these packages were brought into the fold of "normal" packages. To make it easier for IBM to split the work I opened two aha's:
DB24ZOS-I-1338 Full package support for Restful services
A restful service contains one and only one SQL statement and is, simply put, a mini-static package. It was delivered with a couple of problems. Firstly, the only way to tell if this static package is a restful service is to look at the HOSTLANG column not the TYPE column which you would expect. OK I can live with checking an extra field but then the worst, and second pain point, is that there is no support for EXPLAIN(ONLY). These restful services have access paths and we must be able to extract and check these without effecting running systems by doing a BIND SERVICE. Naturally there is also no REBIND SERVICE as all we got were BIND and FREE.
Long story short: Make restful services the same as static packages
and
DB24ZOS-I-1339 Full EXPLAIN support for all types of trigger
With Triggers you cannot use the REBIND option OWNER on a rebind. Why not? Not even for EXPLAIN(ONLY). We must get the ability, like with "normal" packages, to EXPLAIN into another set of EXPLAIN tables.
Further, if you are using Advanced Triggers EXPLAIN(ONLY) is not allowed at all! Thus making the advanced triggers slightly less advanced than basic triggers where you can use that syntax.
Bottom line: Bring EXPLAIN(ONLY) and REBIND options for all static packages to the same level
------------------------------
Roy Boxwell
Software Engineering GmbH
------------------------------