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: : 168477
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168477'
The Shares Amount is 0
The cusip is 92837J203
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '92837J203'
Number of Rows :1
update current13Fpositions set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888' ,
percentOut = '0'
where entryId = '100539441'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '92837J203'
Number of Rows :160
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '98535597'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '98680071'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99504645'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99516572'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99562701'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99172218'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99421681'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99458827'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99516036'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99518000'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99525420'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99796269'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99806112'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99853051'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99996096'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100461654'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99261993'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99393845'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99425383'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99471200'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99477539'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99636374'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99664086'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99760139'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99777895'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99814925'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99892068'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99893409'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99894080'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99902913'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99957491'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100027268'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100165825'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100528379'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100587580'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99620867'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100228169'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100264416'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100266525'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100296104'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100318452'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100340951'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100347774'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100385376'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100395227'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100396712'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100399775'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100421933'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100449871'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100462616'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100464202'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100467408'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100483657'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100487176'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100495008'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100495476'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100540006'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100544081'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100552132'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100564233'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100568532'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '99917191'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100191902'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100465445'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100847644'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '100979705'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '101178462'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '101511679'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102080395'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102290578'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102067514'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102084028'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102445862'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102069108'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102345503'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102445760'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102445629'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102383946'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '103201598'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '101924381'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102145191'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102438121'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102967139'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '103006687'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102431200'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102448358'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102432318'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102445441'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102078892'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102446511'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102066836'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '101543904'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102069420'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102069548'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '101911901'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102191961'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102227073'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102440607'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102453612'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102455480'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102570317'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102981572'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102980874'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102983067'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102985332'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102995508'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102995332'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102996099'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102999963'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102762899'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '103002095'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '103003398'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102794804'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102798573'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '103008663'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '103007304'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '103011763'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '103012061'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '103013363'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '103015024'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '103105176'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '103121202'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102669735'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102989581'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102993466'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '103014584'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '103072695'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '101308124'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '102155797'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '104007319'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '104057041'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '104432773'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '104514789'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '104118304'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '104802756'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '104795324'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '104950319'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '104992643'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '105017773'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '105086818'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '105285127'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '105509134'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '105294794'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '105506061'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '105546231'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '105757537'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '104798134'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '105925072'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '107212460'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '107213502'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '107224776'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '107228565'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '108082493'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '108090890'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '108085084'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '108066036'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '108086420'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '108133093'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '108115667'
update archive13F set
compid = '168477',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001822888'
where entryId = '108336723'
End Function
The Script is complete, exiting....