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: : 166852
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '166852'
The Shares Amount is 12780000
The cusip is 05465V108
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '05465V108'
Number of Rows :2
update current13Fpositions set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336' ,
percentOut = '38.55'
where entryId = '105227250'
update current13Fpositions set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336' ,
percentOut = '0'
where entryId = '130468829'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '05465V108'
Number of Rows :181
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '92553893'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '93146370'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '93209925'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '93431988'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '93464481'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '93484496'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '93492427'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '93552924'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '95271949'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '94303689'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '94862379'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '95217337'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '95656111'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '95793169'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '95820976'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '95841482'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '95982271'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '95987784'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '95906688'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '96220664'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '96878410'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '97100364'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '97938129'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '96818245'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '97895538'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '97943713'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '98000731'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '98177783'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '98556633'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '100087833'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '99253396'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '99382113'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '99637817'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '100193727'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '100322471'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '100375507'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '100418184'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '100470306'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '100471704'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '100509672'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '100170774'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '100875936'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '101053479'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '102136065'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '102180009'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '102326987'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '102547753'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '102621666'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '102669995'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '102712224'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '102751170'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '103000152'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '102784276'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '102804342'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '103008956'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '103078937'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '103005609'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '103448722'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '103615566'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '104047593'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '104952477'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '104923835'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '105002982'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '105489447'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '105103054'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '105144819'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '105190049'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '105257897'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '105265245'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '105297015'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '105301422'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '106369674'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '106563221'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '106446350'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '107370518'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '108111166'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '107782784'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '108117378'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '108189573'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '106911157'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '107161992'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '108086139'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '107596626'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '107599703'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '107663541'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '107716389'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '107738601'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '107824774'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '107828479'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '108813520'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '109516617'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '110719441'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '109408843'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '109111162'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '109636475'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '109150262'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '110206053'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '110364387'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '110386211'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '110414232'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '110447715'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '110454558'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '110469658'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '110540746'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '110544825'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '111119794'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '111939446'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '112043469'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '111921490'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '112102451'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '112181479'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '112272926'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '112349346'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '112853499'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '113454217'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '112982842'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '113045664'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '113065585'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '113100296'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '113477862'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '113153739'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '113481503'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '113214328'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '113261277'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '113487156'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '114110471'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '115436624'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '114878154'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '114756782'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '114772733'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '114743035'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '115963765'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '115233920'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '116005743'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '116023080'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '115024364'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '115219391'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '115601808'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '116017163'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '115995436'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '115115628'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '114947367'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '115971916'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '114579195'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '115141949'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '115452396'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '115472831'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '114169950'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '117336428'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '116998601'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '116384699'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '118620918'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '118640704'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '117821930'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '116880021'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '118636453'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '118549920'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '117900385'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '116493539'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '117578119'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '117800675'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '118100342'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '118598174'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '118576081'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '117703286'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '119060826'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '119578276'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '119062016'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '116603185'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '120593187'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '121388747'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '120625060'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '120705330'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '121383010'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '121408412'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '121370876'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '121385904'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '122452946'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '122335081'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '124459488'
update archive13F set
compid = '166852',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797336'
where entryId = '127857890'
End Function
The Script is complete, exiting....