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: : 168362
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168362'
The Shares Amount is 0
The cusip is 00461L204
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '00461L204'
Number of Rows :2
update current13Fpositions set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121' ,
percentOut = '0'
where entryId = '100652223'
update current13Fpositions set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121' ,
percentOut = '0'
where entryId = '130457867'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '00461L204'
Number of Rows :215
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '96285783'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '98128892'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '96870279'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '96877394'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '96937036'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97053723'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97076301'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97180408'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97190462'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97239846'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97255918'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97277021'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97306198'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97324887'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97386093'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97836531'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97905938'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '98085646'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '98238800'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '98239346'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '98469303'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97183117'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97283570'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97386316'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97683572'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97769075'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97831265'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97836975'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97867530'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97874081'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97891641'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97896047'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97930115'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97930568'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97931473'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97939076'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97939341'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97967512'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '97995008'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '98000930'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '98017028'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '98046643'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '98050849'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '98051165'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '98058329'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '98061579'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '98069412'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '98117920'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '98131213'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '98490577'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '99149795'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '99719056'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '98832185'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '99562190'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100124686'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '99406956'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '99525254'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100130530'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100100923'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100102599'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '99252609'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '99381018'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100077074'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '99476685'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100119705'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '99663534'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '99683795'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100094594'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '99759808'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100098605'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '99814570'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100527888'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100587594'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '99716922'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100621571'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100626743'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100318054'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100630233'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100359432'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100375754'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100632447'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100394145'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100395287'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100637652'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100639685'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100639852'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100437912'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100465507'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100470933'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100486640'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100648960'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100508725'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100649643'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100650544'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100544327'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100551923'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100612564'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100468364'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100168807'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '103959322'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100600213'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100976008'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '102345147'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '102383466'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '102135224'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '102316264'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '102439069'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '102066840'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '101709762'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '102178882'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '102225643'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '102378005'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '102416846'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '102620871'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '102985392'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '102693146'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '102992260'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '102734066'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '102735697'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '102777315'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '102796454'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '103006250'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '103008961'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '103007177'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '102921275'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '103075269'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '103076095'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '103116677'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '102912043'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '102968394'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '101307521'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '100905331'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '103959621'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '104046699'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '104804462'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '104514425'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '105118689'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '104560441'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '104921289'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '105001510'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '105045411'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '105476076'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '105119882'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '105500427'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '105247207'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '105292406'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '105301929'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '105324630'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '105326447'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '105412326'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '105482378'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '105598729'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '105706594'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '105524871'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '105621927'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '105500935'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '105762921'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '106219648'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '106357003'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '106445398'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '106626189'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '107367918'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '108117210'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '107867820'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '107955712'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '108236526'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '107246036'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '107451558'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '108088301'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '107611795'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '108137999'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '108107915'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '107820468'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '108120467'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '107927421'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '108125185'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '108259946'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '109984542'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '109066557'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '110042095'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '109631990'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '110536773'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '110255409'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '109110143'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '109147772'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '109672601'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '110869519'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '110092254'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '110396182'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '110545728'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '109981586'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '111718119'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '110107106'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '111593694'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '111853800'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '113438602'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '112773401'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '112777878'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '111920472'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '112775647'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '113431239'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '113470651'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '113450227'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '113487297'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '113452392'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '114752752'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '115958709'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '114285290'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '114223558'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '116759287'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '115943345'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '119644358'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '122408330'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '124953114'
update archive13F set
compid = '168362',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001790121'
where entryId = '127814249'
End Function
The Script is complete, exiting....