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: : 168509
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168509'
The Shares Amount is 13250000
The cusip is 228339305
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '228339305'
Number of Rows :2
update current13Fpositions set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696' ,
percentOut = '0'
where entryId = '135548959'
update current13Fpositions set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696' ,
percentOut = '1.52'
where entryId = '127100314'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '228339305'
Number of Rows :72
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '124213754'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '126921464'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '125460676'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '124648524'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '125033930'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '126311311'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '129654992'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '125399693'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '125687270'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '125793061'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '125985191'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '126124757'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '126171345'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '126336729'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '126475465'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '126340584'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '127859245'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '129033708'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '129433604'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '129656226'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '127797297'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '127822448'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '128937947'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '128406711'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '128368915'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '128194152'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '129318137'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '128661097'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '128665950'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '128773667'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '129711817'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '128571791'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '129197369'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '127969766'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '129802390'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '131336365'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '130470196'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '130781865'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '131346276'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '132223711'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '131243369'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '130794620'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '131015794'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '131375169'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '131487022'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '132240857'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '131599707'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '132580991'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '132564429'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '131577160'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '131646942'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '131708025'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '132348653'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '132298516'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '132642757'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '132106218'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '133415845'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '132895740'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '134068325'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '135615837'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '135523919'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '135561512'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '135626080'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '135598728'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '135554673'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '135538476'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '135547073'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '136399044'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '135804690'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '135603728'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '135906882'
update archive13F set
compid = '168509',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001761696'
where entryId = '135798689'
End Function
The Script is complete, exiting....