Задание 3. Объединение секций

Объедините секции с данными до 2000 (Order_2000) с секцией с данными до 2005 (Order_2005) годов, далее объедините секции с данными до 2010 (Order_2010) с секцией с данными до 2015 (Order_2015) годов.

1. Объединение секции с данными до 2000 года с секцией с данными до 2005 года:

   proutil sportsco -C partitionmanage merge table order partition Order_2000 partition Order_2005

   proenv>proutil sportsco -C partitionmanage rename partition order-4 partition Order_2010
   OpenEdge Release 12.0 as of Fri Feb 22 19:02:39 EST 2019
   BEGIN: Rename partition order-4 to partition Order_2010. (17794)
   END:   Rename partition order-4 to partition Order_2010 was successful. (17795)
   
   proenv>proutil sportsco -C partitionmanage merge table order partition Order_2000 partition Order_2005
   OpenEdge Release 12.0 as of Fri Feb 22 19:02:39 EST 2019
   BEGIN: Merge Operation For Table order
   
                Source Partition Order_2000[3]
   
                Target Partition Order_2005[16]
   
   Index CarrierOrderDateLocalIdx has been identified as the scanning index (selected).
   
   A non-unique index has been selected as the useindex index.
   Additional locking is required with the use of this index CarrierOrderDateLocalIdx.
   
   Number of Records per Transaction (recs): 100
   
   Do you want to continue (y/n)?
   y
                Partition Order_2000[3]: records removed: 22.
                Partition Order_2000[3]: has been deleted.
   
                Partition Order_2005[16]: Total records merged: 22.
   END: Merge Operation For Table order was successful.
   
   proenv>

   Обратите внимание на то, что после объединения данные были перенесены в секцию Order_2005, после чего секция Order_2000 была удалена автоматически.

2. Объединение секции с данными до 2010 года с секцией с данными до 2015 года:

   proutil sportsco -C partitionmanage merge table order partition Order_2010 partition Order_2015

   proenv>proutil sportsco -C partitionmanage merge table order partition Order_2010 partition Order_2015
   OpenEdge Release 12.0 as of Fri Feb 22 19:02:39 EST 2019
   BEGIN: Merge Operation For Table order
   
                Source Partition Order_2010[10]
   
                Target Partition Order_2015[13]
   
   Index CarrierOrderDateLocalIdx has been identified as the scanning index (selected).
   
   A non-unique index has been selected as the useindex index.
   Additional locking is required with the use of this index CarrierOrderDateLocalIdx.
   
   Number of Records per Transaction (recs): 100
   
   Do you want to continue (y/n)?
   y
                Partition Order_2010[10]: records removed: 83.
                Partition Order_2010[10]: has been deleted.
   
                Partition Order_2015[13]: Total records merged: 83.
   END: Merge Operation For Table order was successful.
   
   proenv>

Задание выполнено!