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: : 152077
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '152077'
The Shares Amount is 25522000
The cusip is 000944207
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '000944207'
Number of Rows :0
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '000944207'
Number of Rows :44
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '67036033'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '67149539'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '65271686'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '65149675'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '66073349'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '63602957'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '63645137'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '63742410'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '68544564'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '68699035'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '70099895'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '70302107'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '72354848'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '72241991'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '73890469'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '76025009'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '74166955'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '78206755'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '77986248'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '78282065'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '79984024'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '79877270'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '83527985'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '82226417'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '84027935'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '86120796'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '88628090'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '90373335'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '92701724'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '94809199'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '95612264'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '96849403'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '97826736'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '98652408'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '100304751'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '102642790'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '101011601'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '105628472'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '105956583'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '108601531'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '110348025'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '111270141'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '113526654'
update archive13F set
compid = '152077',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000863872'
where entryId = '114213798'
End Function
The Script is complete, exiting....