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: : 159783
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '159783'
The Shares Amount is 9000000
The cusip is 46625HHA1
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '46625HHA1'
Number of Rows :1
update current13Fpositions set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249' ,
percentOut = '27.78'
where entryId = '49376381'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '46625HHA1'
Number of Rows :32
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '67226447'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '67246976'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '66189586'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '66586556'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '64304102'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '64444299'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '64702000'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '69212806'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '69665522'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '69912883'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '70805890'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '70908216'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '72662755'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '73741104'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '74661038'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '76534542'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '76812876'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '78404600'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '79550081'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '81002063'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '80686224'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '80935040'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '83298901'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '82620177'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '83846920'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '84437398'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '85491898'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '86289413'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '111572810'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '111574029'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '114482134'
update archive13F set
compid = '159783',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004249'
where entryId = '117371243'
End Function
The Script is complete, exiting....