Products for Developers and Programming Staff
Get even more out of your IBM Db2 for i database...
|
Sooner or later your company will want to utilize it's great Db2 for i data in remote applications and disparate environments.
IBM SQL PL stored procedures have been evolving since the early 2000s in mainframe, AIX & PC environments and have become the key way to access Db2 for i data from environments that don't have record level access (RLA).
|
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 IBM i developers already working with stored procedures.
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). This is the easiest way to prove out the prowess of the stored procedure method for remote applications or local but disparate environments. And this .dll operates fully within the IBM i security and permissions model.
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.
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)