Advanced 2 Module is Gen Db2 for i Stored Procedures and OO Wrapper Source. It allows gen of complete IBM SQL PL stored procedures and c# and SQL PL stubs and snippets. While you'll still have to compile the stored procedures somewhere (like ACS), Advanced 2 Module is a true development tool.
This product goes a long way with helping you to develop your own problem-solving technique, because there are so many examples, stubs and snippets generated with each SQL or stored procedure used as basis input...
Nicely-formatted SQL column headings with spaces are supported (which requires differences in syntax). Please see pictures of example output for Advanced 2 Module in these pages.
Advanced 2 Module is also intended to 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 (without requiring a big leap of faith or investment just to get started at a professional level).
With your purchase, you'll receive all of the c# code-behind source that does the work behind the scenes. 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. Both Advanced Modules include all of the XHTML and CSS used in web pages UI.
You may even choose to modify the c# so that it also generates SQL PL based on your company's standardized templates or patterns.
Didn't find what you were looking for? Please let us know.