Mobile Log In
       Building and Delivering
Quality Software Results



Take advantage of our expertise in both standardized software solutions and custom IT services!

News and Events




Lineup for The Omni User tech conference 2017 announced...

The Omni User is putting on its annual 1 day technical conference in Schaumburg, IL, Tuesday September 19th 2017.  The organizers ( www.omniuser.org ) are promising a great value.  Education content will include the latest in relational database capabilities, IBM i Admin, development on the IBM i platform and a keynote on Watson integration. 

One common denominator for most everyone in IT is SQL and relational database.  This year Scott Forstie from IBM will be presenting on late breaking features such as Row and Column Access Control.  Apparently one thing you can do with this new Db2 for i capability is to define rules that restrict data access to certain users, by say, a company identifier data element, using SQL where clauses and joins.  The row access control technique occurs not within application programming but instead it is defined at a database admin security level, so it prevents even read access to unauthorized portions of data for query users or any ad-hoc methods of data access in a proactive manner.  Thus, use of this technique in the future may provide an an easier way to go beyond object level permissions and get down into the application data level for enforcement of data ownership and inquiry rights. 

Another new feature in Db2 involves temporal table support, which provides for SQL access to see table(s) as they existed at any point in the past, including records that have long since been deleted.  Obviously rows that are deleted before the temporal table support is turned on aren’t available. 

There will be 3 other tracks of presentations.  One is Pete Massiello talking about IBM i admin topics including Virtual i Partitions and key things to know for your IBM i 7.3, 7.2 or 7.1 OS upgrades.  Tim Rowe, an excellent source for information about the latest happenings in the IBM i area, will do several sessions, which I am sure will include good details about the RDi IDE, which has new features added recently to accommodate refactoring. 

Barbara Morris is a very insightful presenter with a lot of insider knowledge.  She will be doing a session recapping many of the new RPG Free features that have been brought to fruition since IBM i 7.1, and another session focusing on new support for handling null values in RPG (along with some candid insights) and more. 

Full details on all of the presentations are now on the Omni User web site. ( Omni User Technical Conference 2017 Session Grid... ) The conference will start out with keynote topic IBM i Talks to Watson.

In the Expo, Tegratecs will be there talking about its Financial Portrait accounting suite and smartclient, ETL and our top quality development services, which now include expertise in real time integration with Db2 for i from c# and ASP.NET web forms
See more on IBM's Db2 for i Data Provider for .NET....




Tegratecs' Rex Smith presented at COMMON 2017 Annual Meeting and Exhibition at Universal Orlando

COMMON's largest event this year ran May 7-10, 2017 at Loews Sapphire Falls Resort at Universal Orlando™.  The conference hotel is so new we put up an artist rendering but only the parking garage showed signs of construction.  There were over 300 sessions.  Rex Smith presented Securely transfer IFS extracts using native IBM i tools! on Monday May 8th at 2PM.  There were 15 other sessions and presentations going on concurrently at that time so there are a lot of learning opportunities for a wide range of interests.   See the filtered view of RPG IV focused content...




WMCPA's annual conference March 14-17 2017 was great...

WMCPA put together another excellent conference on the heels of last year's success.  There were over 20 speakers and 50 sessions included with conference attendance.  The snow on the ground made for nice views and an atmosphere of learning.  Upper class hospitality and comfort and value was provided by the Lake Lawn resort.  Tegratecs was there as a corporate sponsor working on focusing new business development efforts around IBM's DB2 for i data provider and proactive row locking with SQL techniques (for most any DB).
See speakers and conference schedule here...




Andrew Clark to present Writing Cross Platform SQL for The Omni User group...

The Omni User welcomes Andrew Clark from RT Analytics to present Writing Cross Platform SQL on January 17th, 2017 at IBM in Oak Brook Terrace, IL.  Andrew will be offering techniques that work across most if not all of the top databases, including Access 2003, SQL Server 2012, DB2 for i 7.2, Postgres 9.5.1, MySQL 5.6.11 and Oracle 11g.




Tegratecs announces CRTCSV IBM i *CMD licensed product...

Tegratecs Development Corp., based in Schaumburg, Illinois, has announced a new utility software product to create .csv, xml or tab-delimited text files on IBM i.  The Tegratecs licensing department indicates you can download a full functioning trial version of the product without charge or obligation, obtain a 7 day extension code online and install it within 30 minutes without talking to a salesman. 

Developers on IBM i OS will know this as a *CMD (command) object type that creates stream files in different formats on the IFS (Integrated File System).

CRTCSV licenses on a yearly subscription basis for $95 per year per partition regardless of tier or user count.

Create .CSV, Tab-Delimited .TXT or XML Stream File (an IBM i *cmd object type)...




Tegratecs announces new ASP.NET web project templates...

