• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • DB2 Connect Gets Better Support for Stored Procedures and Triggers

    May 26, 2009 Alex Woodie

    Developers who use DB2 Connect to access databases running on System i midrange systems and System z mainframes from applications running on Windows, Unix, and Linux systems will gain better support for triggers and stored procedures, among other enhancements, with the latest release of the software, version 9.7, which IBM announced last week.

    DB2 Connect is a piece of data access middleware that is used to access DB2 databases running on System i and System z servers. The software gives remote applications the capability to create, update, control, and manage DB2 databases running on host systems using a variety of structured methods, including SQL, APIs, ODBC, JDBC, ODBC, embedded SQL for Java (SQLJ), DB2 call level interface (CLI), PHP, Perl, and Ruby on Rails.

    One of the key enhancements IBM has delivered with version 9.7 is more robust support for stored procedure and trigger language. The new release brings expanded support for implicit casting, the creation of modules, new functions, and a range of new data types, the software giant says.

    The new release also brings support for SQL replication and federation with DB2 on Linux, Unix, and Windows (DB2 on LUW), with Informix Dynamic Server, and with Web services. Enhancements to DB2 pureXML, including the capability to include XML in business analytics, are also included, IBM says.

    Developers can also take advantage of alternative SQL language syntax in the new release, including alternative SQL language syntax for DELETE statements, the RID_BIT scalar function, and the FOR UPDATE clause for SELECT INTO statements, IBM says. New join methods, as well as a new scripting and command line development tool, CLPPlus, are also included in the new release.

    All of the DB2 Connect data sever clients and drivers have been enhanced, the software giant says. A new add-in for Visual Studio 2008 is also available. The middleware also works with IBM’s Optim development and administration tools.

    Security has also been enhanced with version 9.7, including improvements in separation of duties, better isolation of security and auditing, and better separation among application development groups. Rounding out security improvements are support for AES encryption, Transport Layer Security (TLS), and improved support for Secure Sockets Layer (SSL).

    DB2 Connect version 9.7 becomes available June 19. IBM offers a number of DB2 Connect products for various hosts, client devices, uses, and licensing preferences. For more information on version 9.7, see the IBM software announcement letter.

    RELATED STORY

    Application and Data Integration Between Linux and OS/400



                         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
    New Generation Software

    FREE Webinar:

    Creating Great Data for Enterprise AI

    Enterprise AI relies on many data sources and types, but every AI project needs a data quality, governance, and security plan.

    Wherever and however you want to analyze your data, adopting modern ETL and BI software like NGS-IQ is a great way to support your effort.

    Webinar: June 26, 2025

    RSVP today.

    www.ngsi.com – 800-824-1220

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    ARCAD Software:  FREE Webinar - Managing ILE Development, June 3
    Halcyon Software:  Webinar: How to Survive in IT with a reduced headcount, June 4
    looksoftware:  Why Service-Enable? Attend a FREE webinar

    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

    Profound Logic Aims to Simplify Menu Navigation with Atrium IBM Makes the Case for Power Systems SSDs

    Leave a Reply Cancel reply

Volume 9, Number 21 -- May 26, 2009
THIS ISSUE SPONSORED BY:

ProData Computer Services
PowerTech
Seagull Software
Vision Solutions
ARCAD Software

Table of Contents

  • Halcyon Revs Up U.S. Channel Effort
  • Coglin Mill Keeps Pace With BI, Data Warehousing Demands
  • CNX Updates EXTJS-Based System i Modernization Framework
  • MegaXML Looks to Drive Expense Out of EDI
  • Veryant Supports DB2/400 with COBOL-Java IDE
  • ACI Taps UC4 for Cross-Platform Job Scheduling
  • $12 Billion Bank Picks i OS Core Banking System from Jack Henry
  • DB2 Connect Gets Better Support for Stored Procedures and Triggers
  • SolarWinds Raises $150 Million in IPO
  • Speedware Joins Microsoft AS/400 Program

Content archive

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

Recent Posts

  • Public Preview For Watson Code Assistant for i Available Soon
  • COMMON Youth Movement Continues at POWERUp 2025
  • IBM Preserves Memory Investments Across Power10 And Power11
  • Eradani Uses AI For New EDI And API Service
  • Picking Apart IBM’s $150 Billion In US Manufacturing And R&D
  • FAX/400 And CICS For i Are Dead. What Will IBM Kill Next?
  • Fresche Overhauls X-Analysis With Web UI, AI Smarts
  • Is It Time To Add The Rust Programming Language To IBM i?
  • Is IBM Going To Raise Prices On Power10 Expert Care?
  • IBM i PTF Guide, Volume 27, Number 20

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