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: : 168395
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168395'
The Shares Amount is 0
The cusip is 49878L208
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '49878L208'
Number of Rows :2
update current13Fpositions set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671' ,
percentOut = '0'
where entryId = '130474129'
update current13Fpositions set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671' ,
percentOut = '0'
where entryId = '100539332'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '49878L208'
Number of Rows :187
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '98497691'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '100480042'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '99334529'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '99516425'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '99562480'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '99509785'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '99805944'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '99258067'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '99311009'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '99477174'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '99636271'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '99663817'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '99891514'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '99893243'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '100528171'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '100587422'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '99717130'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '100228001'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '100292415'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '100318285'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '100394774'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '100396071'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '100420038'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '100449681'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '100462364'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '100463599'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '100466556'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '100475374'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '100486950'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '100515712'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '100557959'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '100564087'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '100568441'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '100578373'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '100422702'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '100469028'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '100181550'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '100465171'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '100830810'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '101288578'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '102290446'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '103055401'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '101211058'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '102384186'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '103201065'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '102140992'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '102316620'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '102359024'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '101509840'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '102382825'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '102078953'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '102161194'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '101701276'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '102226457'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '102378257'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '102416660'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '102977739'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '102625803'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '102985373'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '102734888'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '102736367'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '102758353'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '102783935'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '103003140'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '102794089'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '102797627'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '102807722'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '103008981'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '103007160'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '102942939'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '102947691'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '103014007'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '103060157'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '103092273'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '103121376'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '103014609'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '102968346'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '101307859'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '103805404'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '103406056'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '104115237'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '104052701'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '104096994'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '104782612'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '104804468'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '104444504'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '104807350'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '104607460'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '104609655'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '105105492'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '105444056'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '104937256'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '105489212'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '105086282'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '105162036'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '105215872'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '105260942'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '105287868'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '105293710'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '105523805'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '105510664'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '105324939'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '105437805'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '105451780'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '105707036'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '104798613'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '105160002'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '105969768'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '106125143'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '106451717'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '106782386'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '107135845'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '107384026'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '107823808'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '108025666'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '107193924'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '107194854'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '107572609'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '108236842'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '106528610'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '106903506'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '107648220'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '107699641'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '107726965'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '108109677'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '107821665'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '107927980'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '108002569'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '108999930'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '108260915'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '108474311'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '108822397'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '109189955'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '110022405'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '110199205'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '110439677'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '110039679'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '110087959'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '110089787'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '110537941'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '109116703'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '109163253'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '110047233'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '110112608'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '110870721'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '110366682'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '110407820'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '110456694'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '110545982'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '110675069'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '109849278'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '110107406'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '111428967'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '111802774'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '111718478'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '111594245'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '113527963'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '111927105'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '112739129'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '112756638'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '112775263'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '112477532'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '112764288'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '113431191'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '113048198'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '113472275'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '113450180'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '113479959'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '113487287'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '113594443'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '114752879'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '114883746'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '115206755'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '115979196'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '116044986'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '114170301'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '118407688'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '117902991'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '115914442'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '116498968'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '120710759'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '120602656'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '120588899'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '121337008'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '122458430'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '124464925'
update archive13F set
compid = '168395',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826671'
where entryId = '127863229'
End Function
The Script is complete, exiting....