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.
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.
DB24ZOS-I-1338 Full package support for Restful services
UPS6756, #1544403 Oleander Drive, Suite CWilmington, NC 28403 Phone: (910) 660-8649Fax: (910) 523-5504