Month: November 2023

​Common Iberia 2023 (English Version) Common Iberia 2023 is near to take place and I’m very excited to announce that I will be speaking there. If you want to know more, keep reading. You can find the Spanish version of this post below. Yes, Common Iberia is here and this time it will take place Read More 

​Dynamic Arrays Dynamic arrays or Varying dimension arrays were introduced to IBM i in V7R4 and this is the minimum version and release in which they can be used. When you define a varying dimension array you are defining the maximum length you want the array to be not the actual size of the array. Read More 

​Critical business assets stored in IBM i IFS files are as vulnerable to ransomware and other cyberthreats as files stored on Windows and Linux servers. Yet many organizations still haven’t deployed Anti-Ransomware and other advanced threat protection solutions on IBM i servers. How can you protect IBM i servers from ransomware and other cyberattacks? Listen to this webinar to learn how ransomware and other cyberattacks threaten IBM i servers, and how to enhance IBM i cybersecurity & protect IFS assets against cyberthreats, including: What the IFS is and why it’s so vulnerable to cyberattacks Regulatory compliance requirements covering IFS ransomware and cyber protection Implementing key strategies to secure and protect the IFS against cyberthreats Register today and discover how to strengthen IBM i cybersecurity and safeguard essential IFS assets. Read More 

​Getting Started with SQL on IBM i Bootcamp Read More 

​SQL is the standardized language for defining and manipulating data in a relational database. SQL is the recommended interface from applications into your data on IBM i. And SQL views can access and alter system services procedures, and functions on IBM i.
In short, it is imperative to know SQL.
This bootcamp defines Structured Query Language (SQL) as supported by Db2 for IBM i. It contains basic reference information for the tasks of system administration, database administration, application programming, and operation.
This bootcamp will be delivered in semi-weekly presentations, from November 6, 2023 until January 15, 2024. 
The Power of SQL on IBM i, Scott Forstie — 11/6/2023SQL DDL – Create Table – Basics, Sue Romano — 11/13/2023SELECT Statement Basics, Vern Hamberg — 11/27/2023Scalar Functions & Date/Time Calculation, Birgitta Hauser — 12/4/2023Data Manipulation, Sven Jansson — 12/11/2023Group By / Having, Mike Zaringhalam — 12/18/2023Joining Tables, Ryan Moeller — 1/8/2023 Next Steps – A Little Bit Beyond the Basics, Scott Forstie — 1/15/2024All sessions will appear on the CONTENT tab of this page at 10:00 am CT on the date indicated.  Register now and return here on the premier dates to access the content. Read More