is it possible in a stored procedure, to declare and use an array of 2 dim ?
I know that instead of this array of 2 dim, I can create a temporary table as follow ;
DECLARE GLOBAL TEMPORARY TABLE SESSION.TEMP_SAT_PERSON_PREFERENCE_GC LIKE BDV.SAT_PERSON_PREFERENCE_GC ON COMMIT DELETE ROWS NOT LOGGED WITH REPLACE ;
But if I could create this array I think it would be much quicker than a table because the array is in memory and the table not, is in disk
Or is it possible to work with a temporary table that is in memory ¿?