Log In
       Innovative Solutions to Your Evolving Requirements

Purchasing Get Running - TechCrystals Code Package™ and Add-Ons

Get Running with the IBM Db2 for i .NET Provider

Get Running - TechCrystals Code Package base version licenses for only  $95 now and is immediately downloadable after purchase via emailed key!  The emailed key is good to download any fixes that are published in the 6 months following the purchase date. 

Add-On 1, SQL Prototyping Web UI and Stored Procedure Test Harness, goes for $235 and includes a maintenance plan that allows download of incremental updates and new version releases for 1 year (renewable at only $40/year). 

Taking It to Another Level with Db2 for i

Add-On 2, Gen Db2 for i Stored Procedures and OO Wrapper Source, allows you to generate stored procedure templates and stubs code in IBM SQL PL and c# for $355 additional and also includes 1 year of new version updates.

You only need 1 license if you are an individual developer or purchasing for an end-user company (intended to allow source code usage and improvements to be made by up to 5 developers simultaneously).  Software service providers, education organizations and ISV(s), please contact us.


Download Keys Delivery  (Show Expanded Details...)   
  • The keys that enable immediate download (directly after purchase) are emailed to the PayPal Account holder used with the purchase.

  • If you are logged in to tegratecs.com and your Web User ID has a verified email address that is different, a second set of the keys will be emailed directly to you also.

  • If you don't have access to the PayPal account holder email address and aren't logged in to tegratecs.com, please contact us after the purchase to let us know how we can assist you (in getting the keys to you, mailing you a CD or by linking accounts via the back office, which may take up to 12 hours depending upon your time zone).


Licensing Terms   (Show Expanded Details...)   
  • Licensing terms are easy for Get Running - TechCrystals Code Package™.  You only need 1 license if you are an individual developer or an end-user company providing product source code for derivative works by up to 5 employee developers at a time. 

  • The license time frame for the product is 7 years and corresponds to v2.1. The base product includes download of v2.1 and V2% fixes and releases for 6 months.  The Add-Ons are licensed with a 1 year maintenance agreement that extends the ability to do self-serve downloads basically for any current or future version for one year.

  • Extrapolating a technique out of a snippet of the copyrighted source code is not considered a derivative work.  It is an intended usage.

  • Run time executables created and owned by the licensee that are created using copyrighted Add-On 1 or base product source code, but that do not contain source code in the deployed version, can be deployed by the licensee without a user or computer count restriction. 

  • The SQL PL and c# code that is generated out of Add-On 2 by the licensee is not considered part of the copyrighted source code and has no usage restriction for the licensee.  However, Add-On 2 is not licensed for deployment to a production web server.

  • A single license gives rights for a single contract developer (or end-user company as stated) to use as he/she sees fit including to make derivative works, provided existing copyright statements are included in copied or derivative code until at such point the new work is over 50% different than the source code provided (which is basically the standard minimum software copyright guidelines for claiming rights and avoiding copyright infringement).

  • A single license can also be purchased by an end-user company, and it is intended to provide source code usage rights for up to 5 developers.  For example, IT and software development service providers are not considered end-user companies.

  • Software service providers, education organizations and ISV(s), please contact us.



Bundle Offer

Purchase Bundle HERE at 25% Discount!
 Cart  (Show Details...)   
QuantityUOMItemDescriptionPriceCurr Code
1EACHGRTCPBLFGet Running - TechCrystals Code Package (Base) - v2.1
GR-TCPb LicFee v2.1   6 Mn Downloads+Fixes v2%
70.00USD
1EACHGRTCP1LFAdd-On 1 - Get Running - TechCrystals Code Package - v2.1
GR-TCP1 LicFee v2.1   6 Mn Downloads+Fixes v2%
145.00USD
1EACH GRTCP1MPAdd-On 1 - Get Running - TCPkg 12 Mn Maintenance Plan
GR-TCP1 MntPln v2.1   12 Mn Support+Updates v%
40.00USD
1EACHGRTCP2LFAdd-On 2 - Get Running - TechCrystals Code Package - v2.1
GR-TCP2 LicFee v2.1   6 Mn Downloads+Fixes v2%
220.00USD
1EACHGRTCP2MPAdd-On 2 - Get Running - TCPkg 12 Mn Maintenance Plan
GR-TCP2 MntPln v2.1   12 Mn Support+Updates v%
60.00USD
4    Total 535.00 
(LogIn to PayPal required)
(you will have the option to continue or to cancel on PayPal)

