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: : 168491
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168491'
The Shares Amount is 0
The cusip is G1125A124
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = 'G1125A124'
Number of Rows :1
update current13Fpositions set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413' ,
percentOut = '0'
where entryId = '130469065'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = 'G1125A124'
Number of Rows :253
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '98927232'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '99719113'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '99330927'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '99562244'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '99154026'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '99349197'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '99458728'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '99481048'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '99517710'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '99525275'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '99792186'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '99796206'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100456254'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100666812'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '99253626'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '99382433'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '99424918'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '99470856'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '99476776'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '99663606'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '99739870'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '99759858'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '99775989'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '99814629'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '99891024'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '99893068'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100527942'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100587279'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '99852396'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100200975'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100266010'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100312267'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100318095'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100339673'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100346388'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100359527'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100379776'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100384645'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100394276'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100395471'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100399499'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100400504'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100418287'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100429276'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100437957'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100449472'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100467543'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100483538'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100486691'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100493470'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100522013'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100539943'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100543727'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100551947'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100563926'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100568326'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100569572'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100422831'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100166966'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '103959357'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100600247'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102064949'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100873243'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102067506'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102335787'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102077499'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '103055550'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102345202'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '101210794'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102384001'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102383544'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '101952079'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102077590'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102136302'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102438292'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '101935930'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '103006671'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102431218'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102432277'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '101688192'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102382326'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '101776643'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '101525201'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '101052490'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '101709514'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '101709788'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102088565'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102180332'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102225808'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102440810'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102378050'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102416499'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102975399'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102981531'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102985001'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102657476'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102990260'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102992434'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102996609'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102734255'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102735846'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102744262'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102756393'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102765868'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102777368'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102783868'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102798715'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '103008458'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102854602'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '103007290'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '103011798'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '103012088'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102921302'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102942829'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102943595'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '103059526'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '103079658'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '103231573'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102668425'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102683398'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102993381'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '102939081'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '101307584'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '100905407'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '103959661'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '104114906'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '103988290'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '104047842'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '104242949'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '104245108'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '104338939'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '104444625'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '104506011'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '104514478'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '104606940'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '104609455'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '105468808'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '105118716'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '105176413'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '104807844'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '104795394'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '104799221'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '104919079'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '105003388'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '105085649'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '105088371'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '105161377'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '105162861'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '105213886'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '105232831'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '105507190'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '105260872'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '105294940'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '105297055'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '105324681'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '105351687'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '105517349'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '105437696'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '105519055'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '105451572'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '105536724'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '105544437'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '105631826'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '105706688'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '104547788'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '105159388'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '106511898'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '106124797'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '106219762'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '106357062'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '107212249'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '106446616'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '107228327'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '107228596'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '107037873'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '107222132'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '107225646'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '107365598'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '108107184'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '108130233'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '107235400'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '107235263'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '108090775'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '108248400'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '108236595'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '107246030'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '107098580'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '107453740'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '108091216'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '108132560'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '107607178'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '108138068'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '108099122'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '108098614'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '107724954'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '108109686'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '107822773'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '108116640'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '108120583'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '107927542'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '108128761'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '108260152'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '109984554'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '108822026'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '109189537'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '110538995'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '110257478'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '109111438'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '109016258'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '109145525'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '110019146'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '110869804'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '110370931'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '110719230'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '110454688'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '110546209'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '109981598'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '111802880'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '111718795'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '110107174'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '111797136'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '113357082'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '112058373'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '111921769'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '112775377'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '112847498'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '113450455'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '113153877'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '113487280'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '113465698'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '114878434'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '114393499'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '114572828'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '114941525'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '115472965'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '114170657'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '118289124'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '118640530'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '117157402'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '116880479'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '115943364'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '118122374'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '116493805'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '117571912'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '119580559'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '120625552'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '120705596'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '120599598'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '121383345'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '121344456'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '122453201'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '124459731'
update archive13F set
compid = '168491',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825413'
where entryId = '127858129'
End Function
The Script is complete, exiting....