This is one of two separate advanced modules in the Get Running - Tegratecs Code Package™ that help boost productivity for developers already working with IBM SQL PL stored procedures...
Advanced 2 Module
We use this product to auto-generate about 85% of the SQL PL stored procedures we need for a master file data layer. IBM SQL PL is a language standardized by IBM across its Db2 product lines.
Video (10:37)
Gen 7 SQLPL SPs at once!
Then,
use IBM i ACS to create and check out all 7 in short order. Shortcuts to faciliate running custom C/M commands upon check out and change mode are provided for during the auto-gen (ours are STRSRCWRK and RGENSQLWIP).
Another way to use the product is to use your creativity in writing SQL statements as input, and this tool will combine it with Db2 for i metadata to automatically generate standard IBM SQL PL. Our product goes a long way with helping you to develop your own problem-solving techniques too...
DDL with beautiful final form SQL column names, such as those with spaces, are supported (which requires a good bit of differences in syntax). Please see pictures of example output for
Advanced 2 Module in these pages.
while you'll still have to compile the stored procedures outside of the product in v4 (like IBM i ACS), Advanced 2 Module is a true development tool.
Video (4:50)
Install IBM i ACS base on Developer Workstation
Advanced 2 Module can help you with the mundane and repetitive tasks like formulating lengthy column subset lists from JOIN SQL statements, or building or enhancing views, join record formats and stored procedures from inline SQL. Column attributes are pulled from Db2 metadata. Duplicate columns formed from blanket SQL select statements are resolved with the same pattern that is used to populate the gridview UI element.
This tool will help you save a lot of whittling with minutia level DDS versus SQL syntax differences, so you can make incremental improvements in your application development that take advantage of the strengths of each of the techniques.
**new with v4** Store and Recall Auto-Gen Settings by Name!
Big price increase coming with v4, purchase now
and you will be automatically authorized to download all new versions of Advanced 2 Module released in the next 365 days... No it's not AI, just good software programming, folks...
If you purchase a 1 month subscription version, c# code-behind the web page is not included, but you might find it easer to get it installed into a Visual Studio project.
No registry manipulation is ever required on the workstation for the Advanced 2 Module .dlls or any Get Running product, but you do need to reference the provider in a web forms (Visual Studio IDE) project. You may use the SQL PL code generated during the subscription period as long as you like!
With your license purchase, you'll receive all of the c# code-behind source that does the work behind the scenes for the web page. For Advanced 2 Module, that is c# to access Db2 for i metadata and to generate / write / output SQL PL in finished and stub form. This allows you to enhance the c# code based on your internal company stored procedure programming standards! (i.e. You may even choose to modify the c# so that it also generates SQL PL based on your company's standardized templates or patterns.)
A new version, 4.1, is on the horizon and there will be a significant price increase. Get your license now and only the maintenance cost will go up, but not until the following year.