$535 US
Get Running - TechCrystals Code Package™
(complete = Base + Add-On 1 + Add-On 2)
(Illinois residents, we'll cover the sales tax for you)



Component Subscription Offers

Purchase Base (c#) HERE
 Cart  (Show Details...)   
QuantityUOMItemDescriptionPriceCurr Code
1EACHGRTCPBLFGet Running - TechCrystals Code Package (Base) - v2.1
GR-TCPb LicFee v2.1   6 Mn Downloads+Fixes v2.1%
95.00USD
1    Total95.00 
(LogIn to PayPal required)
(you will have the option to continue or to cancel on PayPal)

$95 US
Get Running - TechCrystals Code Package
(base)
(Illinois residents, we'll cover the sales tax for you)


Contents of Get Running - TechCrystals Code Package (base) $95 US

(Ch 1) install VS 2017 CE or VS 2019 CE pics
(Ch 2a) create c# web app (web forms) base project VS 2017
(Ch 2b) create c# web app (web forms) base project VS 2019
(Ch 3) download latest Db2 for i .NET Data Provider from IBM
(Ch 4)
install latest Db2 for i .NET Data Provider DLL
(Ch 5a) create new web project - simplest and fastest pro app
Dynamic Inline SQL to Results Gridview (web page)
(Ch 5b) subset - enable use (reference) the DLL in an existing VS project
(Ch 6) special (rare) circumstance specs involving the provider
simplest and fastest pro app with responsive master page from MS project template
Get Running with the IBM Db2 for i .NET Provider presentation powerpoint

Picture of (Chapter 5) Dynamic Inline SQL to Results GridView (included in base
Shown here using SQL filtering and gridview filtering and Db2 for i SQL timestamp formulation at run time from old style decimal date and time columns... 

Simplest Inquiry with 2 types of filtering and timestamp formulation from decimal fields from Get Running - TechCrystals Code Package

This web page function is also quick to get running within a responsive master page drop-down menu because a version of Simplest Inquiry is included that runs under the bootstrap master page (that is included within Microsoft's Web Forms ASP.NET Web Application project template.




Get Running - TCP Add-On 1 - $235 (optional)

(Chapter 9) SQL Prototyping Web UI and Stored Procedure Test Harness

Purchase Add-On 1 HERE
 Cart  (Show Details...)   
QuantityUOMItemDescriptionPriceCurr Code
1EACHGRTCP1LFAdd-On 1 - Get Running - TechCrystals Code Package - v2.1
GR-TCP1 LicFee v2.1   6 Mn Downloads+Fixes v2%
195.00USD
1EACH GRTCP1MPAdd-On 1 - Get Running - TCPkg 12 Mn Maintenance Plan
GR-TCP1 MntPln v2.1   12 Mn Support+Updates v%
40.00USD
2    Total235.00 
(LogIn to PayPal required)
(you will have the option to continue or to cancel on PayPal)

$235 US
SQL Prototyping Web UI and Stored Procedure Test Harness
with 12 Month Maintenance Plan
(Illinois residents, we'll cover the sales tax for you)


Picture of (9) SQL Prototyping Web UI and Stored Procedure Test Harness
running stored procedure WEBDAPURCHCONFPPCDETROWLISTSS1 with a lot of  parameters ("*null" triggers passing of c# null)

Stored Procedure Test Harness and SQL Prototyping Web Inquiry picture from Get Running - TechCrystals Code Package


Didn't find what you were looking for?  Please let us know. 


Get Running - TCP Add-On 2 - $355 (optional)

(Chapter 21) Gen Db2 for i Stored Procedures and OO Wrapper Source
using c#, IBM SQL PL and the MS .NET Framework


Purchase Add-On 2 HERE
 Cart  (Show Details...)   
QuantityUOMItemDescriptionPriceCurr Code
1EACHGRTCP2LFAdd-On 2 - Get Running - TechCrystals Code Package - v2.1
GR-TCP2 LicFee v2.1   6 Mn Downloads+Fixes v2%
295.00USD
1EACHGRTCP2MPAdd-On 2 - Get Running - TCPkg 12 Mn Maintenance Plan
GR-TCP2 MntPln v2.1   12 Mn Support+Updates v%
60.00USD
2    Total 355.00 
(LogIn to PayPal required)
(you will have the option to continue or to cancel on PayPal)

$355 US
Gen Db2 for i Stored Procedures and OO Wrapper Source
with 12 Month Maintenance Plan
(Illinois residents, we'll cover the sales tax for you)

Pictures of (21) Gen Db2 for i Stored Procedures and OO Wrapper Source

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

Gen Db2 for i Stored Procedures and OO Wrapper Source Example 1.1 picture from Get Running - TechCrystals Code Package
Gen Db2 for i Stored Procedures and OO Wrapper Source Example 1.2 picture from Get Running - TechCrystals Code Package
Gen Db2 for i Stored Procedures and OO Wrapper Source Example 1.3 picture from Get Running - TechCrystals Code Package
Gen Db2 for i Stored Procedures and OO Wrapper Source Example 1.4 picture from Get Running - TechCrystals Code Package
Gen Db2 for i Stored Procedures and OO Wrapper Source Example 1.5 picture from Get Running - TechCrystals Code Package



link to -> Get Running - Licensed Product Downloads (and occasionally a free promo or two)

More Technical Details on the Data Provider:  Licensing of this data provider from IBM is included with any IBM ACS (Access Client Solutions) license.  The data provider is an IBM product that is not distributed in this TechCrystals Code Package.  However, this product bundle includes a rather complete set of information on how to source the latest version of the provider, and how to install it on the Windows workstation (for use in Visual Studio) and for use from websites or web applications in the Windows IIS web server.  No changes are required on Windows Servers at your company in order for you to use this product as a developer on your workstation.  Obviously at least one IBM i user profile is required for access to Db2 for i.  Connection string example shows how to use the *LIBL technique...  Please note that download of the data provider and its setup.exe is done separately from the base ACS (Access Client Solutions) and is done by downloading the Windows Application Package (typically called something like  IBMiAccess_v1r1_WindowsAP_English).   



        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...
Innovative Solutions to Your Evolving Requirements
Our contact information:
Tegratecs Development Corp.
1320 Tower Road
Schaumburg, IL 60173
800-739-3777
( please register or sign-in )
© 2021 Tegratecs Development Corp.