What Will the Next 35 Years of IBM i Hardware Bring? IT Jungle Read More
Programmers.io Unveils Impact Analysis Tool for IBM i – IT Jungle
Programmers.io Unveils Impact Analysis Tool for IBM i IT Jungle Read More
DB2 SQL Overview II Programmers IO
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
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
