20 years ago. I was sometimes a bit of cable guy responsible for the IBM BCRS center in Sweden, where we put together new hardware configurations every week for restore tests. Hopeless romantic though..(Just met Martina that year) #ibmi

20 years ago. I was sometimes a bit of cable guy responsible for the IBM BCRS center in Sweden, where we put together new hardware configurations every week for restore tests. Hopeless romantic though..(Just met Martina that year) #ibmi pic.twitter.com/rDRMmq6WT1

– Torbjörn Appehl (@tappehl)13:42 – Dec 13, 2022

Adding and updating data in a User Index with SQL

I have only dabbled with User Indexes. My recollections of using them were of having to do everything with APIs, mapping system data types to RPG data types, etc. Well, with IBM i 7.5 and 7.4 TR6 comes a SQL procedure that makes the insertion and updating of data in the User Space very easy.

Alas, I still need to use an API, QUSCRTUI, to create the User Index I am going to using in this example.

I have created a RPG to call the API:

Read more »

Verified by MonsterInsights