• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Linoma is Ready for New Automated Encryption Feature in i/OS 7.1

    April 27, 2010 Alex Woodie

    Linoma Software last week announced that its i/OS encryption software, called Crypto Complete, is now available to support the new SQL Field Procedures encryption mechanism that IBM built into i/OS 7.1. Linoma is one of only two third-party software vendors that have committed to supporting the new feature, which is expected to eliminate the need to modify application source code to enable encryption in DB2/400.

    Support for column-level encryption via the new SQL Field Procedures exit point is one of the biggest enhancements to DB2/400 with i/OS 7.1, the other being native support for XML. Industry regulations like PCI are driving a big surge in adoption of encryption technology among the System i installed base, but there have been steep barriers to entry. The new encryption capability should dramatically lower these barriers and allow many more System i shops to encrypt their data.

    Prior to this release, customers often needed to modify their application source code to enable encryption in their existing i/OS applications. Customers could do this themselves, using APIs and programming advice from IBM, but this could only be done by the most experienced programmers. Instead, many customers would use a third party like Linoma to supply the expertise, as well as algorithms and key management tools.

    But even vendors like Linoma had their hands tied to some extent under the previous encryption paradigm. If customers did not have access to source code, it put them at a decided disadvantage. Vendors like Linoma could often find ways around to enable encryption even without source code. But if the data was of numeric in nature, such as packed decimal, signed decimal and integer data types, it would require the data to be stored in a separate file. Overall it was just not as easy as it could be.

    That should all change now with the new SQL Field Procedures capability in DB2/400. IBM has supplied an API to activate the new exit point, which enables encryption and decryption routines to be called whenever data is read from, inserted into, or updated into a DB2/400 database field. Best of all, it does not require source code changes.

    Linoma says the new Field Procedures function is similar to the database trigger method it previously used to enable encryption in DB2/400, but with several benefits, including the capability to decrypt the field before it’s sent back to the application during a read operation, and the elimination of the need for separate file for numeric data.

    “We utilize database column triggers in Crypto Complete to automatically encrypt fields on prior versions of IBM i,” states Bob Luebbe, chief architect for Linoma. “With Field Procedures and our new version of Crypto Complete, data can also be automatically decrypted without having to make application changes. This is a huge benefit for customers that are running canned packages and don’t want to change their source code.”

    Linoma says it worked closely with IBM and an early beta version of i/OS 7.1 to ensure Crypto Complete works with the new column-level encryption capability. Testing confirms the new version of Crypto Complete is compatible with the new operating system, the vendor says.

    Linoma is holding a webinar on Thursday, May 13, at 11 a.m. CDT to discuss the new version of Crypto Complete. You can register for the webinar, which is called “Crypto Complete and SQL Field Procedures,” at Linoma’s Web site at www.linomasoftware.com.

    RELATED STORIES

    IBM Officially Announces i/OS 7.1

    Linoma Adds Tokenization to i/OS Encryption Tool

    Linoma Adds Features to i OS Encryption Utility

    Free Tool from Linoma Detects Credit Card, Social Security Numbers

    CDW Taps Linoma for Database Encryption

    Crypto Tool from Linoma to be Offered by Bsafe

    Automating Database Encryption Expands Linoma’s Portfolio



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    Computer Keyes

    Fax Directly from your IBM i

    KeyesFax is a full function automated IBM i fax system. Spooled files are burst by fax number and auto transmitted with overlays.  It combines both a send and receive facsimile processing system with a complete image package.

    The fax software will edit, send, receive, display, print, and track fax documents or images using any standard IBM i without additional expensive hardware, software or subscriptions.

    Computer Keyes has been developing Software Solutions since 1978!

    www.computerkeyes.com

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    RevSoft:  Enterprise solutions for data transfers, messaging and scheduling
    American Top Tools:  Can you reach total machine CPW without having to change or upgrade?
    COMMON:  Join us at the annual 2010 conference, May 3 - 6, in Orlando, Florida

    IT Jungle Store Top Book Picks

    Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
    The iSeries Express Web Implementer's Guide: List Price, $49.95
    The System i RPG & RPG IV Tutorial and Lab Exercises: List Price, $59.95
    The System i Pocket RPG & RPG IV Guide: List Price, $69.95
    The iSeries Pocket Database Guide: List Price, $59.00
    The iSeries Pocket SQL Guide: List Price, $59.00
    The iSeries Pocket Query Guide: List Price, $49.00
    The iSeries Pocket WebFacing Primer: List Price, $39.00
    Migrating to WebSphere Express for iSeries: List Price, $49.00
    Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
    Getting Started with WebSphere Express for iSeries: List Price, $49.00
    Can the AS/400 Survive IBM?: List Price, $49.00
    Chip Wars: List Price, $29.95

    Brian Kelly Takes a Run at Congress and for Congress Files in Subprocedures

    Leave a Reply Cancel reply

Volume 10, Number 16 -- April 27, 2010
THIS ISSUE SPONSORED BY:

Profound Logic Software
New Generation Software
RevSoft
Vision Solutions
RJS Software Systems

Table of Contents

  • IBM Updates Development Tools and Compilers for i/OS 7.1
  • Linoma is Ready for New Automated Encryption Feature in i/OS 7.1
  • SEQUEL 10 Brings i/OS Reporting Enhancements
  • HATS Delivers an i Server to iPhone Connection
  • Lawson Unveils Software for Running Internal Clouds
  • VAI Looks Forward to RPG Open Access
  • nuBridges Supports i/OS 7.1 with MFT and Security Offerings
  • i365 Expands Microsoft DR Solution to i/OS, Other Platforms
  • Infor to Staff 550 Workers at New Facility in India
  • Royal Caribbean Cruises the Seas with Updated JDE ‘Blue Stack’

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • With Power11, Power Systems “Go To Eleven”
  • With Subscription Price, IBM i P20 And P30 Tiers Get Bigger Bundles
  • Izzi Buys CNX, Eyes Valence Port To System Z
  • IBM i Shops “Attacking” Security Concerns, Study Shows
  • IBM i PTF Guide, Volume 27, Number 26
  • Liam Allan Shares What’s Coming Next With Code For IBM i
  • From Stable To Scalable: Visual LANSA 16 Powers IBM i Growth – Launching July 8
  • VS Code Will Be The Heart Of The Modern IBM i Platform
  • The AS/400: A 37-Year-Old Dog That Loves To Learn New Tricks
  • IBM i PTF Guide, Volume 27, Number 25

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2025 IT Jungle