To do multible compids, use the following script:
php /var/www/html_j3sg/institutions/ChangeCompidOfAllInstitutionalAfewCompaniesAtATime.php
Please note that the script mentioned above (ChangeCompidOfAllInstitutionalAfewCompaniesAtATime) only updates the current13FFilingpositions table, no archived tables.
This script actual updates 13F current table as well as both archive13F tables.
We got coming in compid: : 168560
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168560'
The Shares Amount is 0
The cusip is 66981N202
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '66981N202'
Number of Rows :2
update current13Fpositions set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967' ,
percentOut = '0'
where entryId = '100539344'
update current13Fpositions set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967' ,
percentOut = '0'
where entryId = '102682860'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '66981N202'
Number of Rows :292
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '98497357'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '98535331'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '98426242'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99077067'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '98754930'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99504596'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99562203'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99809425'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99811067'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99961523'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99517689'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99521039'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99629492'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99792236'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99796116'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99809210'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99818321'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99894700'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99953734'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100455724'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100574922'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100666796'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100755801'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '98663317'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99252835'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99320342'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99381305'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99424875'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99470813'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99476708'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99562723'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99594798'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99663841'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99739853'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99775900'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99814593'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99893945'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99902780'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100026617'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100033496'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100156157'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100245440'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100424320'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100426457'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100528958'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100587251'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99025759'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99438239'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99439017'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99717187'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99738542'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99758285'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99852368'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100201470'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100220400'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100264475'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100265966'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100287787'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100297114'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100304949'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100311387'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100312237'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100318062'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100336850'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100339511'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100341089'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100344394'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100344958'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100346219'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100359456'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100366143'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100374775'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100380070'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100384554'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100386881'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100392437'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100394175'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100395329'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100399466'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100400436'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100406549'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100417875'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100429256'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100437920'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100449159'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100449437'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100462063'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100462642'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100462873'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100466797'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100469717'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100483216'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100483630'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100486648'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100493290'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100516832'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100525616'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100527467'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100528554'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100530540'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100539507'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100543898'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100544492'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100551929'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100563893'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99778091'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '99917023'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100286998'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100407693'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100422744'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100449915'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100468394'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100184441'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100847633'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100830439'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100863173'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '100985840'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '101178442'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '101053421'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '101173590'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '101367124'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102785467'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102426103'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102069458'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102439384'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102435180'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102445922'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102077493'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103055447'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '101210750'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102445843'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102383498'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103201218'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102091858'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102092125'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '101924196'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102135469'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102316661'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102079191'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '101514191'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103006695'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102083634'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102431211'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102170423'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102448135'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102432488'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102964616'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102079941'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '101423764'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102069405'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102072470'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '101905824'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '101955737'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102089950'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102179185'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102450071'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102432599'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102452398'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102452901'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102440789'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102453671'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102455413'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102448571'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102975522'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102976073'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102981599'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102621074'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102983979'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102985029'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102984817'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102985395'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102671475'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102685552'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102988903'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102990255'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102696681'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102992345'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102991844'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102995012'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102994053'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102996665'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102995600'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102995227'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102738902'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102996162'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102998128'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102964374'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102755922'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102765974'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102777325'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102783859'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102785676'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103003182'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102793232'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102797900'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103005498'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102808673'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103006526'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102822351'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103008847'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103009194'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102856652'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103009438'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102875146'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103009801'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102962804'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103011552'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103012063'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103013347'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103058159'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103072197'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103075138'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103074610'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103076831'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103116982'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103231555'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102984487'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102668258'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102989331'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102993430'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103012909'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103014592'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103072569'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103003465'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102980935'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102968337'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '101307535'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102436072'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102146057'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103073869'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103388038'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103708887'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '104793715'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '105625385'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103713564'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103978850'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '104046962'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '104811035'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '104804156'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '104444539'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '102968588'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '103856907'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '104118306'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '104536438'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '104795402'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '104940941'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '105001924'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '105045616'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '105493947'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '105494874'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '105496752'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '105177546'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '105213389'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '105506347'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '105507198'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '105260861'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '105262395'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '105508338'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '105279074'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '105294008'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '105305252'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '105513106'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '105513916'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '105514323'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '105472155'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '105544217'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '105757869'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '104798551'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '105291526'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '105925132'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '105159250'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '105287080'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '106368543'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '107213497'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '107225688'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '108082531'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '108074571'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '108117493'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '108062636'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '108250946'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '108066578'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '108086234'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '108088469'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '108133072'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '108101628'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '108104710'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '108109689'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '108109999'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '108115305'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '108336452'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '109000246'
update archive13F set
compid = '168560',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001836967'
where entryId = '108281116'
End Function
The Script is complete, exiting....