Tegratecs is pleased to announce completion of new web project templates for ASP.NET web forms and their immediate availability for use within internal websites.  The new templates feature use of the .NET Framework 4.6.1, Visual Studio 2015 and the MS Ajax Control Toolkit version 16.1, now maintained by DevExpress©.  Also featured in the templates is the infrastructure to support mixed language development and use of the best programming language for the task, whether it be C#, VB.net or ASNA Visual RPG 14.0.  Please stay tuned for download and licensing offers.




IBM announces IBM i 7.3!

On April 12th, 2016, IBM announced a new version of the IBM i operating system.  IBM i 7.3 runs on selected IBM Power Systems and PurePower Systems servers with POWER7, POWER7+, and POWER8 processors.  Way cool is the new temporal table support included with DB2® for i reported to allow an "as of" date and time support with minimal development effort, potentially providing a better alternative to other more time consuming and intracate application software development techniques.  Please take a look through these links for more information... 
Please see IBM i 7.3 can deliver... and
iNext Revealed As IBM i 7.3 from IT Jungle...




Chicago Cubs win the 2016 World Series!

Congratulations to the Chicago Cubs!  After the longest drought in title repeats in known professional sports history, the Cubs played their hearts out in an unbelievable 7th game contest to win the title. 

Congrats also to the Cleveland Indians for a great year and great playoff run. 
Cubs Win celebration




Tegratecs announces licensing of the ASNA DataGate Webpak

Tegratecs Development Corp. of Schaumburg, IL is pleased to announce licensing of the ASNA DataGate Webpak 12.0 in April 2015.   DataGate Webpak is a runtime for Microsoft's IIS web server that supports ASNA’s Visual RPG (AVR) for .NET programming language in the code-behind.  AVR for .NET brings along several familiar constructs from traditional IBM i languages, yet incorporates full object-oriented (OO) interaction with .NET framework objects and methods at runtime.  AVR for .NET is compatible with running, instantiating and inheriting c# and vb.net components and web pages within the same website.  In addition to the ability to target stored procedures to MSSQL or IBM DB2 for i, the language provides support for RLA data access and data buffering, which comes in handy for advanced and nimble cursor-like random access using the keys to record index without relying on process memory.







Lineup for The Omni User tech conference 2017 announced...

The Omni User is putting on its annual 1 day technical conference in Schaumburg, IL, Tuesday September 19th 2017.  The organizers ( www.omniuser.org ) are promising a great value.  Education content will include the latest in relational database capabilities, IBM i Admin, development on the IBM i platform and a keynote on Watson integration. 

One common denominator for most everyone in IT is SQL and relational database.  This year Scott Forstie from IBM will be presenting on late breaking features such as Row and Column Access Control.  Apparently one thing you can do with this new Db2 for i capability is to define rules that restrict data access to certain users, by say, a company identifier data element, using SQL where clauses and joins.  The row access control technique occurs not within application programming but instead it is defined at a database admin security level, so it prevents even read access to unauthorized portions of data for query users or any ad-hoc methods of data access in a proactive manner.  Thus, use of this technique in the future may provide an an easier way to go beyond object level permissions and get down into the application data level for enforcement of data ownership and inquiry rights. 

Another new feature in Db2 involves temporal table support, which provides for SQL access to see table(s) as they existed at any point in the past, including records that have long since been deleted.  Obviously rows that are deleted before the temporal table support is turned on aren’t available. 

There will be 3 other tracks of presentations.  One is Pete Massiello talking about IBM i admin topics including Virtual i Partitions and key things to know for your IBM i 7.3, 7.2 or 7.1 OS upgrades.  Tim Rowe, an excellent source for information about the latest happenings in the IBM i area, will do several sessions, which I am sure will include good details about the RDi IDE, which has new features added recently to accommodate refactoring. 

Barbara Morris is a very insightful presenter with a lot of insider knowledge.  She will be doing a session recapping many of the new RPG Free features that have been brought to fruition since IBM i 7.1, and another session focusing on new support for handling null values in RPG (along with some candid insights) and more. 

Full details on all of the presentations are now on the Omni User web site. ( Omni User Technical Conference 2017 Session Grid... ) The conference will start out with keynote topic IBM i Talks to Watson.

In the Expo, Tegratecs will be there talking about its Financial Portrait accounting suite and smartclient, ETL and our top quality development services, which now include expertise in real time integration with Db2 for i from c# and ASP.NET web forms
See more on IBM's Db2 for i Data Provider for .NET....




Rex Smith presented at COMMON 2017 Annual Meeting and Exhibition at Universal Orlando

Early park admission is one advantage of this conference hotel...

COMMON's largest event this year ran May 7-10, 2017 at Loews Sapphire Falls Resort at Universal Orlando™.  The conference hotel is so new we put up an artist rendering but only the parking garage showed signs of construction.  There were over 300 sessions.  Rex Smith presented Securely transfer IFS extracts using native IBM i tools! on Monday May 8th at 2PM.  There were 15 other sessions and presentations going on concurrently at that time so there are a lot of learning opportunities for a wide range of interests.   See the filtered view of RPG IV focused content...




