Mobile Log In
       Building and Delivering
Quality Software Results

Tegratecs News and Events

Tegratecs News and Events

WMCPA's annual conference March 13-15 2018 is next week!   (Show Details...)   
WMCPA 2018 spring conference runs March 13-15, 2018...

WMCPA has a vibrant education event and vendor exhibit coming to Lake Lawn Resort in Delavan, Wisconsin.  There will be over 50 sessions included with conference attendance, along with the Extreme Makeover - UI Edition and Women in IT seminars and a great atmosphere of fun and learning. 

Tegratecs Development Corp.® will be there as a corporate sponsor touting it's latest development techniques and products. 

We'll be presenting our fast path for getting to a real GUI out of your workhorse textual UI applications.  This will include developer oriented tips for leveraging dynamic translation and minimizing dual maintenance. 

We are still excited about our deadlock and rollback eliminating transaction technique using c#, SQL PL and IBM's DB2 for i data provider for .NET.

And lastly, coming soon, within a new release of Financial Portrait, we are proud to announce electronic payment transactions direct from Accounts Payable on IBM i.  ePayments in this first release include domestic ACH and commercial card transactions to Wells Fargo Payment Manager via sftp over SSH.  No paper checks or online payments bank reconciliation consternation with this method!  We are also available on a services basis to help you with this on your custom system in the event a nice new comprehensive package isn't in the cards.

See speakers and conference schedule here... late afternoon view from the bar area in one of the restaurants...

Tegratecs is a Sponsor at Omni User Technical Conference 2017 on 09/21/7...   (Show Details...)   

The Omni User put on its annual 1 day technical conference in Schaumburg, IL, Tuesday September 19th 2017.  The organizers delivered on their promise of an event... providing great value, with education content including the latest in relational database capabilities, IBM i Admin, and business application software development on the IBM i platform. The conference started with a keynote on Watson and integrating with Watson. 

Tegratecs had a booth in the vendor exhibit area, highlighting various strengths in their offerings, including its Financial Portrait accounting suite and smartclient, ETL, and top quality custom development services. Click here for Tegratecs software and service offerings of focus at Omni Tech Conference 2017

One common denominator for most everyone in IT is SQL and relational database.  This year Scott Forstie from IBM presented on late breaking features such as Row and Column Access Control.  With this new Db2 for i capability, you can define rules that restrict data access to certain users using syntax similar to SQL where clauses and joins.  Use of this technique in the future can remove objections to providing direct data access to users who are self-sufficient in creating their own reports and inquiries for analysis and Business Intelligence agendas. 

Read this next paragraph for further technical insight on how Row Access Control might be implemented.

The row access control technique is not implemented at the application programming level, but instead a new database admin security level, so it proactively prevents even read access to unauthorized portions of data for query users and any other ad-hoc methods of data access.  However, if you already have existing application level security or permissions data represented in database form, especially that which determines data ownership and access rights at a more granular level than the IBM i OS, you would definitely want to use that data in the new Row Access Control specifications. A fairly simple but practical example could be one that determines which companies can be accessed by IBM i User Profile in a multi-company environment (such as PRMS or Financial Portrait Software System).  The only thing you need (to be in position), are relational links between User Profile and company ID (Db2 rows containing pairings of User Profile with authorized company ID).

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 for a given table aren’t available. 

There were 3 other tracks of presentations.  Pete Massiello talked 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, did several sessions, which 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.  Omni event organizers were very pleased to be able to have Barbara present several sessions from remote. A special request was a session recapping many of the new RPG Free features that have been brought to fruition since IBM i 7.1 (a big leap forward), and another focused on new support for handling null values in RPG (along with some candid insights) and more. 

Learning is Rewarding!

Rex Smith presents on 05/08/17 at COMMON 2017 Annual Meeting and Exhibition...   (Show Details...)   

COMMON's largest event in 2017 ran May 7-10 at Loews Sapphire Falls Resort at Universal Orlando™.  There were over 300 sessions and a lot of learning opportunities for a wide range of interests.  Rex Smith from Tegratecs presented a topic in the IFS area of study titled Securely transfer IFS extracts using native IBM i tools! on Monday May 8th at 2PM.   See the filtered view of RPG IV focused content...

WMCPA's annual conference March 14-17 2017 was great...   (Show Details...)   

WMCPA put together another excellent conference on the heels of their 2016 success.  Tegratecs was there as a corporate sponsor touting it's latest commercial quality development techniques in the areas of proactive row locking with SQL using IBM's DB2 for i data provider for .NET, providing the most deterministic results possible!

There were over 20 speakers and 50 sessions included with conference attendance, along with a keynote presented by Dr. Stefanie Chiras from IBM.  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. 

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

Tegratecs releases Create .CSV and XML licensed product on 11/16/16...   (Show Details...)   

Tegratecs Development Corp., based in Schaumburg, Illinois, has announced nationwide release of a low-cost programmer utility software product that creates .csv, xml and tab-delimited text files from DB2 for i database files.  The software runs at the command level on the IBM i OS and has been used by Tegratecs in various projects since 1999 (so it is battle-tested).  The XML features, among others however, are rather new.  Also new with the Version 2.1 release, trial evaluation has become super easy.  Basically a developer can download a full functioning trial version of the product without obligation or having to register, obtain a 7 day extension code online and install it and have it running within about 30 minutes without talking to a sales person. 

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

Create .CSV and XML IBM i *cmd licenses on a yearly subscription basis for $95 per year per serial number and partition regardless of tier or user count.

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

IBM announces IBM i 7.3! (Show Details...)   

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

Tegratecs announces licensing of the ASNA DataGate Webpak   (Show Details...)   

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 for .NET programming language (AVR) 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 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.

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
( please register or sign-in )
© 2018 Tegratecs Development Corp.