Log In
   Developer Productivity PKGs
Enterprise Web Apps
IBM i w/ smartclient Solutions

Get Running - Tegratecs Code Package™ (Advanced 1 Module)

Stored Procedure & Embedded SQL
Test Harness (Db2 for i)


This is one of two separate advanced modules in the Get Running - Tegratecs Code Package™ that help boost productivity for developers already working with embedded SQL, IBM SQL PL or Db2 for i stored procedures of any type... 


Stored Procedure & Embedded SQL Test Harness (Db2 for i)
Scan SQL PL Stored Procedure Objects for a Hard-Coded Library Name
Create the Leanest Base Web App Project for Get Running Advanced Modules

 Advanced 1 Module  allows the developer or technical consumer to run and test stored procedures or embedded SQL from a high level language interface without setup programming of any kind. 

It allows the developer or technical consumer to quickly and dynamically see input and output parameter lists and values along with HTML5 results sets.  Both Embedded SQL and Stored Procedure modes allow formulation of transaction boundaries (so you get a commit or rollback option).  Both use library list logic so it contributes to developing identical SQL PL for both testing and production (yea!). 

SQL and SQL PL can be extracted from views and stored procedures.  Dynamic filtering of view and stored procedure lists is available by substring on name and content (SQL and SQL PL source) across libraries.

When you consider the other features within this offering, it makes it a contender as your best development tool for prototyping Db2 for i stored procedures and embedded SQL, regardless of whether they will be consumed by a .NET programming language in a web, client-server or hybrid environment or by a native IBM i programming language. 

The HTML5 makes for good aesthetics and efficient layouts with dynamic sizing of result sets.  New with this version are several UI level options that enable transaction level control (commit and rollback) and notification of whether table and files referenced are journaled or aren't being journaling (which affects rollback). 

Db2 for i metadata is interpreted real time, so changes made to a parameter list or output result of a stored procedure in a separate session of ACS are detected immediately.  Similarly, it detects changes in the parameter list that have occurred since you first started working with a particular stored procedure.  Dynamic row filtering on top of the result set is also available for prototyping WHERE clause enhancements. 

Between the .NET Framework, c# and standard IBM SQL PL stored procedures, null is supported as a parameter value, and our tool lets you trigger a real null input parameter value via entry of the keyword "*null".  Advanced 1 Module contains over 3500 lines of c# code. 



 Advanced 1 Module 
Stored Procedure & Embedded SQL
Test Harness (Db2 for i)


Example 1 - Run Embedded SQL mode - Shows the process of selecting a view from which to extract the SQL.  The View drop-down list is filtered based on the name containing "event" and the SQL within the view including a "join" statement.
Example 1 - Run Embedded SQL mode - Shows the process of selecting a view from which to extract the SQL


Example 2 - Shows the SQL extracted from the OMNIEVENTATTENDANCEVIEW2 View and the result set.  However, there aren't any rows in the result set.  This is because of the Row Filtering criteria specifying that at least one column must contain "santa".
Example 2 - Shows the SQL extracted from the OMNIEVENTATTENDANCEVIEW2 View and the result set

Example 3 - shows the stored procedure drop-down list populated only with stored procedure names that pass the filtering criteria
  • SQL or system names that contain "event"
  • SQL PL content that contains "select"
  • exists within a library (or schema) that is in the user library list ("*USRLIBL" qualifier)
    (the library list is defined in the connection string)
 Example 3 - shows the stored procedure drop-down list populated only with stored procedures that pass the filtering criteria


Example 4 - successful stored procedure call with result set output filtered by  parameter values
Example 4 - successful stored procedure call with result set output filtered by  parameter values


Example 5 - detection of Update and request for developer or QA user to allow (proceed)
Example 5 - detection of Update and request for developer or QA user to allow (proceed)


Example 6 - detection of missing journaling status
Example 6 - Detection of Missing Journaling Status




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


Example 7 - successful stored procedure call with only 1 output parameter
Example 7 - successful stored procedure call with only 1 output parameter


Example 8 - Populating the Stored Procedure drop-down list based on a name containing "getnxt" and without library restriction (from *ALL libraries).  However, after clicking on Go and running GETNXTAVAILCTCID, there wasn't the authority necessary to derive the data type(s) of the parameter(s), and that usually means there won't be enough authority to run it either.
Get Running - SP Test Harness showing output parameters



Licensing Terms   (Show Expanded Details...)   
  • Licensing terms are easy for Get Running - Tegratecs Code Package™, considering it is a product that includes source code.  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 Advanced Modules 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.
  • 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 for use by only the licensee, 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, your price will be different, perhaps even lower, in some cases.



License Advanced 1 Module HERE

Stored Procedure & Embedded SQL
Test Harness (Db2 for i)

(product includes source code)
 Order Items  (Show Details...)   
QuantityUOMItemDescriptionPriceCurr Code
1EACHGRTCP1LF Get Running-TCpkg - Advanced 1 Module - License - v3.1
GR-TCP1 LicFee v3.1   6 Mn Downloads+Fixes v3%
580.00USD
1EACH GRTCP1MPGet Running-TCpkg - Advanced 1 Module 12 Mn Maintenance Plan
GR-TCP1 MntPln v3.1   12 Mn Support+Updates v%
115.00USD
2    Total695.00 
(LogIn to PayPal or click Debit or Credit Card)
(both handled via PayPal with option to approve or cancel)
(No CC digits will stored on tegratecs.com)

$695 US
Get Running - Tegratecs Code Package™
Advanced 1 Module
with 12 Month Maintenance Plan
(Illinois locations, we'll cover the sales tax for you)





Get 1 Month Subscription for
Advanced 1 Module HERE

Stored Procedure & Embedded SQL
Test Harness (Db2 for i)


$45 US - 1 Month Subscription

(runtime only version, no c# source code-behind)
(requires the .NET Framework)
(requires a reference to the IBM Db2 for i .NET Provider .dll in your website or web application project (instructions included))
 Order Items  (Show Details...)   
QuantityUOMItemDescriptionPriceCurr Code
1EACH GRTCP1SS Get Running-TCpkg - Adv 1 Module - 1 Mn Subscription - v3.1
GR-TCP1 SubLic v3.1   1 Mn Subscription License v3.1
45.00USD
1     Total 45.00  
(LogIn to PayPal or click Debit or Credit Card)
(both handled via PayPal with option to approve or cancel)
(No CC digits will stored on tegratecs.com)

(Please enter IBM i Serial Number to enable PayPal buttons)
IBM i Serial Number

$45 US - 1 Month Subscription

Get Running - Tegratecs Code Package™
Advanced 1 Module
(object only version tied to IBM i serial number)
(Illinois locations, we'll cover the sales tax for you)



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 that email address 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).






        go to the home page Top of Tegratecs Code Packages     go to next series page Next in Tegratecs 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...
Offering Innovation & Providing ROI
while reducing 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 register or sign-in )
© 2012-2024