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: : 168512
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168512'
The Shares Amount is 0
The cusip is 26886A200
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '26886A200'
Number of Rows :2
update current13Fpositions set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729' ,
percentOut = '0'
where entryId = '102682899'
update current13Fpositions set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729' ,
percentOut = '0'
where entryId = '100539284'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '26886A200'
Number of Rows :299
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '98426441'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '98927268'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99076970'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '98755406'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99330999'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99562346'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99810977'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99961482'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99968408'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99158030'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99352830'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99507137'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99515797'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99517789'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99796319'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99809301'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99819166'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99853006'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100457341'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100666850'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100755780'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99255278'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99384819'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99425030'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99470937'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99476956'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99663713'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99683939'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99739916'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99776355'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99814713'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99893986'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100424912'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100587341'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99025470'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99438335'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99852461'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '99919764'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100227889'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100266123'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100290183'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100318183'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100336887'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100339973'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100346740'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100359708'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100367128'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100384794'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100394508'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100395775'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100400638'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100419079'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100423331'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100429324'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100438067'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100445788'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100462230'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100466055'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100483586'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100486795'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100493804'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100511736'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100528570'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100539647'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100543800'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100551989'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100422631'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '103959415'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100863379'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100985838'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '101173614'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '101431074'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102064934'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '101707984'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102080410'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100873279'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102335839'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '103055316'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102069197'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '101210920'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102445813'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102383644'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '103200789'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '101952156'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102092137'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102077628'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102138053'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102316481'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '101935835'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '101514240'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '103006678'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102438768'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102194887'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102432445'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102080047'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '101529316'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '101423717'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '101709578'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '101907510'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '101946215'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102430719'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102226094'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102452151'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102440695'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102416571'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102570054'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102981708'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102623507'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102657576'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102990309'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102990886'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102996327'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102734571'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102736115'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102964361'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102757295'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '103000540'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102766011'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102777483'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102780769'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '103003337'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102797070'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '103008503'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102843867'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102874872'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '103007277'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102902371'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '103011469'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '103012117'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102971758'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102921354'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '103059832'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '103116745'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '103231599'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102668731'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102683805'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102993225'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '102914032'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '101307708'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '100905508'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '103571687'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '103898690'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '103959721'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '104115063'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105610162'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '103992451'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '104049658'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '104245138'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '104277828'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '104803887'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '104444433'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '104506057'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105112709'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105386569'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105515164'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '104204228'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '104807787'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '104560609'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '104799203'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '104992419'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105489277'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105085931'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105088477'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105116969'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105161700'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105505788'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105232864'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105507061'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105507313'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105280765'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105293085'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105297360'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105321294'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105332013'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105384821'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105412406'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105451663'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105537094'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105544850'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105600787'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105706842'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '104798730'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105291595'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '105159686'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '106134428'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '106300815'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '106511924'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '106124961'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '106219903'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '106357135'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '106396469'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '106448524'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '107228349'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '107051654'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '107135772'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '108094303'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '108107137'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '107868000'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '108130243'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '108250974'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '107572405'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '107958203'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '106542979'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '107055093'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '108085179'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '108067437'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '107573232'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '108132645'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '107607653'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '107648001'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '108098925'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '107821102'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '108116746'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '108120046'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '108120678'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '107928835'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '107967554'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '108313736'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '106294505'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '107249650'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '108281498'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '109373683'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '108771920'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '108822190'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '109189745'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '110022360'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '110810338'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '110019965'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '109985175'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '109717632'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '110718919'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '110387084'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '110537364'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '109113409'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '108879800'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '109016253'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '110112591'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '110094473'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '110732885'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '110372321'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '110407594'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '110525843'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '110624747'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '110659601'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '109592333'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '111096642'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '111485592'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '115937210'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '111476239'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '111718287'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '113515721'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '111594018'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '111923763'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '112148715'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '112374118'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '112418760'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '112548815'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '113092325'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '113251562'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '113316885'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '113349066'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '113355661'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '114208376'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '111679662'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '113054868'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '114013263'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '114526360'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '114229544'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '114880409'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '113901723'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '114026467'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '114601754'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '115619717'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '115820480'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '115656017'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '116031627'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '115766837'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '116021557'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '116193270'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '115222737'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '114209947'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '115697983'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '116063978'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '116004547'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '114170096'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '117356171'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '118592554'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '117375801'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '118622351'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '118640426'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '117388183'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '118587569'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '116736886'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '117390873'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '117359034'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '116747466'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '118569767'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '118532168'
update archive13F set
compid = '168512',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826729'
where entryId = '118600750'
End Function
The Script is complete, exiting....