• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Stored Procedure Parameter Defaults And Named Arguments In DB2 For i

    February 20, 2013 Michael Sansoterra

    Starting with IBM i 7.1 Technology Refresh 5, DB2 for i stored procedure parameters support a default value, and the CALL statement supports named arguments. (DB2 for i Group PTF Level 18 or higher provides this new functionality). These simple and related enhancements can have surprising benefits for code comprehension and code maintenance.

    Let’s look at creating a procedure with one or more parameters having a default value:

    CREATE PROCEDURE DEV.CREATE_ORDER (
    IN @CUSTOMER_ID INT,
    IN @ORDER_DATE DATE DEFAULT CURRENT_DATE,
    IN @ORDER_ID INTEGER DEFAULT (NEXT VALUE for DATALIB.ORDER_ID_SEQUENCE) ,
    IN @ORDER_SOURCE VARCHAR(10) DEFAULT 'WEB') 
    LANGUAGE SQL
    BEGIN
    …
    END
    
    …

    Read more
  • New CL String-Handling Functions

    February 20, 2013 Ted Holt

    Note: The document accompanying this article is available for download here.

    I love it when IBM enhances CL. When I hear of a new feature, my first thought is, “What can I do with this?” My mind has been spinning since Guy Vig first told me about CL’s new string-handling functions a few weeks ago. Let me tell you about these functions and some of the uses for them that have already occurred to me.

    First, here are a few facts you need to be aware of:

    • IBM delivered the new functions in two PTFs: SI49061 and SI48166.
    …

    Read more
  • Getting Short-Term Maintenance For Your Power i Machine

    February 20, 2013 Hey, Joe

    I purchased a three-year maintenance contract when I bought my Power7 machine in 2010. The contract runs out in May but I need extended maintenance through July when I’m installing a new machine and returning the old machine to the leasing company. How do I extend my hardware/software maintenance for only two months without having to buy a one-year maintenance contract?

    –Jean

    This is a fairly common situation and one that IBM provides an out for in their maintenance contracts. Here’s how you can sign a one- or multi-year maintenance contract for your existing machine and then cancel the contract

    …

    Read more

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