Handling stored procedures in ACE/WMB/IIB

I'm always on the lookout for different ideas of how teams are using ACE/IIB/WMB as it helps inform us on what else we could be including in our MB-Precise product to help make development for?our customers teams that little bit easier.

And also make our product more attractive for teams looking at how they can better manage code quality.

But there are broader benefits when add a new rule to out list of coding checks that we provide.

We do have Google Analytics for our site, and I do see that people have added links on their Confluence pages to some of our rules. So even if they don't have our product or Sonarqube, when we create a new rule and?the associated documentation, it does help the broader development community. So not quite open source but still good sharing. I have also been asked to help with interview question preparation.?

And people have used our rules documentation to help get them selves ready.?

But I digress.

From our website, we do get asked for help with general ACE/IIB development.?

Over time I have been developing code snippets from a good number of resources.

We have been publishing examples for a while now on our website and also some sample projects on GitLab.

So to continue to build on this, I have started to publish links to some of the resources we have used to help the development of new rules onto our website. There is just one so far, but as I come across more that will get updated.

I find there are a lot of resources already that don't add much value. They are often just a cut and a paste from IBM documentation, but when I find something really value add I endeavor to share.

One of the suggestions from the page I have linked under resources has something that I haven't seen for calling stored procedures.

https://ibmintegrationbus.wordpress.com/2021/06/23/stored-procedure-in-iib/

It has a very helpful set of tips. There are some more details on the IBM site around the specifics.

I'm not sure how many of our customers use stored procedures heavily, but someone out there might be.

From out perspective, I added a new rule to our MB-Precise Sonarqube plugin to check for this in the ESQL code that is was scanning.

R441 - PASSTHRU statement invokes a stored procedure using 'CALL'. Create an external callable procedure with CREATE PROCDURE .... 'LANGUAGE DATABASE'.?(WMB)

So basically, if there is a need when developing ESQL to call a stored procedure, do it by creating a external procedure as it is more efficient then going via a PASSTHRU statement.

It might even come up as a question in someone's interview.?

More information on our products and on pricing can be found on our website:

https://bettercodingtools.com

You can also reach me via email at:

[email protected]

Or contact me via the contact page on our website:

www.bettercodingtools.com/contact

Regards

Richard