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: : 168468
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168468'
The Shares Amount is 0
The cusip is 00832E103
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '00832E103'
Number of Rows :21
update current13Fpositions set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406' ,
percentOut = '0'
where entryId = '130261519'
update current13Fpositions set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406' ,
percentOut = '0'
where entryId = '131704465'
update current13Fpositions set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406' ,
percentOut = '0'
where entryId = '131062252'
update current13Fpositions set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406' ,
percentOut = '0'
where entryId = '130169814'
update current13Fpositions set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406' ,
percentOut = '0'
where entryId = '131004802'
update current13Fpositions set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406' ,
percentOut = '0'
where entryId = '132239923'
update current13Fpositions set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406' ,
percentOut = '0'
where entryId = '131070506'
update current13Fpositions set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406' ,
percentOut = '0'
where entryId = '130809198'
update current13Fpositions set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406' ,
percentOut = '0'
where entryId = '131172925'
update current13Fpositions set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406' ,
percentOut = '0'
where entryId = '130791033'
update current13Fpositions set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406' ,
percentOut = '0'
where entryId = '131970858'
update current13Fpositions set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406' ,
percentOut = '0'
where entryId = '131871560'
update current13Fpositions set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406' ,
percentOut = '0'
where entryId = '131800886'
update current13Fpositions set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406' ,
percentOut = '0'
where entryId = '131827699'
update current13Fpositions set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406' ,
percentOut = '0'
where entryId = '130468010'
update current13Fpositions set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406' ,
percentOut = '0'
where entryId = '132549932'
update current13Fpositions set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406' ,
percentOut = '0'
where entryId = '131644560'
update current13Fpositions set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406' ,
percentOut = '0'
where entryId = '132236714'
update current13Fpositions set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406' ,
percentOut = '0'
where entryId = '132112906'
update current13Fpositions set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406' ,
percentOut = '0'
where entryId = '132105144'
update current13Fpositions set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406' ,
percentOut = '0'
where entryId = '132492331'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '00832E103'
Number of Rows :228
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '98393760'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '99035534'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '99013360'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '99510363'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '100374577'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '100451859'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '99082672'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '99233851'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '99861275'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '99252732'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '99449897'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '99563282'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '99185928'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '100302819'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '100891255'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '101309044'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '100983419'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '101294232'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '101356338'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '101356453'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '102135354'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '101185600'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '102218357'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '101094902'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '101559961'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '101723143'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '102251656'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '102458242'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '103202348'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '103045891'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '103332672'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '104265106'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '103458160'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '104824934'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '104039523'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '104046838'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '104213684'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '104284158'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '104518266'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '105525401'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '104350824'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '104518612'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '104542369'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '104833269'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '105213326'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '105307436'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '105534809'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '105708367'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '106176582'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '106438342'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '106445546'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '106550196'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '106556263'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '106634183'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '106845642'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '107011642'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '107368247'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '107628291'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '107784885'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '107833007'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '107844874'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '108012304'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '107159964'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '107258016'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '107429792'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '107451764'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '107564578'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '107724388'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '108304982'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '109980561'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '109095727'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '109437371'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '109296713'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '110124567'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '110719400'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '109921434'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '109996516'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '110725362'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '109463574'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '109430379'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '109089595'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '109110298'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '109148082'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '109637292'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '109669290'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '109672716'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '110237463'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '110341804'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '110364270'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '110749071'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '110921254'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '112598070'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '111902270'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '113438707'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '111217519'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '111865408'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '111920633'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '112102104'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '112202805'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '112220236'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '112221397'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '112680904'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '113431222'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '112927335'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '113016885'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '113045546'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '113238151'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '113268814'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '113580287'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '114733750'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '114877297'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '114304783'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '115329422'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '115354454'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '115020060'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '115174398'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '115355137'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '115219268'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '115634242'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '114829524'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '115271099'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '115581720'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '115141621'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '115451950'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '114180051'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '117821611'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '116794157'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '117436926'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '117643294'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '116764390'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '116731401'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '118687036'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '117697129'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '118612226'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '117940343'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '117847578'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '117900262'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '117984588'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '116492721'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '118284588'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '117030720'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '118099910'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '117023307'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '116089603'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '119248629'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '121031309'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '121032566'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '120311838'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '119715777'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '119923785'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '119764625'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '121124075'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '120027597'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '120704512'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '120641311'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '119674873'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '120330716'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '120762982'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '120948731'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '120829246'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '120962410'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '121348500'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '121222765'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '121515067'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '121374249'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '121632686'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '122452106'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '122329709'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '123253842'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '122435480'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '122655155'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '123248615'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '123205735'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '123423748'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '123284944'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '123650924'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '123805190'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '122874690'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '123602548'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '123949820'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '122842228'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '123561057'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '123536580'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '122968935'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '122765826'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '123816681'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '124458655'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '125457018'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '125213114'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '124904897'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '125431370'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '125685455'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '125817588'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '125858747'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '125895378'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '125947099'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '126008111'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '126123650'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '126160180'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '126282730'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '126326376'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '126335792'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '126510012'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '126519695'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '126632776'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '126949086'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '128344923'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '127857083'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '128984309'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '129675944'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '127818840'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '127841121'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '128926927'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '129819129'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '129281775'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '128793019'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '129312287'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '129269871'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '129064751'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '129182224'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '128889880'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '129309033'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '128833674'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '129683839'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '129196288'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '129619894'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '129750925'
update archive13F set
compid = '168468',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823406'
where entryId = '128665167'
End Function
The Script is complete, exiting....