Month: October 2023

​Thoroughly Modern: What’s New In IBM i IT Planning  IT Jungle Read More 

​IBM Releases Db2 For i Extensions For VS Code  IT Jungle Read More 

​The IBM-supplied Find String Using PDM (FNDSTRPDM) command and PDM option 25 are how most developers scan for a simple value in a list of source file members. But what if you need more? For example, what if you want to find something complex, such as the field named “CUST” but not the field named “CUSTNAME” “CUSTOMER” or “CUSTNO”? Go ahead, I’ll wait? While I do use FNDSTRPDM all the time, I now use the SQL READSRC (Read Source File Member) Table function more often. READSRC SQL UDTF The READSRC SQL Table function or UDTF (User-defined table function) uses an … The post Guru: Search Source Code For Strings Using SQL appeared first on IT Jungle. Read More 

​Here is something interesting. There is a new cume for IBM i 7.3, just after it goes out of standard support and is now on extended support. For years, we have been after IBM to put a cume out when it stops supporting a release, kind of a summation at end of life. This is the first time Big Blue has managed to do that. It is likely a coincidence, but it should have always been policy. It is difficult to round up docs and PTFs for an end of life product two years after the fact. Having a stake … The post IBM i PTF Guide, Volume 25, Number 41 appeared first on IT Jungle. Read More 

​In this example video, I’d like to show you how a physical file with data, can be converted to a SQL table without writing any code, and the programs that uses that table will work in the same way without doing anything else.
0:48 Showing you the original DDS of the physical and logical files used in the example Read More