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: : 168441
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168441'
The Shares Amount is 0
The cusip is G81355110
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = 'G81355110'
Number of Rows :2
update current13Fpositions set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553' ,
percentOut = '0'
where entryId = '102682975'
update current13Fpositions set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553' ,
percentOut = '0'
where entryId = '100539408'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = 'G81355110'
Number of Rows :243
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99719476'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '98697060'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99066027'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99331218'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99562630'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99810897'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99978428'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100600467'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99169035'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99273261'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99517960'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99525391'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99996076'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99260625'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99391901'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99425325'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99477424'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99664006'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99740022'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99760098'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99814889'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99891877'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99893346'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99894055'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99902886'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99957370'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100033554'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100164271'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100407155'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100425946'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100428826'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100453510'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100587535'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99465034'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99620823'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '99717479'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100016709'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100294821'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100308376'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100336960'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100340732'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100341615'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100347523'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100385257'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100387299'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100395075'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100396493'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100399740'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100421292'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100462522'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100462743'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100467766'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100487089'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100494764'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100495455'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100568505'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100569725'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100422919'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100167680'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '103959574'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '101048539'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '101441594'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '101708035'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102451490'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102439378'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102084030'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102385432'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '103055650'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102345464'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '101211243'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102445778'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102384308'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102383890'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '103201771'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102143709'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102316872'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '101935787'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102967071'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '101514286'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102195250'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102453538'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102383208'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102446380'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '101573606'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '101540593'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '101709721'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '101709922'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102189944'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102226866'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102451702'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102453139'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102416776'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102448605'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102628233'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102965008'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102671977'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102993939'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102735349'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102736733'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102744592'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102759750'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102762868'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '103003314'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102798959'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '103008231'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '103007171'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102943007'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102943759'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102973347'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '103060614'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '103100782'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102984280'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102669513'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102989536'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102993480'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '103003502'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102968452'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '101308039'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '101143070'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '102154217'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '103713298'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '100905861'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '103909515'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '103959880'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '104115451'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '104831762'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '104055515'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '104073965'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '104277879'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '104422979'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '104441833'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '104444718'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '104514753'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '104607844'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '104609783'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '105468756'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '105468845'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '105502572'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '104118285'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '104809488'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '104807839'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '104795329'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '104788430'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '104919896'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '105015282'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '105489562'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '105475989'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '105493675'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '105500151'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '105217301'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '105295176'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '105298125'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '105308834'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '105506046'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '105432747'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '105518912'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '105519076'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '105482327'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '105545919'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '105757772'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '104547881'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '105622288'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '105925175'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '105160435'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '105924791'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '106311883'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '107132325'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '106125374'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '106366110'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '106377863'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '106454690'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '107213973'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '106561356'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '106626548'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '107051739'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '107225754'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '107366437'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '107840804'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '107194056'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '107195252'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '107962505'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '108218137'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '108237022'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '108066434'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '107467093'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '107608894'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '107728429'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '107823068'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '108116874'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '108127297'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '108261517'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '109011956'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '109190203'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '109834994'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '109394900'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '110088365'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '110089927'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '110084591'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '109632379'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '110539307'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '110270335'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '109119739'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '108891032'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '109991251'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '109146351'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '109680102'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '110874084'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '110115432'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '110375815'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '110458137'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '111476706'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '111812180'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '110107568'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '112765298'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '113363488'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '112342723'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '112059177'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '111930176'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '112147300'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '112376071'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '112477923'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '112478567'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '112560215'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '112848504'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '112937778'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '113157280'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '113057998'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '115958634'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '114219753'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '114773432'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '114770926'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '114767486'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '115973908'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '115982578'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '115979306'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '116193327'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '115979177'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '115989574'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '115962877'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '116014020'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '115993216'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '115914697'
update archive13F set
compid = '168441',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826553'
where entryId = '121337055'
End Function
The Script is complete, exiting....