I wanted a centralized example of how to read multiple rows using SQL, into an RPG host variable when one of its columns was also an array. We think of reading multiple rows into a data structure as ...

ARRAY[expr1, expr2, ...] Constructs a SQL ARRAY literal from the expression arguments, using the type of the first argument as the output array type. ARRAY_LENGTH(arr) Returns length of the array ...

This library can parse pure sql file or sql string into queries array. The main use case that made me create this library was the inability of TypeOrm to run sql file. I needed to run sql file with ...