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: : 159964
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '159964'
The Shares Amount is 455480000
The cusip is W48102128
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = 'W48102128'
Number of Rows :3
update current13Fpositions set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430' ,
percentOut = '0.07'
where entryId = '42211974'
update current13Fpositions set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430' ,
percentOut = '0'
where entryId = '42459259'
update current13Fpositions set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430' ,
percentOut = '11.35'
where entryId = '130288016'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = 'W48102128'
Number of Rows :47
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '67268149'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '67320517'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '67670179'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '65234224'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '66302406'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '65901195'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '63413142'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '63958092'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '69348044'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '69475238'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '69251100'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '71778637'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '71560043'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '71636606'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '73028639'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '73625738'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '75576970'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '74700672'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '77325521'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '77257390'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '79149261'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '77774820'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '80184586'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '82871304'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '81588981'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '84455975'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '84575216'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '85476833'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '86502783'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '87632113'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '88364462'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '90496667'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '92506043'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '94552428'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '97180007'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '98395140'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '101327002'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '103625496'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '106208814'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '108821591'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '111593352'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '115479229'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '116606898'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '120194564'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '122864712'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '125184215'
update archive13F set
compid = '159964',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004430'
where entryId = '127408526'
End Function
The Script is complete, exiting....