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: : 166808
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '166808'
The Shares Amount is 7460000
The cusip is G6463T106
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = 'G6463T106'
Number of Rows :0
End Function
Retrive Rows from Table:
select * from archive13F where cusip = 'G6463T106'
Number of Rows :74
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '92257787'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '92707170'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '93338027'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '92945589'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '93263689'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '93151356'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '93336134'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '93423743'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '93456084'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '93456840'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '93585990'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '93640910'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '94287934'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '95276993'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '95023667'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '94459863'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '94514058'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '94869463'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '95454824'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '95875540'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '95894204'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '94822715'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '94915465'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '95386513'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '95476975'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '95741232'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '95789198'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '95812520'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '95813445'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '95816541'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '95860478'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '95923260'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '96642034'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '96522972'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '96524216'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '97574688'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '96225776'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '96706088'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '97573424'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '96885499'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '97609398'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '97386232'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '97490615'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '98138999'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '98144742'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '98247593'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '97620812'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '97682406'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '98158930'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '98139686'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '98162372'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '98166190'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '98164840'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '98165119'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '97945847'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '98172689'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '97996583'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '98019832'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '98045608'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '98178918'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '98065345'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '98836764'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '98836634'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '100110565'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '100064762'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '100077919'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '100104880'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '100071732'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '100641347'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '100646358'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '100649432'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '100649163'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '100653271'
update archive13F set
compid = '166808',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001780262'
where entryId = '100618513'
End Function
The Script is complete, exiting....