Log In
       Accounting Solutions
Good Old-Fashioned Quality of Service

Developer Software

Get Running - Tegratecs Code Package™ (Advanced 2 Module)

Gen Db2 for i Stored Procedures and OO Wrapper Source

Stored Procedure & Embedded SQL Test Harness (Db2 for i)
This is one of two optional advanced modules that help boost productivity for developers already working with IBM SQL PL stored procedures... 

Gen Db2 for i Stored Procedures and OO Wrapper Source

 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. 

 Advanced 2 Module 
Gen Stored Procedure and c# wrapper base function source templates and stubs
-- based on Db2 for i metadata --

Get Running - SP Test Harness with filtering via parameters

Get Running - SP Test Harness showing output parameters

link to GR-TCP2 Example 1 full browser page snapshot PDF

        go to the home page Top of Tegratecs Code Packages     go to next series page Next in Tegratecs Code Packages     Site Map     Switch to
Mobile View

You are at the web site of Tegratecs Development Corp.  Click here to go to the home page of this site...
Integrity, Innovation and ROI
Our contact information:
Tegratecs Development Corp.®
1320 Tower Road
Schaumburg, IL 60173
( please contact us or register or sign-in )
© 2012-2022