IBM i PTF Guide, Volume 25, Number 24 Doug Bidwell

​It is one of those quiet weeks in PTF Land, which probably means next week or the week after won’t be if history is any guide. This week, we have Security Bulletin: Multiple Vulnerabilities in IBM Java SDK affect IBM WebSphere Application Server and IBM WebSphere Application Server Liberty due to April 2023 CPU. More information is available here. Below are the affected products and versions.
Affected Product(s) Version(s)
IBM WebSphere Application Server 9.0
IBM WebSphere Application Server 8.5
IBM WebSphere Application Server Liberty Continuous delivery

Here is the rundown of PTF Groups by IBM i release level since we …
The post IBM i PTF Guide, Volume 25, Number 24 appeared first on IT Jungle. Read More 

IBM i License topics

​This page has information and links on a variety of IBM i related topics, including IBM i Entitlement Transfer, backup licensing on IBM i, Service Provider topics, support topics, and more. Read More 

SQL 101: DML Recap: The Two “Flavors” of INSERT Rafael Victoria-Pereira

​No, it’s not bitter and sweet or anything like that! INSERT is a very powerful SQL statement that many people don’t take full advantage of. I’m going to explain its two ways of working—its two “flavors” if you will. Keep reading!
By Rafael Victória-Pereira
Most programmers are familiar with the INSERT SQL statement, and some (including me) prefer it to Data File Utility (DFU) because it’s reproducible, controlled, and most important, easy to track. It’s true that you can save all those spool files produced by DFU somewhere, but it’s not easy to re-input data or even reuse inputted data. With INSERT, a simple copy-paste-adjust operation is all it takes to add a second or third record that shares some similarities with the original statement. Read More 

Verified by MonsterInsights