Sign In
   Developer Productivity PKGs
Classic .NET Website Design
Accounting Suite for IBM i

Featured Products and Services  


Check In  or  Log In  for greater access...


Products for Developers
and Programming Services Staff


Mobile ASPX - Tegratecs Code Package™

Gain mobile, tablet & theatre views for your ASP.NET Web Forms environments in short order, without a big investment or responsive design rework.



Get even more out of your
        IBM Db2 for i database...


Sooner or later your company will want to utilize at least some of its great Db2 for i ERP data in remote applications and disparate environments like cloud or websites.  Auto-Gen Db2 for i SQL PL

Our Get Running - Tegratecs Code Package™ consists of 3 separate products useful for developing and testing SQL PL stored procedures.  Two of the products are labeled advanced, and are intended for developers already working with IBM SQL PL stored procedures on Db2 for i.
 
Answers to your questions on the Db2 for i .NET Provider...We are using the Db2 for i .NET Provider .dll from the IBM i ACS Windows Application Package to get quality Db2 for i integration from a web UI (Microsoft web forms). 
Got questions on this provider?


This is the easiest way to prove out the prowess of the remote stored procedure method while fully operating within the IBM i security and permissions model.   

IBM SQL PL stored procedures have been evolving since the early 2000s in Db2 environments and have become the key way to access large amounts of Db2 for i data or to integrate OLTP software environments that don't offer record level access (RLA) (or Read Equal to Key or Open Data Paths or file level row lock wait times etc...). 

All 3 of the Get Running components can be used on the developer workstation with the Visual Studio Community Edition from Microsoft at no cost.  Production web sites and applications using the Db2 for i .NET Provider do require Windows Server IIS, but it is a piece of cake to configure internally. 

Stay tuned for our attempts to demonstrate this running on Azure cloud (Windows Server IIS with Db2 for i .NET Provider pointing to local IBM i machine). 


Advanced Modules


Get Running - Tegratecs Code Package™ Advanced Modules
Auto-Gen Db2 for i SQL PL

This product is oriented towards generating Db2 for i SQL PL based on column layouts of a database file and your input, which includes options for naming standards, audit columns,  change management commands and more. 

We participated in the development of the IBM i ACS features for generating stored procedures in Run SQL Scripts! 

Video (10:37)
Auto-Gen Db2 for i SQL PL,
with v4.1 (new product version),
7 SPs at once
Compile via IBM i ACS Run Scripts,
with Checkout or Resync *cmd demo





Stored Procedure & Embedded SQL Test Harness

Video - Scan SQL PL Stored Procedure Object Metadata for a Hard-Coded Schema (Library) Name

(then use IBM i ACS Run Scripts to edit the source and recreate the SP object)





Pro Intro Module

Great for training or kicking the technology tires, this training module includes working c# and vb.net source code for use within most any MS web forms project and most any version of Visual Studio, including Community Edition (the essentially free version).  

Create a .NET DataSet
from Db2 for i Table
via Drag & Drop
(9 minutes or use skip to chapter feature)










        go to the home page     go to next series page Next in Introductions     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...
Offering Innovation & Providing ROI
without building Islands of Automation
Our contact information:
Tegratecs Development Corp.®
1320 Tower Road
Schaumburg, IL 60173
847-397-0088
800-739-FPSS
( please contact us or create a Web User ID or sign in )
© 2012-2026