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: : 168899
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168899'
The Shares Amount is 0
The cusip is 65101L203
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '65101L203'
Number of Rows :2
update current13Fpositions set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978' ,
percentOut = '0'
where entryId = '130475196'
update current13Fpositions set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978' ,
percentOut = '0'
where entryId = '132234817'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '65101L203'
Number of Rows :261
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '111661615'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '98680003'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '99077065'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '99719408'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '99562534'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '99165293'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '99416705'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '99796177'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '99809183'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100459660'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100575295'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '99258963'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '99389614'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '99425229'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '99477263'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '99663896'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '99760048'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '99814834'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100528217'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100587468'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '99025743'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '99439156'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '99717179'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100266332'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100360007'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100377920'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100387195'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100394886'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100396234'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100413664'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100420516'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100438209'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100466766'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100476271'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100486996'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100487238'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100489765'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100527637'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100530748'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100531032'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100548597'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100562883'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '99778333'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '99917124'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100469162'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100979779'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100600421'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '103959529'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100969381'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '103007370'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '101708014'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102345408'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '101211134'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102383805'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102077636'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102141958'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102316730'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '101935903'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102195127'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102964641'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '101817822'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102066156'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '101536767'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102088344'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102089869'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102187619'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102226600'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102378305'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102416707'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102981647'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102990408'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102992274'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102994098'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102735070'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102736500'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102999533'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102758890'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102777644'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102797867'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '103006143'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '103009310'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '103008053'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102875412'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '103009972'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '103009889'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102962810'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102938551'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '103072069'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '103060336'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102916496'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '103062877'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '102968398'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '101307920'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '100905770'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '103959831'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '104115320'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '104831550'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '104053687'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '104277862'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '104819846'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '104441676'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '104514691'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '104204516'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '104807883'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '104560773'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '105012413'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '105086423'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '105162209'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '105505568'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '105507118'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '105293978'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '105297856'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '105303463'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '105324992'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '105514367'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '105432674'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '105451828'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '105603362'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '105605966'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '105707114'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '105160158'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '103712232'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '107225196'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '106125236'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '106220240'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '106357267'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '106452761'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '106626481'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '107051705'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '107838001'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '107868192'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '108025735'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '107572689'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '107961117'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '107463870'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '108067374'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '107648300'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '107699856'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '107821921'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '107825625'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '107928056'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '107996940'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '108261118'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '109373842'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '110853677'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '107964255'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '108822558'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '109190048'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '110019949'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '109717872'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '110439881'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '109632308'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '110538187'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '110267237'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '109117776'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '109678183'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '110047260'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '110112524'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '110870938'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '110097231'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '110407904'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '110541698'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '110546016'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '110670354'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '109592687'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '111424367'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '111096815'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '115937314'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '111476542'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '111718543'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '113515958'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '111594431'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '112148184'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '113439080'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '112342666'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '112052509'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '111928190'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '112244958'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '112374967'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '112418974'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '113037227'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '113092237'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '113143279'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '113262278'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '113265747'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '113328963'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '113351694'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '113379746'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '114208488'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '114001795'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '114526748'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '114125947'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '114884842'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '113901895'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '114026773'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '114403015'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '114477695'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '114551553'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '115620466'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '115814033'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '115656163'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '115704560'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '114793133'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '115626428'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '115769621'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '115630441'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '115421036'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '114210056'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '115422976'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '115184883'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '116004864'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '114170381'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '116982621'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '118493256'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '116746602'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '118640670'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '116464850'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '117146606'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '117129127'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '116607692'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '117228755'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '117371013'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '116890507'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '116843991'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '117858514'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '118059498'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '117399431'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '117621249'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '116500037'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '118057730'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '118570100'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '118532501'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '118274239'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '121412913'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '119260317'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '119257351'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '120612980'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '120299554'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '120637882'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '120606037'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '120597864'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '120626416'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '120711828'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '120492543'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '121342313'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '121364796'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '121357026'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '121398269'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '121390416'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '121365942'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '122320902'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '122459527'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '123865038'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '122960490'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '124624973'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '124466019'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '126828818'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '126499786'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '128361135'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '127864300'
update archive13F set
compid = '168899',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001831978'
where entryId = '129307031'
End Function
The Script is complete, exiting....