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: : 168456
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168456'
The Shares Amount is 0
The cusip is 18274B205
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '18274B205'
Number of Rows :1
update current13Fpositions set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855' ,
percentOut = '0'
where entryId = '100539255'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '18274B205'
Number of Rows :273
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '98679894'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '99719153'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '98696960'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '99562287'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '99984243'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '99155793'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '99275938'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '99643917'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '99796307'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '99852999'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '100456678'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '99254312'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '99424973'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '99439331'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '99476859'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '99636179'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '99663644'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '99683886'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '99759891'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '99783588'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '99814660'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '99891067'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '99893083'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '100157938'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '100527996'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '100587308'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '99464616'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '100227850'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '100289297'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '100318136'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '100339026'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '100339802'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '100359614'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '100390503'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '100399536'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '100418629'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '100438023'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '100449508'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '100472552'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '100493616'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '100510869'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '100530594'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '100565531'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '100568344'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '100422608'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '100464742'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '100979840'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '100600269'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '103959379'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '101048425'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '101447515'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102080418'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102437323'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '103055288'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102216215'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102441488'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102345240'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '101210849'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102384015'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102383590'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '101708214'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '101924414'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102137020'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102316390'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102073089'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '101935770'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102439023'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102194813'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102382368'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '101576189'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '101526986'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102088396'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102225945'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102378093'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102416533'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102570017'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102622581'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102965027'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102985421'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102666939'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102990355'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102994539'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102734401'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102735971'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102744306'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102756792'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102777426'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '103002080'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102805136'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102822714'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '103008921'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '103009879'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102939998'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102942847'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '103121643'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102668553'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102913310'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '101307635'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '102449531'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '103604699'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '100905448'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '103915645'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '103959686'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '104114973'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '103990097'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '104048577'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '104076457'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '104790538'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '104248894'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '104441321'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '104444406'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '104514513'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '104606982'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '104609467'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '105502600'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '104204134'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '104536701'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '104807811'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '104560553'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '104992388'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '105004687'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '105488768'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '105085792'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '105493003'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '105161525'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '105214279'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '105507176'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '105301493'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '105324733'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '105382288'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '105433756'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '105437715'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '105451608'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '105544612'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '105600044'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '105706753'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '105159523'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '106095898'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '106318157'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '107131786'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '106124866'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '106219824'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '106357094'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '106393998'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '106447403'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '106466342'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '106626300'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '107051259'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '107135743'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '108074462'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '107841692'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '107867937'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '108025429'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '107193744'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '107194371'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '107572319'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '107920858'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '107957300'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '107999003'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '108085108'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '107455197'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '107471635'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '107607383'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '107647915'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '107699031'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '108105115'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '107927614'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '108002450'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '110115794'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '108260376'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '109373635'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '108822082'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '109189631'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '110022341'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '109129382'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '109985394'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '109717556'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '110439079'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '109364079'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '110087476'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '110089605'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '109632114'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '110258861'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '109112265'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '108897171'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '110085867'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '109674257'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '110047152'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '110112437'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '110869995'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '110093676'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '110252823'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '110318480'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '110371525'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '110407505'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '110545821'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '110674953'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '109592249'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '111096590'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '115937190'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '111476129'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '113515663'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '111593894'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '111940729'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '112147977'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '113357702'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '112342471'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '112045136'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '113458577'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '111922598'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '112244146'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '112418689'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '112477053'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '112478254'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '112566601'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '112983712'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '113092329'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '113142319'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '113261464'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '113265544'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '113332149'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '113348342'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '113594327'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '114208357'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '113054151'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '114526230'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '114229570'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '114879251'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '113901672'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '114026364'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '114328739'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '114394796'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '114477473'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '114551356'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '114574779'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '115838234'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '115655973'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '115738895'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '115625662'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '115766089'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '115630691'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '116122729'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '115736617'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '115420081'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '114209928'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '115995792'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '115422175'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '115857176'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '116004427'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '116029298'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '114170040'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '117356226'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '118592637'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '118640416'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '117374838'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '117373794'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '116736506'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '117371037'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '118586771'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '117367587'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '117365325'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '117391031'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '117359116'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '118536295'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '118613792'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '118577889'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '116747086'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '118580093'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '118590715'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '118569164'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '118532217'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '118565220'
update archive13F set
compid = '168456',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826855'
where entryId = '118620583'
End Function
The Script is complete, exiting....