• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • IBM i PTF Guide, Volume 25, Number 4

    January 23, 2023 Doug Bidwell

    Here are some reminders to start off the IBM i PTF Guide this week.

    First, there are new releases for Access Client Solutions and the ODBC database driver. (See ACS_NAV in the Guide for the links.) The funny bit – funny odd, not funny hilarious – is that version 26 of ACS did not allow companies to create a database source for ODBC, which is serious shortcoming. Now, there is a new version 27 that will let you do it. Here is the updated software:

    Description				   Version
    IBM i Access Client Solutions (1.1.9.1)	   1.1.9.1
    ACS Windows App Pkg English (64bit)	   
    …

    Read more
  • Guru: String Manipulation Using SQL

    October 24, 2022 Mike Larsen

    Recently, I was working with an employee file where first and last name were concatenated with a comma separator. A requirement of the project was to parse the name and populate a different table where first and last name are separate columns. I won’t address the design of the employee file, but I will show how I completed the request.

    In Figure 1, I use the position string function via SQL to extract the first name.

     

     

    Figure 1. Extract first name

     

    In this example, I use the trim, substring, and posstr functions to position to the first …

    Read more
  • Guru: Regular Expressions, Part 1

    July 25, 2022 Mike Larsen

    In the first part of this series, I will show how to replace characters in a string using SQL and regular expressions. I know I can replace characters using RPG or SQL, and they work great, but there are some cases where I find using regular expressions is a bit easier.

    For the examples I’ll show, I’m using the REGEXP_REPLACE function. REGEXP_REPLACE allows me to search for a particular value within a string and replace it with another value.

    In the first example (Figure 1), I want to search a string that has both letters and digits and I want …

    Read more
  • Support For Java 7 Ending WAS 8.5 On IBM i

    July 18, 2022 Alex Woodie

    IBM i shops that are running the traditional version of WebSphere Application Server 8.5 atop a Java 7 codebase will need to upgrade to Java 8 or risk running out of support from IBM.

    At the end of July, IBM will cease to support WAS Traditional 8.5 running on JDK 7.0/7.1. Customers will need to upgrade their WAS 8.5 environments to JDK 8.0 to maintain support with IBM. IBM currently provides full support for WAS 8.5 and WAS 9.0 running on JDK 8.0. You can read more about this on the Official Support Statement for the IBM WebSphere Application Server …

    Read more
  • Let’s Celebrate The Diamond Jubilee Of COMMON Europe

    June 13, 2022 Timothy Prickett Morgan

    Europe is a collection of countries that, over centuries of commerce, cultural exchange, and war have learned to come together and create a community of common interest. And so it is not a surprise at all that COMMON Europe, which is celebrating its 60th year – it’s Diamond Jubilee – and that is something that very few organizations in the world ever attain.

    And so, as the COMMON Europe Congress gets underway today in Alicante, Spain, we wanted to offer our congratulations and celebrate that longevity and continuity. (If you have a hankering to travel this week, you can …

    Read more
  • What’s New in IBM i Services and Networking

    May 18, 2022 Alex Woodie

    As expected, IBM delivered a slew of new IBM i services with the delivery of IBM i 7.5 last week, giving IBM i professionals handle new methods for working with various components of the platform. The new releases of the operating system also brings a number of enhancements in the networking stack, which are notable for several reasons.

    The past several new releases and Technology Refreshes (TRs) have brought new IBM i services, which are SQL-based alternatives to traditional ways of accessing things on the platform like IBM i objects, system information, and other components. At this point, IBM has …

    Read more
  • IBM i PTF Guide, Volume 24, Number 17

    April 27, 2022 Doug Bidwell

    It was a pretty quiet week in PTF Land, which stands to reason given the various holidays and the Spring Break that a lot of people had last week. It probably won’t last long, so take the downtime while you have it. There is stuff you need to deal with, of course.

    One reminder: A new build for Access Client Services (ACS) 1.1.9.0 is available for download (2170).

    Here is the rundown of PTF Groups by IBM i release level since we last published:

    PTF Groups 7.4:

    • HIPERs
    • Security
    • Backup Recovery Solutions
    • TCP/IP
    • QMGTOOLS

    PTF Groups 7.3:

    • HIPERs
    • Security
    • Backup
    …

    Read more
  • IBM i PTF Guide, Volume 24, Number 16

    April 20, 2022 Doug Bidwell

    It is a new week, and there are two new security vulnerabilities in the IBM i platform. First, there is Security Bulletin: IBM WebSphere Application Server Liberty for IBM i is vulnerable to spoofing and clickjacking attacks due to swagger-ui (CVE-2018-25031, CVE-2021-46708), which you can read more about here. The IBM i PTF numbers containing the fix for the CVEs:

    IBM i Release      5770-SS1 PTF Number      PTF Download Link

    7.4                          SI78971                                https://www.ibm.com/support/pages/ptf/SI78971

    7.3                          SI78972                                https://www.ibm.com/support/pages/ptf/SI78972

    7.2                          SI78973                                https://www.ibm.com/support/pages/ptf/SI78973

    Then there is Security Bulletin: OpenSSL for IBM i is vulnerable to a denial of service due to a flaw in …

    Read more
  • IBM Ships ACS Version 1.1.9.0

    April 13, 2022 Alex Woodie

    IBM this week delivered an update to Access Client Solutions (ACS), the popular Java-based utility that many IBM i professionals use to interact with the platform. IBM is delivering several enhancements with ACS version 1.1.9.0, some of which came through the request for enhancement (RFE) process. It also defaults to opening IBM’s new Navigator for i, rather than the old one, which is susceptible to the Log4j security vulnerability.

    ACS is the universal Java-based utility that IBM unveiled 10 years ago this August to replace older Client Access products, including the ones for Windows, Linux, and Mac. The software, which …

    Read more
  • Guru: Debugging SQL Stored Procedures With ACS

    April 11, 2022 Mike Larsen

    I use Access Client Solutions (ACS) daily to help with different tasks. I’m usually running SQL scripts or working with the IFS, but recently I was asked if there was a way to debug SQL stored procedures using ACS. More specifically, they were looking for a way that a “non-IBM i” person can debug SQL stored procedures on IBM i.

    After browsing the various menus in Run SQL Scripts in ACS, I found a system debugger. I had seen the system debugger before, but never took the time to explore it further. With this new request in mind, I decided …

    Read more

Previous Articles

Content archive

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

Recent Posts

  • N2i Gains Traction Among IBM i Newbies
  • Realizing The Promise Of Cross Platform Development With VS Code
  • 2023 IBM i Predictions, Part 3
  • Four Hundred Monitor, January 25
  • Join The 2023 IBM i Marketplace Survey Webinar Tomorrow
  • It Is Time To Have A Group Chat About AI
  • 2023 IBM i Predictions, Part 2
  • Multiple Vulnerabilities Pop Up In Navigator For i
  • Participate In The 2023 IBM i Marketplace Survey Discussion
  • IBM i PTF Guide, Volume 25, Number 4

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 © 2022 IT Jungle