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: : 166814
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '166814'
The Shares Amount is 10780000
The cusip is 75989E106
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '75989E106'
Number of Rows :0
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '75989E106'
Number of Rows :161
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '104204816'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '105283888'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '104461365'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '105374475'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '104277410'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '104363648'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '104536392'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '104944347'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '105014479'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '105052377'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '105143605'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '105190086'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '105257987'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '105294286'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '105295755'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '105296677'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '105298049'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '105344805'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '105354714'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '105401430'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '105407087'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '105593119'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '107132869'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '106454203'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '106574288'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '106884273'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '107125812'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '107391243'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '107640673'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '107782879'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '108116214'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '107829507'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '107837464'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '107249503'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '107272805'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '107466178'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '107518403'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '108068583'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '107667744'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '107716433'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '107788207'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '107822195'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '107824564'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '107825819'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '107910243'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '107920146'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '107949166'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '107952221'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '108336988'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '108823330'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '109519851'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '109448872'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '110133186'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '109534307'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '109960182'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '109663705'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '110538451'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '110269486'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '106501912'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '109119231'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '109636572'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '109557317'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '109170101'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '109679452'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '110143646'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '110323833'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '110740475'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '110447753'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '110515146'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '110540253'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '110541928'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '110596052'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '110611044'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '110656303'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '110656800'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '111595244'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '113362847'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '112054422'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '112041975'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '111868956'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '111929656'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '112214260'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '112276195'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '112292947'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '112308868'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '112349407'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '112375220'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '112772562'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '112719660'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '112816632'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '112879036'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '112988756'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '113046527'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '113147270'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '113237971'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '113260909'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '113261024'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '113262495'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '113289942'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '113490060'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '113340669'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '113343343'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '113916450'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '114527585'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '114886310'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '114335100'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '114773246'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '114431325'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '114570451'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '115341396'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '115620729'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '116022504'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '115680434'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '115581215'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '115447085'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '115234356'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '115696642'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '115761049'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '115626662'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '115220312'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '114855694'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '114843227'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '115102968'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '115309681'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '115468070'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '115720673'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '115503403'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '115627201'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '114972345'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '115583699'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '116029800'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '115455676'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '114237616'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '118638313'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '116308597'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '117388562'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '117375139'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '116736822'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '117368936'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '118594047'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '117365398'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '118595601'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '118547940'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '117389802'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '118549981'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '118543735'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '118574512'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '118604634'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '118611750'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '118554449'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '118600204'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '116746889'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '118595943'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '118611548'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '118594933'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '117385696'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '118633899'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '118602819'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '118564866'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '118554523'
update archive13F set
compid = '166814',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001799850'
where entryId = '121411156'
End Function
The Script is complete, exiting....