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

    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

  • 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