Products for Developers
and Programming Services Staff
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.
|
|
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.

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
|
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
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)