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: : 159684
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '159684'
The Shares Amount is 267580000
The cusip is 15713J104
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '15713J104'
Number of Rows :1
update current13Fpositions set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150' ,
percentOut = '3.71'
where entryId = '131799329'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '15713J104'
Number of Rows :64
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '68542870'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '68504497'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '68873263'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '70981542'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '71205761'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '71205829'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '72941289'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '72941328'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '72881443'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '74532679'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '74532721'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '74441225'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '75795815'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '76859649'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '76743334'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '76738556'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '77749587'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '78270051'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '79930046'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '79753794'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '80551008'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '82673570'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '82759987'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '84929448'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '84734417'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '86384961'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '86993658'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '89346442'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '89190218'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '90729209'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '91900859'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '92762561'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '93178273'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '93328582'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '94785794'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '94903346'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '95974745'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '96241175'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '96965147'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '99443881'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '99307013'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '101019662'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '101205709'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '104210458'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '104917668'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '106899057'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '107009868'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '109296004'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '109142418'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '110348806'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '111514450'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '111974929'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '113526772'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '114931979'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '115138757'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '116924476'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '117383164'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '118776749'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '122652176'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '122012042'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '126626341'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '125816759'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '127790630'
update archive13F set
compid = '159684',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004150'
where entryId = '128791605'
End Function
The Script is complete, exiting....