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: : 168465
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168465'
The Shares Amount is 0
The cusip is 69242M203
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '69242M203'
Number of Rows :1
update current13Fpositions set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226' ,
percentOut = '0'
where entryId = '102682957'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '69242M203'
Number of Rows :275
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '98586431'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '98426694'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99719427'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '100480265'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99504632'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '98646520'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '98867304'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99331160'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99562562'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99976466'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99166256'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99228570'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99359641'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99417403'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99458799'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99517913'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99525366'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99820179'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '100459900'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '100666931'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99259410'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99390245'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99425255'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99434708'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99477301'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99663920'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99760063'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99777258'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99814851'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99902865'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '100162987'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '100587488'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99331557'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99439023'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99717198'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '100265458'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '100336942'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '100360052'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '100394937'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '100396301'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '100399694'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '100420722'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '100438253'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '100463815'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '100466860'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '100476662'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '100494519'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '100517282'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '100578695'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '100384391'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '100422750'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '100185170'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '99877570'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '101203777'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '100863636'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '101039524'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '100800429'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '101501270'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '101439512'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '101638203'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '101708022'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102559755'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102067557'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102385414'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '103055453'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102345425'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '101211158'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102383831'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '103201264'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '101952295'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102142429'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102316759'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '101935678'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102431249'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102631851'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102079829'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '101558341'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102199830'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102066194'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '101537773'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102069439'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '101709895'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '101910103'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102188292'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102226664'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102440651'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102416730'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102990184'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102735143'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102736565'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102744527'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102759114'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102777687'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '103003749'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102797961'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102808917'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '103008381'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102849695'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102948037'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '103060414'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '103096898'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '103231902'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '103074486'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102981341'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102968280'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '101307951'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '103296991'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '102152920'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '103713176'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '103964190'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '100905793'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '103571939'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '103754444'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '103907358'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '104115351'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '104001106'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '104054186'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '104116745'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '104828571'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '104203713'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '104277867'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '104441710'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '104444547'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '104514711'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '105118836'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '105502576'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '105444392'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '104807768'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '104560799'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '104799181'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '104617916'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '104710703'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '104941921'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '105013214'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '105086473'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '105117028'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '105162292'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '105505333'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '105507111'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '105283368'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '105294091'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '105297934'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '105303627'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '105345012'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '105451853'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '105707146'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '104798068'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '105291426'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '105622237'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '105774311'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '105160246'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '105759025'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '106134721'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '106309701'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '107132198'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '105742214'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '106125273'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '106220267'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '107212339'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '106453282'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '106478062'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '106626504'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '106782724'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '107051714'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '107135891'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '107388779'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '108094264'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '107838102'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '108075351'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '107947956'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '108012294'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '108025767'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '108171898'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '108212619'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '107004770'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '108091093'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '108217553'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '108236950'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '106543074'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '107464766'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '107648334'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '108098993'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '107822014'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '108116688'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '108120569'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '108153238'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '108316647'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '108261238'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '108772228'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '108822604'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '109190090'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '109190468'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '110022440'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '109974172'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '110059129'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '110019973'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '110048528'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '110387192'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '110116747'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '110049819'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '109632336'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '110538287'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '110268123'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '110046709'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '109118297'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '108888803'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '109167750'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '109678721'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '110655848'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '110047270'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '110871037'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '110171377'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '110407941'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '110528577'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '109849595'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '109592714'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '110107494'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '111485898'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '111476591'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '111718571'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '113528454'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '111594477'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '113438664'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '112342686'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '112053211'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '113528087'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '111476902'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '111928707'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '112088914'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '112148813'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '112375053'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '112557982'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '113454018'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '113431061'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '113092157'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '113143359'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '113248683'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '113254330'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '113329153'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '113340131'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '114013406'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '114752783'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '114885364'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '114026818'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '114403859'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '114551571'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '115028867'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '115620565'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '115829648'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '115106893'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '115704733'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '115606234'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '115222838'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '115421138'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '115756838'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '116004355'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '115598749'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '114170417'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '118640651'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '117388697'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '117383335'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '118587527'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '117373668'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '117368365'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '117390947'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '117358913'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '115914586'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '118622020'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '118542345'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '118552129'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '118634653'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '116747336'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '118590657'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '118577155'
update archive13F set
compid = '168465',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001834226'
where entryId = '121337035'
End Function
The Script is complete, exiting....