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: : 168502
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168502'
The Shares Amount is 0
The cusip is 465712107
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '465712107'
Number of Rows :60
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '131401093'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '130801580'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '130767753'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '130238330'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '131373491'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '131481717'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '132107825'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '132118983'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '130837962'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '118959017'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '131339911'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '131417554'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '132534022'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '131310932'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '130497959'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '131839375'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '131161311'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '131918882'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '132309218'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '132588591'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '130828772'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '130312249'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '131629982'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '131831272'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '131698196'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '132077346'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '131089398'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '130887512'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '130635080'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '131032945'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '131965520'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '130985399'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '131714751'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '132570072'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '131434404'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '132238135'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '126784189'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '130652400'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '132224251'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '131560283'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '131352109'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '130474913'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '131079837'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '130844379'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '132591323'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '131491287'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '132242036'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '132302621'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '132054291'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '131678710'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '132002735'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '131780271'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '131812093'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '130965013'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '131347052'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '130218705'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '129956962'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '131410642'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '132502773'
update current13Fpositions set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852' ,
percentOut = '0'
where entryId = '132503266'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '465712107'
Number of Rows :214
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '112967589'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '113168030'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '114527562'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '114884583'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '114332241'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '114402647'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '114571859'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '115676847'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '115994340'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '116015148'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '114962966'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '115697615'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '115454867'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '114808926'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '114236212'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '118697368'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '117475294'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '117374625'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '116736806'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '116890117'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '117365258'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '118635299'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '117390005'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '118300128'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '117126898'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '118628668'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '116499781'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '117594870'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '118102748'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '120405197'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '120312815'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '121126855'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '121206037'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '119906711'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '120711572'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '119664572'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '120653835'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '120652807'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '120729993'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '120782729'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '121146293'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '121044434'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '119575927'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '122201496'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '122523684'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '122459258'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '122465815'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '122555154'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '124119140'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '122475961'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '122564730'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '122640314'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123447380'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '122770162'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '122712835'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123569473'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123707823'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123248725'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123848941'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123827138'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '122821693'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123824222'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '122276644'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123842201'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123346233'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '124015844'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123295914'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123329666'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '122651168'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123044753'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '122669796'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123548851'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '122143452'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123042016'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123310641'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123645454'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123509899'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '122903840'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123274775'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123609803'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123376617'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '122426485'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '122836373'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '122540592'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '122379637'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '122844973'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '122858743'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123409956'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123999620'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123500725'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '122973845'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123741105'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123810545'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123828263'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123484406'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123690927'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123790640'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '123129097'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '124193278'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '124690657'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '124478804'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126352872'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '124970323'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '124559355'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126924673'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '124465751'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '125467840'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '125129069'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '125550748'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '125105550'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '125007324'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '125040274'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126445757'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '124998616'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '124962896'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '125112478'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '125409847'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '125446786'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '125488426'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '125498872'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '125527560'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '125614074'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126840924'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '125670911'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '125751837'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126846224'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126856875'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '125811245'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '125835512'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '125861735'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '125869899'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '125944238'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126020140'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126049402'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126096269'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126774542'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126126406'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126138562'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126148632'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126189058'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126211552'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126860701'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126327818'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126337921'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126369992'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126412022'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126780355'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126428401'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126431002'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126865532'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126847028'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126581991'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126879398'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126898266'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126938447'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '126958495'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '127908287'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '127608315'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '127489628'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '129098685'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '127489010'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '127864024'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '128254051'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '127506189'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '127089359'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '127930089'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '128853504'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '127829559'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '128097038'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '128955390'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '128049625'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '127887741'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '129828543'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '129256100'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '129286642'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '128417977'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '127881469'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '131909693'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '128456162'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '128469128'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '129319320'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '129758937'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '129374651'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '129741515'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '128663990'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '129699005'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '129790763'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '129152982'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '129059044'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '129188389'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '128839900'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '128808457'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '130214115'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '129387320'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '128739748'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '129310471'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '128462088'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '128509518'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '128847174'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '128583341'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '128691857'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '129724544'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '128643541'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '128445682'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '129198996'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '128482582'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '129799653'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '129726195'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '127976584'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '127495363'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '129141264'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '129714388'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '129633014'
update archive13F set
compid = '168502',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828852'
where entryId = '128353695'
End Function
The Script is complete, exiting....