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: : 168355
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168355'
The Shares Amount is 26320000
The cusip is 89680M101
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '89680M101'
Number of Rows :56
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '244.58'
where entryId = '146331908'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '3.31'
where entryId = '147468577'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '6.25'
where entryId = '147963159'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '47.97'
where entryId = '148144158'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0'
where entryId = '148728292'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0.36'
where entryId = '148007964'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0'
where entryId = '147321601'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0.21'
where entryId = '146702786'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '211.82'
where entryId = '148088268'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '7.33'
where entryId = '147581987'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0.25'
where entryId = '145889697'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '759.88'
where entryId = '147954464'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0'
where entryId = '148745474'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0'
where entryId = '148736837'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '11.5'
where entryId = '134392648'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '236.2'
where entryId = '147783024'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '474.92'
where entryId = '148305772'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0.04'
where entryId = '148302078'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '43.92'
where entryId = '147235836'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '4.09'
where entryId = '147225214'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '2.86'
where entryId = '147529297'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '415.26'
where entryId = '148060335'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0'
where entryId = '148730939'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '28.65'
where entryId = '147867084'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0'
where entryId = '148753429'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '7.39'
where entryId = '148825319'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '8.47'
where entryId = '148123364'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '2.06'
where entryId = '147360235'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '1.15'
where entryId = '148021748'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '15.88'
where entryId = '146918713'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '21.4'
where entryId = '147399612'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '7.81'
where entryId = '148265493'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0.38'
where entryId = '147819141'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '71.77'
where entryId = '147207320'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '7.52'
where entryId = '147345803'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '11.37'
where entryId = '147247306'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0.04'
where entryId = '145876637'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '309.42'
where entryId = '148467125'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0.13'
where entryId = '146936524'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '11.49'
where entryId = '148150931'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '12.46'
where entryId = '147916367'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0.62'
where entryId = '147735900'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '15.2'
where entryId = '147954064'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0.55'
where entryId = '147330101'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '7.82'
where entryId = '147553113'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '172.89'
where entryId = '146875898'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '2.05'
where entryId = '147112283'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '1.52'
where entryId = '148339313'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0'
where entryId = '148726588'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0.24'
where entryId = '146878356'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0'
where entryId = '148712509'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0'
where entryId = '148772616'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '6.34'
where entryId = '147657791'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '8.88'
where entryId = '146963223'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '6.39'
where entryId = '147341615'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '19'
where entryId = '148482698'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '89680M101'
Number of Rows :202
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '124604186'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '126152892'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '125472929'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '125044753'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '124386482'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '125629689'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '125805957'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '126051142'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '126127846'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '128177601'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '127728333'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '129379071'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '128260760'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '127867246'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '127116533'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '127834598'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '128969462'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '129833358'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '129100806'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '128195368'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '129316219'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '127789469'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '129193652'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '129147115'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '128599549'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '129200399'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '127453869'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '127981369'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '128785504'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '129334175'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '130646514'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '130415243'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '130625795'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '130478115'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '130614077'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '131105882'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '132613379'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '132543278'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '132234948'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '130806505'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '131084582'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '130637241'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '131046710'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '130776116'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '131494480'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '132243814'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '132252204'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '132395706'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '131794341'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '132047312'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '132124211'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '132130242'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '131561798'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '132009386'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '131719572'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '132629046'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '130332822'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '131745460'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '132109212'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '133217269'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '133338334'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '133580225'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '133203447'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '133898445'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '135744064'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '133016950'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '133555931'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '134139327'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '134263920'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '135321049'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '135232591'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '134617341'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '134523478'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '134533351'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '135168613'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '135584823'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '134199194'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '135162826'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '135590498'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '135287011'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '135800285'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '134158575'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '134605805'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '136211236'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '134424555'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '134742851'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '135728791'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '135404991'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '134905392'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '134972844'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '137252029'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '136906362'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '136635184'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '138313785'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '137124628'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '138619118'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '138375863'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '138848997'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '137935077'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '138764109'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '136530996'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '137320472'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '139009188'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '138560759'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '138121125'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '136547678'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '135993124'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '138060223'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '137287529'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '138369344'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '138345426'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '136765196'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '138722102'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '138374771'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '137544049'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '138807008'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '137954540'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '137856813'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '137917367'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '138141585'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '137330789'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '138067252'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '138135457'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '138073490'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '137688955'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '137870488'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '137444067'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '138503097'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '139338694'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '141891128'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '141086995'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '140007974'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '140976133'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '141009184'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '141174834'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '140522748'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '141210043'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '142042114'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '141928478'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '141307368'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '140998922'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '141813746'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '141352572'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '141703700'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '141862364'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '142140454'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '141754530'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '141855698'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '141397665'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '140709036'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '140897283'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '140112672'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '140443167'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '141599996'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '140398556'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '141386185'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '141820901'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '141717060'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '142045155'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '142114304'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '141322336'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '142096718'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '142717522'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '143097464'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '142548841'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '142698696'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '145489632'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '143578472'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '144834304'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '143155261'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '143346373'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '143660650'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '143666613'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '143839728'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '143885252'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '143902764'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '143913376'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '143923861'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '143995270'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '144018644'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '144235360'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '144401519'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '144437338'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '144446358'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '144477066'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '144540101'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '144588410'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '145523381'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '144621335'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '144654899'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '144663241'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '144773742'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '144790740'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '144859070'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '144866431'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '144984145'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '145437849'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '145423981'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '145091018'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '145163653'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '145419670'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '145390247'
End Function
The Script is complete, exiting....