126 options compress=yes sastrace = ',, d' sastraceloc = saslog nostsuffix; 127 128 4 The SAS System 06:57 Monday, June 4, 2018 129 /*==========================================================================* 130 * Step: Join A5DSZBIN.BY0005QF * 131 * Transform: Join * 132 * Description: * 133 * * 134 * Source Tables: SUBSCRIPTION_DIM - A5DSZBIN.BJ0000W9 * 135 * ciccm.SUBSCRIPTION_DIM * 136 * MASTER_CUSTOMER - CDC.MASTER_CUSTOMER A5DSZBIN.BJ0001F9 * 137 * RES_AND_APPROVAL - A5DSZBIN.BJ0001FM * 138 * CDC.RES_AND_APPROVAL * 139 * Target Table: Join - work.W5JS0I6C A5DSZBIN.CJ0001IN * 140 * * 141 * Warnings: * 142 * Table, SUBSCRIPTION_DIM, is defined as a view, it cannot have indexes or * 143 * keys. If indexes or keys are desired change the "Create as View" * 144 * setting. * 145 *==========================================================================*/ 146 147 %let transformID = %quote(A5DSZBIN.BY0005QF); 148 %let trans_rc = 0; 149 %let etls_stepStartTime = %sysfunc(datetime(), datetime20.); ACCESS ENGINE: Entering DBICON ACCESS ENGINE: CONNECTION= SHAREDREAD ORACLE: orcon() ACCESS ENGINE: Successful physical conn id 1 ACCESS ENGINE: Number of connections is 2 ACCESS ENGINE: Exiting DBICON with rc=0X00000000 150 151 /* Access the data for Oracle.CCDWP.CCM */ 152 LIBNAME ciccm ORACLE INSERTBUFF=10000 UPDATEBUFF=1000 SQL_FUNCTIONS=ALL OR_BINARY_DOUBLE=NO PATH=ccdwp 152 ! SCHEMA=ccdw_marketing USER=XXX PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ; NOTE: Libref CICCM was successfully assigned as follows: Engine: ORACLE Physical Name: ccdwp 153 %rcSet(&syslibrc); ACCESS ENGINE: Entering DBICON ACCESS ENGINE: CONNECTION= SHAREDREAD ORACLE: orcon() ACCESS ENGINE: Successful physical conn id 2 ACCESS ENGINE: Number of connections is 3 ACCESS ENGINE: Exiting DBICON with rc=0X00000000 154 155 /* Access the data for Oracle.CDC */ 156 LIBNAME CDC ORACLE READBUFF=100000 ACCESS=READONLY OR_BINARY_DOUBLE=NO PATH=CCDWP SCHEMA=CDC USER=XXX 156 ! PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ; NOTE: Libref CDC was successfully assigned as follows: Engine: ORACLE Physical Name: CCDWP 157 %rcSet(&syslibrc); 158 159 %let etls_recnt = -1; 160 /* Runtime statistics macros */ 161 %etls_setPerfInit; 162 %perfstrt(txnname=%BQUOTE(_DISARM|&transformID|&syshostname|SQLJoin), metrNam6=_DISROWCNT, metrDef6=Count32) ; MPRINT(PERFSTRT): options notes nosource nosource2 nosymbolgen nomprint nomlogic MPRINT(PERFSTRT): NOSYMBOLGEN ; MPRINT(PERFSTRT): ; MPRINT(PERFSTRT): ; 5 The SAS System 06:57 Monday, June 4, 2018 163 164 %global etls_sql_pushDown; 165 %let etls_sql_pushDown = -1; 166 option DBIDIRECTEXEC; 167 168 proc datasets lib = work nolist nowarn memtype = (data view); 169 delete W5JS0I6C; 170 quit; NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2018-06-04T06:57:40,858+02:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 13271040| _DISARM| 13271040| _DISARM| 12| _DISARM| 13| _DISARM| 32| _DISARM| 624| _DISARM| 0.010000| _DISARM| 0.021217| _DISARM| 1843707460.837623| _DISARM| 1843707460.858840| _DISARM| 0.010000| _DISARM| | _ENDDISARM NOTE: PROCEDURE DATASETS used (Total process time): real time 0.02 seconds cpu time 0.02 seconds 171 172 proc sql; 173 create table work.W5JS0I6C as 174 select 175 SUBSCRIPTION_DIM.OWNER_CUSTOMER_KEY length = 8 176 label = 'OWNER_CUSTOMER_KEY', 177 SUBSCRIPTION_DIM.SUBSCRIPTION_KEY length = 8 178 label = 'SUBSCRIPTION_KEY', 179 RES_AND_APPROVAL.COMM_SHAPE_ID length = 8 180 label = 'COMM_SHAPE_ID', 181 RES_AND_APPROVAL.RES_APP_INDICATOR_ID length = 8 182 label = 'RES_APP_INDICATOR_ID' 183 from 184 ciccm.SUBSCRIPTION_DIM as SUBSCRIPTION_DIM left join 185 CDC.MASTER_CUSTOMER as MASTER_CUSTOMER 186 on 187 ( 188 MASTER_CUSTOMER.KURT_ID = SUBSCRIPTION_DIM.USER_CUSTOMER_KEY 189 and SUBSCRIPTION_DIM.DRM_MARKET_PRODUCT_GROUP = 'Mobil Tale' 190 ) left join 191 CDC.RES_AND_APPROVAL as RES_AND_APPROVAL 192 on 193 ( 194 RES_AND_APPROVAL.MASTER_ID = MASTER_CUSTOMER.MASTER_ID 195 and RES_AND_APPROVAL.COMM_SHAPE_ID IN (3,4) 196 and RES_AND_APPROVAL.RES_APP_VALID_TO_DATE = . 197 ) 198 ; ACCESS ENGINE: Entering DBIEXST with table name being SUBSCRIPTION_DIM ACCESS ENGINE: Entering yoeopen ACCESS ENGINE: Open Mode is XO_INPUT ACCESS ENGINE: Access Mode is XO_SEQ ACCESS ENGINE: Shr flag is XHSHRREC ACCESS ENGINE: Successful SHARING existing connection id 1 ACCESS ENGINE: Entering dbiopen ORACLE: oropen() ACCESS ENGINE: Successful dbiopen, open id 0, connect id 1 ACCESS ENGINE: Exit dbiopen with rc=0X00000000 ORACLE: orqall() ACCESS ENGINE: Entering dbidsci() ORACLE: ordesci() 6 The SAS System 06:57 Monday, June 4, 2018 ORACLE: orprep() ORACLE: ornvar() ORACLE: No. of columns : 294 ORACLE: ordesca() ORACLE: ordesc() ORACLE: ordtfmt() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() 7 The SAS System 06:57 Monday, June 4, 2018 ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() 8 The SAS System 06:57 Monday, June 4, 2018 ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() 9 The SAS System 06:57 Monday, June 4, 2018 ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() 10 The SAS System 06:57 Monday, June 4, 2018 ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() 11 The SAS System 06:57 Monday, June 4, 2018 ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() 12 The SAS System 06:57 Monday, June 4, 2018 ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() 13 The SAS System 06:57 Monday, June 4, 2018 ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() 14 The SAS System 06:57 Monday, June 4, 2018 ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() 15 The SAS System 06:57 Monday, June 4, 2018 ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() 16 The SAS System 06:57 Monday, June 4, 2018 ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ACCESS ENGINE: Generated name/label pools ACCESS ENGINE: Exiting dbidsci with success ACCESS ENGINE: Exit yoeopen with SUCCESS. ACCESS ENGINE: Begin yoeinfo ACCESS ENGINE: Exit yoeinfo with SUCCESS. ACCESS ENGINE: Entering yveprjl ACCESS ENGINE: Exiting yveprjl with rc=0x00000000 ACCESS ENGINE: Entering yieobtn ACCESS ENGINE: Exit yieobtn rc=0X0041F83D ACCESS ENGINE: Begin yoeinfo ACCESS ENGINE: Exit yoeinfo with NOSUPPORT. ACCESS ENGINE: Begin yoeinfo ACCESS ENGINE: Exit yoeinfo with NOSUPPORT. ACCESS ENGINE: Entering DBIEXST with table name being MASTER_CUSTOMER ACCESS ENGINE: Entering yoeopen ACCESS ENGINE: Open Mode is XO_INPUT ACCESS ENGINE: Access Mode is XO_SEQ ACCESS ENGINE: Shr flag is XHSHRREC ACCESS ENGINE: Successful SHARING existing connection id 2 ACCESS ENGINE: Entering dbiopen ORACLE: oropen() ACCESS ENGINE: Successful dbiopen, open id 0, connect id 2 ACCESS ENGINE: Exit dbiopen with rc=0X00000000 ORACLE: orqall() ACCESS ENGINE: Entering dbidsci() ORACLE: ordesci() ORACLE: orprep() ORACLE: ornvar() ORACLE: No. of columns : 23 ORACLE: ordesca() ORACLE: ordesc() ORACLE: ordtfmt() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() 17 The SAS System 06:57 Monday, June 4, 2018 ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ACCESS ENGINE: Generated name/label pools ACCESS ENGINE: Exiting dbidsci with success ACCESS ENGINE: Exit yoeopen with SUCCESS. ACCESS ENGINE: Begin yoeinfo ACCESS ENGINE: Exit yoeinfo with SUCCESS. ACCESS ENGINE: Entering yveprjl ACCESS ENGINE: Exiting yveprjl with rc=0x00000000 ACCESS ENGINE: Entering yieobtn ACCESS ENGINE: Exit yieobtn rc=0X0041F83D ACCESS ENGINE: Begin yoeinfo ACCESS ENGINE: Exit yoeinfo with NOSUPPORT. ACCESS ENGINE: Begin yoeinfo ACCESS ENGINE: Exit yoeinfo with NOSUPPORT. ACCESS ENGINE: Entering DBIEXST with table name being RES_AND_APPROVAL ACCESS ENGINE: Entering yoeopen ACCESS ENGINE: Open Mode is XO_INPUT ACCESS ENGINE: Access Mode is XO_SEQ ACCESS ENGINE: Shr flag is XHSHRREC ACCESS ENGINE: Successful SHARING existing connection id 2 ACCESS ENGINE: Entering dbiopen ORACLE: oropen() ACCESS ENGINE: Successful dbiopen, open id 1, connect id 2 ACCESS ENGINE: Exit dbiopen with rc=0X00000000 ORACLE: orqall() 18 The SAS System 06:57 Monday, June 4, 2018 ACCESS ENGINE: Entering dbidsci() ORACLE: ordesci() ORACLE: orprep() ORACLE: ornvar() ORACLE: No. of columns : 23 ORACLE: ordesca() ORACLE: ordesc() ORACLE: ordtfmt() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ACCESS ENGINE: Generated name/label pools ACCESS ENGINE: Exiting dbidsci with success ACCESS ENGINE: Exit yoeopen with SUCCESS. ACCESS ENGINE: Begin yoeinfo 19 The SAS System 06:57 Monday, June 4, 2018 ACCESS ENGINE: Exit yoeinfo with SUCCESS. ACCESS ENGINE: Entering yveprjl ACCESS ENGINE: Exiting yveprjl with rc=0x00000000 ACCESS ENGINE: Entering yieobtn ACCESS ENGINE: Exit yieobtn rc=0X0041F83D ACCESS ENGINE: Begin yoeinfo ACCESS ENGINE: Exit yoeinfo with NOSUPPORT. ACCESS ENGINE: Begin yoeinfo ACCESS ENGINE: Exit yoeinfo with NOSUPPORT. ACCESS ENGINE: Entering yvefind, looking for KURT_ID ACCESS ENGINE: Exiting yvefind with rc=0x00000000 ACCESS ENGINE: Entering yveprjd, select variable number 2 ACCESS ENGINE: Exiting yveprjd with rc=0x00000000 ACCESS ENGINE: Entering yvefind, looking for USER_CUSTOMER_KEY ACCESS ENGINE: Exiting yvefind with rc=0x00000000 ACCESS ENGINE: Entering yveprjd, select variable number 5 ACCESS ENGINE: Exiting yveprjd with rc=0x00000000 ACCESS ENGINE: Entering yvefind, looking for DRM_MARKET_PRODUCT_GROUP ACCESS ENGINE: Exiting yvefind with rc=0x00000000 ACCESS ENGINE: Entering yveprjd, select variable number 99 ACCESS ENGINE: Exiting yveprjd with rc=0x00000000 ACCESS ENGINE: Entering yvefind, looking for MASTER_ID ACCESS ENGINE: Exiting yvefind with rc=0x00000000 ACCESS ENGINE: Entering yveprjd, select variable number 2 ACCESS ENGINE: Exiting yveprjd with rc=0x00000000 ACCESS ENGINE: Entering yvefind, looking for MASTER_ID ACCESS ENGINE: Exiting yvefind with rc=0x00000000 ACCESS ENGINE: Entering yveprjd, select variable number 1 ACCESS ENGINE: Exiting yveprjd with rc=0x00000000 ACCESS ENGINE: Entering yvefind, looking for COMM_SHAPE_ID ACCESS ENGINE: Exiting yvefind with rc=0x00000000 ACCESS ENGINE: Entering yveprjd, select variable number 6 ACCESS ENGINE: Exiting yveprjd with rc=0x00000000 ACCESS ENGINE: Entering yvefind, looking for RES_APP_VALID_TO_DATE ACCESS ENGINE: Exiting yvefind with rc=0x00000000 ACCESS ENGINE: Entering yveprjd, select variable number 14 ACCESS ENGINE: Exiting yveprjd with rc=0x00000000 ACCESS ENGINE: Entering yvefind, looking for OWNER_CUSTOMER_KEY ACCESS ENGINE: Exiting yvefind with rc=0x00000000 ACCESS ENGINE: Entering yveprjd, select variable number 3 ACCESS ENGINE: Exiting yveprjd with rc=0x00000000 ACCESS ENGINE: Entering yvefind, looking for SUBSCRIPTION_KEY ACCESS ENGINE: Exiting yvefind with rc=0x00000000 ACCESS ENGINE: Entering yveprjd, select variable number 1 ACCESS ENGINE: Exiting yveprjd with rc=0x00000000 ACCESS ENGINE: Entering yvefind, looking for COMM_SHAPE_ID ACCESS ENGINE: Exiting yvefind with rc=0x00000000 ACCESS ENGINE: Entering yvefind, looking for RES_APP_INDICATOR_ID ACCESS ENGINE: Exiting yvefind with rc=0x00000000 ACCESS ENGINE: Entering yveprjd, select variable number 3 ACCESS ENGINE: Exiting yveprjd with rc=0x00000000 ACCESS ENGINE: Entering yveprje, terminating variable projection ACCESS ENGINE: Exiting yveprje with rc=0x00000000 ACCESS ENGINE: Exiting yoepnt() current_rid=0, next_rid=1 ACCESS ENGINE: Entering yveprje, terminating variable projection ACCESS ENGINE: Exiting yveprje with rc=0x00000000 ACCESS ENGINE: Exiting yoepnt() current_rid=0, next_rid=1 ACCESS ENGINE: Entering yveprje, terminating variable projection 20 The SAS System 06:57 Monday, June 4, 2018 ACCESS ENGINE: Exiting yveprje with rc=0x00000000 ACCESS ENGINE: Exiting yoepnt() current_rid=0, next_rid=1 ACCESS ENGINE: Successful SHARING existing connection id from 1 ORACLE: ordjqtb() ACCESS ENGINE: Entering Prepare with text set to: DBMS::RowCount("", "CCDW_MARKETING", "SUBSCRIPTION_DIM") ACCESS ENGINE: Entering dbiopen ORACLE: oropen() ACCESS ENGINE: Successful dbiopen, open id 1, connect id 1 ACCESS ENGINE: Exit dbiopen with rc=0X00000000 ACCESS ENGINE: Entering DBMSquery with RowCount("", "CCDW_MARKETING", "SUBSCRIPTION_DIM") ORACLE: orgtkey() ORACLE: orRowcnt() ORACLE: orqany() ACCESS ENGINE: Exiting DBMSquery with rc=0x00000000 ACCESS ENGINE: Entering dbidsci() ORACLE: ordesci() ORACLE: orprep() ORACLE: ornvar() ORACLE: No. of columns : 4 ORACLE: ordesca() ORACLE: ordesc() ORACLE: ordtfmt() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ACCESS ENGINE: Generated name/label pools ACCESS ENGINE: Exiting dbidsci with success ACCESS ENGINE: The prepared statement has 4 variables ACCESS ENGINE: Entering describ ACCESS ENGINE: Entering ptnam ORACLE: orcolnm() ACCESS ENGINE: DBMS column name: TABLE_QUALIFIER ACCESS ENGINE: SAS variable name: TABLE_QUALIFIER ACCESS ENGINE: SAS [in]format: $ ORACLE: orcolnm() ACCESS ENGINE: DBMS column name: TABLE_OWNER ACCESS ENGINE: SAS variable name: TABLE_OWNER ACCESS ENGINE: SAS [in]format: $ ORACLE: orcolnm() ACCESS ENGINE: DBMS column name: TABLE_NAME ACCESS ENGINE: SAS variable name: TABLE_NAME ACCESS ENGINE: SAS [in]format: $ ORACLE: orcolnm() ACCESS ENGINE: DBMS column name: ROW_COUNT ACCESS ENGINE: SAS variable name: ROW_COUNT ACCESS ENGINE: SAS [in]format: ACCESS ENGINE: Exiting ptnam ACCESS ENGINE: Exiting describ with rc=0X00000000 ACCESS ENGINE: Entering fetch 21 The SAS System 06:57 Monday, June 4, 2018 ORACLE: orgbfi() ORACLE: orubuf() ORACLE: orlock() ORACLE: ThreadIO_Init, status=0, numRows=250, NumBuffers=4, simulated=0 ACCESS ENGINE: Entering destroy ORACLE: orgbft() ORACLE: orufbuf() ORACLE: ordesct() ACCESS ENGINE: Entering dbiclose ORACLE: orclose() ACCESS ENGINE: DBICLOSE open_id 1, connect_id 1 ACCESS ENGINE: Exiting dbiclos with rc=0X00000000 ACCESS ENGINE: Exit destroy with rc=0X00000000 ACCESS ENGINE: Successful SHARING existing connection id from 2 ORACLE: ordjqtb() ACCESS ENGINE: Entering Prepare with text set to: DBMS::RowCount("", "CDC", "MASTER_CUSTOMER") ACCESS ENGINE: Entering dbiopen ORACLE: oropen() ACCESS ENGINE: Successful dbiopen, open id 2, connect id 2 ACCESS ENGINE: Exit dbiopen with rc=0X00000000 ACCESS ENGINE: Entering DBMSquery with RowCount("", "CDC", "MASTER_CUSTOMER") ORACLE: orgtkey() ORACLE: orRowcnt() ORACLE: orqany() ACCESS ENGINE: Exiting DBMSquery with rc=0x00000000 ACCESS ENGINE: Entering dbidsci() ORACLE: ordesci() ORACLE: orprep() ORACLE: ornvar() ORACLE: No. of columns : 4 ORACLE: ordesca() ORACLE: ordesc() ORACLE: ordtfmt() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ACCESS ENGINE: Generated name/label pools ACCESS ENGINE: Exiting dbidsci with success ACCESS ENGINE: The prepared statement has 4 variables ACCESS ENGINE: Entering describ ACCESS ENGINE: Entering ptnam ORACLE: orcolnm() ACCESS ENGINE: DBMS column name: TABLE_QUALIFIER ACCESS ENGINE: SAS variable name: TABLE_QUALIFIER ACCESS ENGINE: SAS [in]format: $ ORACLE: orcolnm() ACCESS ENGINE: DBMS column name: TABLE_OWNER ACCESS ENGINE: SAS variable name: TABLE_OWNER ACCESS ENGINE: SAS [in]format: $ ORACLE: orcolnm() 22 The SAS System 06:57 Monday, June 4, 2018 ACCESS ENGINE: DBMS column name: TABLE_NAME ACCESS ENGINE: SAS variable name: TABLE_NAME ACCESS ENGINE: SAS [in]format: $ ORACLE: orcolnm() ACCESS ENGINE: DBMS column name: ROW_COUNT ACCESS ENGINE: SAS variable name: ROW_COUNT ACCESS ENGINE: SAS [in]format: ACCESS ENGINE: Exiting ptnam ACCESS ENGINE: Exiting describ with rc=0X00000000 ACCESS ENGINE: Entering fetch ORACLE: orgbfi() ORACLE: orubuf() ORACLE: orlock() ORACLE: ThreadIO_Init, status=0, numRows=100000, NumBuffers=4, simulated=0 ACCESS ENGINE: Exiting fetch with rc=0X00000000 ACCESS ENGINE: Entering destroy ORACLE: orgbft() ORACLE: orufbuf() ORACLE: ordesct() ACCESS ENGINE: Entering dbiclose ORACLE: orclose() ACCESS ENGINE: DBICLOSE open_id 2, connect_id 2 ACCESS ENGINE: Exiting dbiclos with rc=0X00000000 ACCESS ENGINE: Exit destroy with rc=0X00000000 ACCESS ENGINE: Successful SHARING existing connection id from 2 ORACLE: ordjqtb() ACCESS ENGINE: Entering Prepare with text set to: DBMS::RowCount("", "CDC", "RES_AND_APPROVAL") ACCESS ENGINE: Entering dbiopen ORACLE: oropen() ACCESS ENGINE: Successful dbiopen, open id 2, connect id 2 ACCESS ENGINE: Exit dbiopen with rc=0X00000000 ACCESS ENGINE: Entering DBMSquery with RowCount("", "CDC", "RES_AND_APPROVAL") ORACLE: orgtkey() ORACLE: orRowcnt() ORACLE: orqany() ACCESS ENGINE: Exiting DBMSquery with rc=0x00000000 ACCESS ENGINE: Entering dbidsci() ORACLE: ordesci() ORACLE: orprep() ORACLE: ornvar() ORACLE: No. of columns : 4 ORACLE: ordesca() ORACLE: ordesc() ORACLE: ordtfmt() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ORACLE: orcolnm() ACCESS ENGINE: Generated name/label pools ACCESS ENGINE: Exiting dbidsci with success ACCESS ENGINE: The prepared statement has 4 variables ACCESS ENGINE: Entering describ ACCESS ENGINE: Entering ptnam 23 The SAS System 06:57 Monday, June 4, 2018 ORACLE: orcolnm() ACCESS ENGINE: DBMS column name: TABLE_QUALIFIER ACCESS ENGINE: SAS variable name: TABLE_QUALIFIER ACCESS ENGINE: SAS [in]format: $ ORACLE: orcolnm() ACCESS ENGINE: DBMS column name: TABLE_OWNER ACCESS ENGINE: SAS variable name: TABLE_OWNER ACCESS ENGINE: SAS [in]format: $ ORACLE: orcolnm() ACCESS ENGINE: DBMS column name: TABLE_NAME ACCESS ENGINE: SAS variable name: TABLE_NAME ACCESS ENGINE: SAS [in]format: $ ORACLE: orcolnm() ACCESS ENGINE: DBMS column name: ROW_COUNT ACCESS ENGINE: SAS variable name: ROW_COUNT ACCESS ENGINE: SAS [in]format: ACCESS ENGINE: Exiting ptnam ACCESS ENGINE: Exiting describ with rc=0X00000000 ACCESS ENGINE: Entering fetch ORACLE: orgbfi() ORACLE: orubuf() ORACLE: orlock() ORACLE: ThreadIO_Init, status=0, numRows=100000, NumBuffers=4, simulated=0 ACCESS ENGINE: Exiting fetch with rc=0X00000000 ACCESS ENGINE: Entering destroy ORACLE: orgbft() ORACLE: orufbuf() ORACLE: ordesct() ACCESS ENGINE: Entering dbiclose ORACLE: orclose() ACCESS ENGINE: DBICLOSE open_id 2, connect_id 2 ACCESS ENGINE: Exiting dbiclos with rc=0X00000000 ACCESS ENGINE: Exit destroy with rc=0X00000000 ACCESS ENGINE: yoeget before read, current row=0, next row=1 ORACLE: orqsub() ACCESS ENGINE: Entering dbrqsub ORACLE: orqacol() ORACLE: orqacls() ACCESS ENGINE: Exiting dbrqsub with SQL Statement set to SELECT "USER_CUSTOMER_KEY", "DRM_MARKET_PRODUCT_GROUP", "OWNER_CUSTOMER_KEY", "SUBSCRIPTION_KEY" FROM ccdw_marketing.SUBSCRIPTION_DIM ACCESS ENGINE: Entering dbidsci() ORACLE: ordesci() ORACLE: orprep() ORACLE: ornvar() ORACLE: No. of columns : 4 ORACLE: ordesca() ORACLE: ordesc() ORACLE: ordtfmt() ACCESS ENGINE: Exiting dbidsci with success ORACLE: orgbfi() ORACLE: orubuf() ORACLE: orlock() 24 The SAS System 06:57 Monday, June 4, 2018 ORACLE: ThreadIO_Init, status=0, numRows=367, NumBuffers=4, simulated=0 ACCESS ENGINE: yoeget read from next>=cur, current =0, next=1 ACCESS ENGINE: yoeget: current row id=1, next row id=2 ACCESS ENGINE: yoeget before read, current row=0, next row=1 ORACLE: orqsub() ACCESS ENGINE: Entering dbrqsub ORACLE: orqacol() ORACLE: orqacls() ACCESS ENGINE: Exiting dbrqsub with SQL Statement set to SELECT "KURT_ID", "MASTER_ID" FROM CDC.MASTER_CUSTOMER ACCESS ENGINE: Entering dbidsci() ORACLE: ordesci() ORACLE: orprep() ORACLE: ornvar() ORACLE: No. of columns : 2 ORACLE: ordesca() ORACLE: ordesc() ORACLE: ordtfmt() ACCESS ENGINE: Exiting dbidsci with success ORACLE: orgbfi() ORACLE: orubuf() ORACLE: orlock() ORACLE: ThreadIO_Init, status=0, numRows=100000, NumBuffers=4, simulated=0 ACCESS ENGINE: yoeget read from next>=cur, current =0, next=1 ACCESS ENGINE: yoeget: current row id=1, next row id=2 ORACLE: ortgnam() ORACLE: ortgnam() ORACLE: orcvnam() ORACLE: orcvdbl() ORACLE: orcvdbl() ORACLE: orcvnam() ACCESS ENGINE: Exiting yoepnt() current_rid=0, next_rid=1 ACCESS ENGINE: yoeget before read, current row=0, next row=1 ORACLE: orqsub() ACCESS ENGINE: Entering dbrqsub ORACLE: orqacol() ACCESS ENGINE: Add PROC where clause of ( ( ("COMM_SHAPE_ID" IN ( 3 , 4 ) ) ) AND ("RES_APP_VALID_TO_DATE" IS NULL ) ) ORACLE: orqacls() ACCESS ENGINE: Exiting dbrqsub with SQL Statement set to SELECT "MASTER_ID", "COMM_SHAPE_ID", "RES_APP_VALID_TO_DATE", "RES_APP_INDICATOR_ID" FROM CDC.RES_AND_APPROVAL WHERE ( ( ("COMM_SHAPE_ID" IN ( 3 , 4 ) ) ) AND ("RES_APP_VALID_TO_DATE" IS NULL ) ) ACCESS ENGINE: Entering dbidsci() ORACLE: ordesci() ORACLE: orprep() ORACLE: ornvar() ORACLE: No. of columns : 4 ORACLE: ordesca() ORACLE: ordesc() ORACLE: ordtfmt() ACCESS ENGINE: Exiting dbidsci with success ORACLE: orgbfi() ORACLE: orubuf() ORACLE: orlock() ORACLE: ThreadIO_Init, status=0, numRows=100000, NumBuffers=4, simulated=0 ACCESS ENGINE: yoeget read from next>=cur, current =0, next=1 ACCESS ENGINE: yoeget: current row id=1, next row id=2 25 The SAS System 06:57 Monday, June 4, 2018 ACCESS ENGINE: Enter yoeclos ORACLE: orgbft() ORACLE: orufbuf() ORACLE: ordesct() ACCESS ENGINE: Entering dbiclose ORACLE: orclose() ACCESS ENGINE: DBICLOSE open_id 0, connect_id 1 ACCESS ENGINE: Exiting dbiclos with rc=0X00000000 ACCESS ENGINE: Successful logical disconnect, id 1 ACCESS ENGINE: Exit yoeclos with rc=0x00000000 ACCESS ENGINE: Enter yoeclos ORACLE: orgbft() ORACLE: orufbuf() ORACLE: ordesct() ACCESS ENGINE: Entering dbiclose ORACLE: orclose() ACCESS ENGINE: DBICLOSE open_id 0, connect_id 2 ACCESS ENGINE: Exiting dbiclos with rc=0X00000000 ACCESS ENGINE: Successful logical disconnect, id 2 ACCESS ENGINE: Exit yoeclos with rc=0x00000000 ACCESS ENGINE: Enter yoeclos ORACLE: orgbft() ORACLE: orufbuf() ORACLE: ordesct() ACCESS ENGINE: Entering dbiclose ORACLE: orclose() ACCESS ENGINE: DBICLOSE open_id 1, connect_id 2 ACCESS ENGINE: Exiting dbiclos with rc=0X00000000 ACCESS ENGINE: Successful logical disconnect, id 2 ACCESS ENGINE: Exit yoeclos with rc=0x00000000 NOTE: Compressing data set WORK.W5JS0I6C increased size by 42.34 percent. Compressed is 159136 pages; un-compressed would require 111803 pages. NOTE: Table WORK.W5JS0I6C created, with 227853197 rows and 4 columns. 199 quit; NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2018-06-04T07:01:41,702+02:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 1127452672| _DISARM| 18522112| _DISARM| 12| _DISARM| 27| _DISARM| 22843424| _DISARM| 22844048| _DISARM| 97.530000| _DISARM| 240.842786| _DISARM| 1843707460.859646| _DISARM| 1843707701.702432| _DISARM| 87.000000| _DISARM| | _ENDDISARM NOTE: PROCEDURE SQL used (Total process time): real time 4:00.84 cpu time 1:37.53 200 201 %global etls_sql_pushDown; 202 %let etls_sql_pushDown = &sys_sql_ip_all; 203 204 %rcSet(&sqlrc); 205 206 %perfstop(metrVal6=%sysfunc(max(&etls_recnt,-1))); MPRINT(PERFSTOP): options notes nosource nosource2 nosymbolgen nomprint nomlogic NOTE: _DISARM|A5DSZBIN.BY0005QF|tns-gk-prod-grid06|SQLJoin| _DISARM| STOP| _DISARM| 2018-06-04T07:01:41,707+02:00| _DISARM| SAS_Data_Integration_Studio| _DISARM| SAS| _DISARM| -1| _DISARM| 1127452672| _DISARM| 18259968| _DISARM| 12| _DISARM| 27| _DISARM| 22843496| _DISARM| 22844088| _DISARM| 97.560000| _DISARM| 240.876471| _DISARM| 1843707460.830750| _DISARM| 1843707701.707221| _DISARM| 87.020000| _DISARM| | _ENDDISARM MPRINT(PERFSTOP): NOSYMBOLGEN ; MPRINT(PERFSTOP): ; MPRINT(PERFSTOP): ; 26 The SAS System 06:57 Monday, June 4, 2018 207 %let etls_recnt=-1; 208 209 210 211 /** Step end Join **/ 212 213