Third, and this is a big one, sub-procedures allow you to define local variables in between the B and E P-specs.
I set the ERROR_FLAG (a global variable) to ‘N’, then call the sub-procedure, and then end the program. Read More
IBM i and the Difference Between Secure and Securable
Creating a unique value across multiple partitions Simon Hutchinson
This is another case of stumbling upon something that I am likely to use in the future. As I work in a multiple partition environment I need to keep rows of data unique not only with each file but also across partitions. Using an identity column will keep the rows unique within one table, but not across the same table in different partitions.
While searching for something else I found the SQL scalar function GENERATE_UNIQUE. This creates a 13 long bit data character value that is made up of an UTC timestamp and the system serial number. This can be used for a unique value in the table as each successive row that is added has a different timestamp value.
I can how what this looks like using the following statement:
Read more » Read More
Simplify AI with Profound API Webinar Profound Logic
In a rapidly evolving business world where AI technology advances almost daily, companies should be considering ways to integrate these innovations into their workflows. Good API tooling is vital to quickly and efficiently integrate with AI tools like ChatGPT. In this webinar, Brian May, VP of Product Management, will discuss the recent explosion in AI advancements and how APIs are the key to unlocking their potential. Then, Profound Logic’s CEO, Alex Roytman, will demonstrate how to create an API over your existing database and integrate it with ChatGPT without coding! Read More
