Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2015
    Posts
    31

    Unanswered: array 2 dim or temp table in memory

    Hello,
    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 ?

    thank you -

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hello,

    Have a look at Associative array data type
    Regards,
    Mark.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •