My workshops at the upcoming i-UG (UK) event in November 2023Need IBM i training? Get in touch! Read More
Release Remain Software Milestone V16.0.1 – MC Press Online mcpressonline.com
MC Press Online – Technical resources and help for a wide variety of business computing issues. Specializing in technologies related to AS/400 and iSeries Read More
POWERCast: 5 Key Strategies for IBM i IFS Cybersecurity COMMON
Panelists: Alan O’Guin, Ryan Nichols, & Brady Naves, Curbstone Read More
Using the time zone UDF I created in RPG [email protected] (Simon Hutchinson)
Yesterday I showed how to create a SQL User Defined Function, UDF, to return the current timestamp for another time zone. Several people messaged me asking me how I would use this in a RPG program. Rather than answer them individually I thought would share my answer with you all. I could think of two examples of when I would use the THEIR_TIMESTAMP UDF in a RPG program: I want to retrieve the timestamp from the UDF into a RPG variable, that I can then use elsewhere in the program Use it as part of an SQL Insert statement into a DDL Table or DDS file Let me start with the first scenario: retrieving the timestamp from the UDF into RPG variables: Read more » Read More
IBM Withdraws DB2 Web Query: Software Maintenance Can’t Be Renewed or Extended
On October 10, 2023, IBM surprised many IBM i customers by announcing the immediate termination of all DB2 Web Query marketing, which covers all DB2 Web Query modules and licenses. They also said they wouldn’t offer customers software maintenance beyond each customer’s current term. Read More