• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Raz-Lee Claims Technological Edge with IBM i Encryption

    July 20, 2016 Alex Woodie

    IBM i shops that are on the hunt for an encryption solution to protect their sensitive data may want to check out the latest from Raz-Lee Security. The New York-based software company recently announced that it’s leveraging IBM‘s FieldProc technology to deliver field-level encryption that’s unlike anything else on the IBM i market. The company also announced a new PGP encryption solution.

    Raz-Lee wasn’t the first IBM i security software provider to first to use the FieldProc, which can greatly simplify the process of adding encryption and decryption capabilities to a DB2 for i database, up to the

    … Read more
  • IBM Patches 13 Security Vulnerabilities in IBM i JDK

    July 20, 2016 Alex Woodie

    Time to shore up your Java. Last month IBM patched 13 security vulnerabilities that impact the Java Development Kit (JDK) for IBM i versions 6.1, 7.1, 7.2, and 7.3. The flaws range from being small nuisances to severe, particularly the four flaws that earned perfect 10s on the CVSS impact scale.

    Of the 13 vulnerabilities that IBM identified in a June 27 security bulletin, all but three of them were first disclosed to the world by Oracle, which directs development of the semi open-source language and patched the problems. Big Red disclosed the existence of most of the

    … Read more
  • Blue Stack Deadline Looms for JD Edwards Shops

    July 20, 2016 Alex Woodie

    In just over two months, JD Edwards shops that run EnterpriseOne ERP software on the “Blue Stack” of IBM middleware, including DB2 and WebSphere products, will no longer be able to get technical support for those products from Oracle. Customers have had nearly six years to prepare for the September 30 deadline, but there are those who have yet to make a decision. Luckily, Blue Stack stragglers still have options available to them.

    We told you about Oracle’s decision to kill Blue Stack support just after it announced it way back at the end of 2010. It’s been

    … Read more
  • New OLAP Aggregate Functions In DB2 For i, Part 2

    July 19, 2016 Michael Sansoterra

    In my last article, I promised to tell you about four new OLAP aggregate functions: FIRST_VALUE, LAST_VALUE, nTH_VALUE and RATIO_TO_REPORT. These valuable functions can reference data from other rows in a query result set relative to the current row. This tip covers the fourth function in the list, RATIO_TO_REPORT.

    The RATIO_TO_REPORT Function

    The new RATIO_TO_REPORT function is heaven sent, as it makes it easy for developers to avoid writing an UGLY arithmetic expression to do a simple calculation common in business. RATIO_TO_REPORT simply divides a numeric column or expression value in the current row by a SUM aggregate of

    … Read more
  • Side-By-Side Lists

    July 19, 2016 Hey, Ted

    An end user has asked me to provide him a spreadsheet with two independent lists, one beside the other. Can I use SQL to satisfy his request?

    –Dennis

    Yes, you can. Dennis works for a manufacturer, and his data had to do with routing operations. I’m going to use a more common type of data to illustrate.

    Let’s say we work for a company that sells dohickeys, thingamajigs, and whatchamacallits. We offer these items in various colors, but we don’t offer all items in all colors.

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

    My previous article, A First Look at SQL Descriptors, looked at how SQL descriptors can be used in constructing and processing dynamic SQL statements. This article examines how SQL descriptors can be used in processing the information returned through a dynamic SQL statement.

    As an example, we will write a program that dynamically constructs the select clause in an SQL select statement. Traditionally, this would cause us a problem in our RPG programs since we would not be able to code the INTO clause correctly. We have

    … Read more
  • New OLAP Aggregate Functions In DB2 for i, Part 1

    July 12, 2016 Michael Sansoterra

    In my last tips about the new OLAP features in DB2 for i 7.3, I discussed the OLAP Aggregation Specification and the new LAG and LEAD OLAP functions. In this article and the next one, I continue the discussion of new OLAP features by highlighting four new OLAP aggregate functions: FIRST_VALUE, LAST_VALUE, nTH_VALUE, and RATIO_TO_REPORT. The value of these functions is that they can reference data from other rows in a query result set relative to the current row.

    The new OLAP aggregate functions differ from normal aggregate functions (such as MIN, MAX, SUM, and AVG) in that they can

    … Read more
  • Formatting Dates With SQL, Take 3

    July 12, 2016 Ted Holt

    This story contains code, which you can download here.

     

    I love it when someone improves something I’ve produced. In this case, that someone was Barry Arnold, an A-1COBOL programmer with whom I had the privilege to work once upon a time. Barry improved my FMTDATE SQL function for use in his shop. Maybe his enhancement will help you, too.

    Barry’s shop, like many others, must deal with data from many different sources, and that data is often formatted in ways that are not conducive to RPG and COBOL programming. Barry found himself having to de-edit character dates before

    … Read more
  • A Generic Character Editing Routine

    July 12, 2016 Jon Paris

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

    Recently I was asked if I knew of a way to edit character strings. For example, take a character string representing a product code such as “AX12345Q” and edit it to produce “AX-123-45 Q”. My initial reaction was to reach for an edit word, but sadly they only work for numerics, for some strange reason. I set about building a subprocedure that offered the necessary flexibility in insert characters and also added a few “defenses” against mismatched parameters.

    Before describing the code, let’s look at the prototype for

    … Read more
  • Maxava Opens Up Bidding For iFoundation Grants

    July 11, 2016 Timothy Prickett Morgan

    For the sixth year running now, high availability software maker Maxava is putting its money where its mouth is in the IBM i community and donating a big bag of cash through its Maxava iFoundation to causes that benefit the maintenance and expansion of the IBM i community.

    Maxava launched its first iFoundation grants back in April 2011, promising to pay up to $50,000, in increments of up to $2,000 a pop, to organizations in the IBM i community that could use a little extra help in fulfilling their missions. Every little bit helps, in the first year $45,000

    … Read more
  • Previous Articles Next Articles

    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