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: : 168336
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168336'
The Shares Amount is 0
The cusip is G0404A128
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = 'G0404A128'
Number of Rows :1
update current13Fpositions set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254' ,
percentOut = '0'
where entryId = '100652227'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = 'G0404A128'
Number of Rows :186
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '111661564'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '96285785'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '98129045'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '96870294'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '96877906'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '96937743'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '97011204'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '97053730'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '97076313'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '97180437'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '97190482'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '97255934'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '97386117'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '97461875'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '97836553'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '98068387'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '98085661'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '98238835'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '98239358'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '98469138'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '97183244'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '97283566'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '97769089'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '97830786'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '97831275'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '97836980'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '97867602'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '97874134'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '97891657'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '97930119'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '97930615'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '97931546'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '97939353'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '97943515'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '97967528'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '97996468'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '97997640'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '98017035'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '98046657'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '98050858'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '98051171'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '98058341'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '98061821'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '98069417'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '98086327'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '98087163'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '98117930'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '98131220'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '98203585'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '99149759'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '99719076'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '98832187'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100658249'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100081951'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '99562210'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100124603'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100110486'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100078421'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '99525260'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100130527'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '99253023'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '99381557'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100077140'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '99476721'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '99663584'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100093354'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '99759831'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '99814597'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100587600'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100128185'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100621521'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100626261'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100626780'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100318068'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100630569'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100630905'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100632439'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100637835'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100638692'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100637606'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100639832'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100417963'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100643680'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100467515'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100646686'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100486658'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100648920'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100649632'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100650612'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100653556'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100551931'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100562565'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100654710'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '99917026'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100422817'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100468415'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '103959333'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100600223'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '103055537'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '102345170'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '102383503'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '102135665'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '102316314'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '102069564'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '102179441'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '102225710'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '102455446'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '102985397'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '102756024'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '102798686'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '103007325'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '102921285'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '102938675'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '103059393'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '103062821'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '101307542'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '100905360'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '103959633'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '104047179'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '104804578'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '104444615'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '104514447'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '104795403'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '105002272'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '105085542'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '105505928'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '105294916'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '105296921'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '105301909'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '105354213'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '105412335'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '105432402'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '105633684'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '105706627'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '105621954'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '106219686'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '106357019'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '106445888'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '106626218'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '107135967'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '107837208'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '108090997'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '108236559'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '107452406'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '107647769'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '107822741'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '107824690'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '108120448'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '107967473'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '107996982'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '108049537'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '109984545'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '107964203'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '108821991'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '110022492'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '109632020'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '110538963'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '110256222'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '109110676'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '110040456'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '110407352'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '110540647'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '110766400'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '110670091'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '110702619'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '109981561'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '110107138'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '111593787'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '112773446'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '112058285'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '111921012'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '112775702'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '113472098'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '113486647'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '113494764'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '113498043'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '114526128'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '114877674'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '114392303'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '114793121'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '115184446'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '116736408'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '117368368'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '115943372'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '118622455'
update archive13F set
compid = '168336',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001825254'
where entryId = '116747163'
End Function
The Script is complete, exiting....