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: : 168476
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168476'
The Shares Amount is 0
The cusip is 784065203
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '784065203'
Number of Rows :1
update current13Fpositions set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160' ,
percentOut = '0'
where entryId = '102682973'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '784065203'
Number of Rows :296
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '99077099'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '98697052'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '99562625'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '99811087'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '99168578'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '99458815'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '99517955'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '99525388'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '99809271'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '99820511'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '99853041'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100460577'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100666960'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '98927127'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '99260478'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '99391667'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '99425316'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '99477412'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '99562808'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '99664002'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '99777484'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '99814883'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '99902883'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '99957492'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100164063'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100425898'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100528301'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100587532'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '99025857'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '99200785'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '99465024'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100016696'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100294662'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100318396'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100336959'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100340701'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100341603'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100345442'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100347484'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100360143'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100368703'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100374878'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100385243'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100392739'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100395063'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100396471'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100399734'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100400968'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100421204'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100429449'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100449800'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100462511'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100467062'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100487078'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100488491'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100494744'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100528591'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100538665'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100540131'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100544019'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100568501'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '99917159'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100422768'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100187485'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '100985799'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '101048530'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '101954346'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '103011455'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '101667564'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102435185'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102385430'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '103055473'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102383881'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '103201370'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '101952352'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102143563'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102316862'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102426546'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '101935577'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '101514183'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102431243'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '101211837'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '101818283'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102446510'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '101540144'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '101709716'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '101709919'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '101910813'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102189705'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102226849'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102234098'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102451689'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102440775'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102378401'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102416771'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102963131'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102628082'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102642023'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102657817'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102671969'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102686118'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102990167'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102698880'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102991819'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102994862'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102996364'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102735322'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102736713'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102996127'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102759659'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102766082'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '103002154'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '103003222'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102798178'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '103007691'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102823989'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102874889'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '103007155'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102902812'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '103011846'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '103012090'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102943004'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102973340'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '103060586'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '103100221'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102669480'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102684788'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102992995'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '103072666'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '101308028'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '102154012'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '103713312'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '104594106'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105476492'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '104003495'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '104055351'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '104784222'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '104820081'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '104441821'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105284069'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '104444562'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '104529478'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105112823'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105118860'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105515081'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '104118290'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '104807814'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '104560842'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '104799141'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '104617933'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '104944851'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105014977'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105489324'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105491283'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105086621'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105088742'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105493685'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105116766'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105117043'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105496459'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105162470'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105217201'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105232967'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105276704'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105294331'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105298095'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105325085'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105383433'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105384835'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105437860'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105451897'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105538002'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105545876'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105707233'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '104547489'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105291576'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105775414'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '105160414'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '107132312'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '106010084'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '106408019'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '106454519'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '107231612'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '107135910'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '107391755'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '108094260'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '108107188'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '107803003'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '107868270'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '107948051'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '108130237'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '108251152'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '108240770'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '107572807'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '107922024'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '108248228'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '106543098'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '107055274'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '108066495'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '107466747'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '107573546'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '108132361'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '108094149'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '107608843'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '107648434'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '108098589'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '108104764'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '107822238'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '108116539'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '107928207'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '107928847'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '107967684'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '108002639'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '108154367'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '108317411'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '108261496'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '109911583'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '108822743'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '110022448'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '109976742'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '109834774'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '109985248'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '109717967'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '110719085'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '110387218'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '110538489'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '110270002'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '109119552'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '109170608'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '110521713'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '110655834'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '110114310'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '110112273'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '110871274'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '110172527'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '110732814'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '110375679'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '110408042'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '110529308'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '110545684'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '110624759'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '110766459'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '110675136'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '111440609'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '111718630'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '111594634'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '112054662'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '111929981'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '112148838'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '112375259'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '112419057'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '112839887'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '112879706'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '113092568'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '113143589'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '113437631'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '113255042'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '113265418'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '113316897'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '113340137'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '113594510'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '113057863'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '114526954'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '114886631'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '114405709'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '115620756'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '115681216'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '115977797'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '115705128'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '114903707'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '116021945'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '115630945'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '116193473'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '115222864'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '115421376'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '115697995'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '114973032'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '115857352'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '115756844'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '116004459'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '116020771'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '114223679'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '117388528'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '118587517'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '116736642'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '118572732'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '117368419'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '117389753'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '118622014'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '118577855'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '118551792'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '116747433'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '118611611'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '118590363'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '118600751'
update archive13F set
compid = '168476',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001820160'
where entryId = '118620557'
End Function
The Script is complete, exiting....