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: : 145514
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '145514'
The Shares Amount is 0
The cusip is 04957F101
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '04957F101'
Number of Rows :8
update current13Fpositions set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '' ,
percentOut = '0'
where entryId = '14132424'
update current13Fpositions set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '' ,
percentOut = '0'
where entryId = '15453371'
update current13Fpositions set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '' ,
percentOut = '0'
where entryId = '15593812'
update current13Fpositions set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '' ,
percentOut = '0'
where entryId = '16963456'
update current13Fpositions set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '' ,
percentOut = '0'
where entryId = '17035346'
update current13Fpositions set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '' ,
percentOut = '0'
where entryId = '19064698'
update current13Fpositions set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '' ,
percentOut = '0'
where entryId = '132212120'
update current13Fpositions set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '' ,
percentOut = '0'
where entryId = '130735614'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '04957F101'
Number of Rows :21
update archive13F set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '105275142'
update archive13F set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '105869873'
update archive13F set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '107800959'
update archive13F set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '110519677'
update archive13F set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '108986471'
update archive13F set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '111674143'
update archive13F set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '113246940'
update archive13F set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '114660000'
update archive13F set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '115597063'
update archive13F set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '117209301'
update archive13F set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '118250500'
update archive13F set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '119443377'
update archive13F set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '121197751'
update archive13F set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '122269830'
update archive13F set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '123784838'
update archive13F set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '122003097'
update archive13F set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '126868473'
update archive13F set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '124595202'
update archive13F set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '126297160'
update archive13F set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '128245668'
update archive13F set
compid = '145514',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '129279500'
End Function
The Script is complete, exiting....