IntegrationTest/sql/CSCNoiseMatrix_payload_o2o.sql

0001 /*
0002  *  CSCNoiseMatrix_payload_o2o()
0003  *
0004  *  CSCNoiseMatrix transform/transfer
0005  *  Parameters:  last_id:  The lower bounding IOV_VALUE_ID for objects to transfer
0006  */
0007
0008 CREATE OR REPLACE PROCEDURE CSCNoiseMatrix_payload_o2o (
0009   last_id IN NUMBER
0010 )
0011 AS
0012
0013 BEGIN
0014
0015 INSERT INTO "CSCNOISEMATRIX"
0016 SELECT
0017  record_id iov_value_id,
0018  runs time
0019 FROM noisematrix@omds
0020 WHERE record_id > last_id and flag = 1
0021 ;
0022
0023 INSERT INTO "CSCNOISEMATRIX_MAP"
0024 SELECT
0025  noisematrix_map.map_index map_id,
0026  noisematrix_map.record_id iov_value_id,
0027  noisematrix_map.layer_id csc_int_id
0028 FROM noisematrix_map@omds, noisematrix@omds
0029 WHERE noisematrix_map.record_id = noisematrix.record_id
0030   AND noisematrix_map.record_id > last_id
0031   AND noisematrix.flag = 1
0032 ;
0033
0034 INSERT INTO "CSCNOISEMATRIX_DATA"
0035 SELECT
0036  noisematrix_data.vec_index vec_index,
0037  noisematrix_map.map_index map_id,
0038  noisematrix_map.record_id iov_value_id,
0039  noisematrix_data.elem33 cscmatrix_elem33,
0040  noisematrix_data.elem34 cscmatrix_elem34,
0041  noisematrix_data.elem35 cscmatrix_elem35,
0042  noisematrix_data.elem44 cscmatrix_elem44,
0043  noisematrix_data.elem45 cscmatrix_elem45,
0044  noisematrix_data.elem46 cscmatrix_elem46,
0045  noisematrix_data.elem55 cscmatrix_elem55,
0046  noisematrix_data.elem56 cscmatrix_elem56,
0047  noisematrix_data.elem57 cscmatrix_elem57,
0048  noisematrix_data.elem66 cscmatrix_elem66,
0049  noisematrix_data.elem67 cscmatrix_elem67,
0050  noisematrix_data.elem77 cscmatrix_elem77
0051 FROM noisematrix_data@omds, noisematrix_map@omds, noisematrix@omds
0052 WHERE noisematrix_data.map_id = noisematrix_map.map_id
0053   AND noisematrix_map.record_id = noisematrix.record_id
0054   AND noisematrix.record_id > last_id
0055   AND noisematrix.flag = 1
0056 ;
0057
0058 END;
0059 /
0060 show errors;