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: : 168480
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168480'
The Shares Amount is 0
The cusip is 90138P209
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '90138P209'
Number of Rows :2
update current13Fpositions set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912' ,
percentOut = '0'
where entryId = '100539212'
update current13Fpositions set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912' ,
percentOut = '0'
where entryId = '105661749'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '90138P209'
Number of Rows :257
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '98497297'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '98927220'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '99719049'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '99562182'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '99961508'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '99993441'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '99206576'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '99406813'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '99517672'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '99796050'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '99932262'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '99995961'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100666787'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '99252513'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '99380880'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '99470801'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '99476671'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '99663542'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '99677483'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '99739842'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '99814566'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '99890870'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '99893030'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '99957487'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100155808'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100527879'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100587239'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '99203150'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '99464502'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100227768'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100264423'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100287486'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100304727'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100318047'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100338976'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100339460'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100384519'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100394135'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100395276'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100399446'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100417718'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100437906'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100449424'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100467305'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100470846'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100486632'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100493216'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100520298'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100562542'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100568307'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100569547'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100422797'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100468348'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100190616'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '99860815'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100746246'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100830413'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100600209'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '103959319'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102083341'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '101456339'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100873233'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102335756'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102084066'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '103074622'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '101549416'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '101210726'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102383963'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102383462'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '103201540'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102091861'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '101924124'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102135129'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102316272'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '101935723'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '101211828'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102432279'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102382174'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102446513'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102066309'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '101423745'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102069408'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102178748'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102225625'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102323497'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102377991'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102416454'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102475542'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102569934'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102620776'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102964982'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102985389'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102666887'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102734050'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102735679'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102996160'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102755740'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102777308'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '103002061'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102798456'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102810738'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '103008605'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102852802'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '103007162'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102938640'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102942812'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '103015173'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '103059297'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '103121061'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '103231892'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102642764'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102668203'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102993429'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102981268'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '103243472'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '101307513'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '102449739'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '100905323'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '103388012'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '103925320'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '103959618'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '104114815'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '105610071'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '104793136'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '104046596'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '104245098'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '104441186'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '104505975'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '104606773'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '104609401'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '104118281'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '104536320'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '104807838'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '104795410'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '105483378'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '104992315'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '105001331'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '105045322'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '105475949'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '105096549'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '105161158'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '105213209'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '105478297'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '105507202'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '105278886'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '105294654'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '105296827'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '105305746'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '105324612'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '105349391'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '105432379'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '105437667'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '105482428'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '105530042'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '105544141'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '105706585'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '104798139'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '105621923'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '105159187'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '106339499'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '106327981'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '107225462'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '106511888'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '106124696'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '106366050'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '106377860'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '106445284'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '107228324'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '108074545'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '107839217'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '107193671'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '107194158'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '108236520'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '108085050'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '107440093'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '107451357'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '107511183'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '108131958'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '107588457'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '107606827'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '108138112'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '108098709'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '107724278'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '107822503'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '108116501'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '108120523'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '107927401'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '108127291'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '108128765'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '108336415'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '106294421'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '108281473'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '108709789'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '109189429'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '110810313'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '110087257'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '110089521'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '110538756'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '110255213'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '109110024'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '108906495'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '109016249'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '110040596'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '110724431'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '110316591'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '110369180'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '110369936'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '110454015'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '110546116'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '111015611'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '111802848'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '110107100'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '112056622'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '111920347'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '112375534'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '112764199'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '112764329'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '112576632'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '112981933'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '113465503'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '113153191'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '113265859'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '111816268'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '113803297'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '113052734'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '114526046'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '114877014'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '114391364'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '115621031'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '115848175'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '116023740'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '116193239'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '115096276'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '115472283'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '114170561'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '116167324'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '118640778'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '117388315'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '116736783'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '117368211'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '117262447'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '115914041'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '118636449'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '116492455'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '118594930'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '118892415'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '120704246'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '120492708'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '121336913'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '120447369'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '122451837'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '123944964'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '123817642'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '124053552'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '124642235'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '126852664'
update archive13F set
compid = '168480',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822912'
where entryId = '126860366'
End Function
The Script is complete, exiting....