Log In
       Innovative Solutions to Your Evolving Requirements

Get Running - TechCrystals 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 TechCrystals Code Packages     go to next series page Next in TechCrystals 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, Integration and ROI from Your Software
Our contact information:
Tegratecs Development Corp.
1320 Tower Road
Schaumburg, IL 60173
800-739-3777
( please register or sign-in )
© 2021 Tegratecs Development Corp.