WMCPA's annual conference March 14-17 2017 was great...

WMCPA put together another excellent conference on the heels of last year's success.  There were over 20 speakers and 50 sessions included with conference attendance.  The snow on the ground made for nice views and an atmosphere of learning.  Upper class hospitality and comfort and value was provided by the Lake Lawn resort.  Tegratecs was there as a corporate sponsor working on focusing new business development efforts around IBM's DB2 for i data provider and proactive row locking with SQL techniques (for most any DB).
See speakers and conference schedule here...

WMCPA 2017 spring conference runs March 14-17, 2017...

WMCPA 2017 spring conference runs March 14-17, 2017...

WMCPA 2017 spring conference runs March 14-17, 2017...




Andrew Clark to present Writing Cross Platform SQL for The Omni User group...

The Omni User welcomes Andrew Clark from RT Analytics to present Writing Cross Platform SQL on January 17th, 2017 at IBM in Oak Brook Terrace, IL.  Andrew will be offering techniques that work across most if not all of the top databases, including Access 2003, SQL Server 2012, DB2 for i 7.2, Postgres 9.5.1, MySQL 5.6.11 and Oracle 11g.




Tegratecs announces CRTCSV IBM i *CMD licensed product...

Tegratecs Development Corp., based in Schaumburg, Illinois, has announced a new utility software product to create .csv, xml or tab-delimited text files on IBM i.  The Tegratecs licensing department indicates you can download a full functioning trial version of the product without charge or obligation, obtain a 7 day extension code online and install it within 30 minutes without talking to a salesman. 

Developers on IBM i OS will know this as a *CMD (command) object type that creates stream files in different formats on the IFS (Integrated File System).

CRTCSV licenses on a yearly subscription basis for $95 per year per partition regardless of tier or user count.

Create .CSV, Tab-Delimited .TXT or XML Stream File (an IBM i *cmd object type)...




Tegratecs announces new ASP.NET web project templates...

Tegratecs is pleased to announce completion of new web project templates for ASP.NET web forms and their immediate availability for use within internal websites.  The new templates feature use of the .NET Framework 4.6.1, Visual Studio 2015 and the MS Ajax Control Toolkit version 16.1, now maintained by DevExpress©.  Also featured in the templates is the infrastructure to support mixed language development and use of the best programming language for the task, whether it be C#, VB.net or ASNA Visual RPG 14.0.  Please stay tuned for download and licensing offers.




IBM announces IBM i 7.3!

On April 12th, 2016, IBM announced a new version of the IBM i operating system.  IBM i 7.3 runs on selected IBM Power Systems and PurePower Systems servers with POWER7, POWER7+, and POWER8 processors.  Way cool is the new temporal table support included with DB2® for i reported to allow an "as of" date and time support with minimal development effort, potentially providing a better alternative to other more time consuming and intracate application software development techniques.  Please take a look through these links for more information... 
Please see IBM i 7.3 can deliver... and
iNext Revealed As IBM i 7.3 from IT Jungle...




Chicago Cubs win the 2016 World Series!

Congratulations to the Chicago Cubs!  After the longest drought in title repeats in known professional sports history, the Cubs played their hearts out in an unbelievable 7th game contest to win the title. 

Congrats also to the Cleveland Indians for a great year and great playoff run. 
Cubs Win celebration




Tegratecs announces licensing of the ASNA DataGate Webpak

Tegratecs Development Corp. of Schaumburg, IL is pleased to announce licensing of the ASNA DataGate Webpak 12.0 in April 2015.   DataGate Webpak is a runtime for Microsoft's IIS web server that supports ASNA’s Visual RPG (AVR) for .NET programming language in the code-behind.  AVR for .NET brings along several familiar constructs from traditional IBM i languages, yet incorporates full object-oriented (OO) interaction with .NET framework objects and methods at runtime.  AVR for .NET is compatible with running, instantiating and inheriting c# and vb.net components and web pages within the same website.  In addition to the ability to target stored procedures to MSSQL or IBM DB2 for i, the language provides support for RLA data access and data buffering, which comes in handy for advanced and nimble cursor-like random access using the keys to record index without relying on process memory.





Register
with tegratecs!
 or  Log In for access to protected content...


        go to the home page Top of DataLens for DB2/400     go to next series page     Site Map     Mobile View
You are at the web site of Tegratecs Development Corp.  Click here to go to the home page of this site...
Integrity, Integration and ROI from Your Software
Our contact information:
Tegratecs Development Corp.
1320 Tower Road
Schaumburg, IL 60173
847-397-0088
( please register or sign-in )
© 2017 Tegratecs Development Corp.