August 17, 2020 Jon Paris
In my first tip on this topic I covered the automatic sizing option (*AUTO) for the new dynamic arrays. In this tip I am going to look at the second option (*VAR), which allows the programmer to directly control the capacity of the array, growing and shrinking it as required. In addition I will also briefly cover the third option (*CTDTA) which, as you may have guessed, relates to compile time arrays.
Using A Varying Length Array
Let’s start with a brief example of using a variable sized array in conjunction with SQL. This approach answers the classic question of …Read more