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: : 167138
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '167138'
The Shares Amount is 9000000
The cusip is 89157G116
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '89157G116'
Number of Rows :1
update current13Fpositions set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483' ,
percentOut = '179.8'
where entryId = '126317004'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '89157G116'
Number of Rows :123
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '80775355'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '81337645'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '83355696'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '83390345'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '85190552'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '85230418'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '85658177'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '87321805'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '87420382'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '87418279'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '89292425'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '88983899'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '89025433'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '89337464'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '89488136'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '90171406'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '91356227'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '91449481'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '91495440'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '91213551'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '93781876'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '92945512'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '92241829'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '93153423'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '93313645'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '93536145'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '93640820'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '92526813'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '95279101'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '95023563'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '94872552'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '95873070'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '95973340'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '95921644'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '96021673'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '96228004'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '96888719'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '98130797'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '98239284'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '97806056'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '97992171'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '98178333'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '98214680'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '100480544'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '100126729'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '99261379'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '99392967'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '99717281'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '100295571'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '100464117'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '103231112'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '102144540'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '102191052'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '102628986'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '102794720'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '102768711'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '104056381'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '105284704'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '105016650'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '105034759'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '105053552'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '105672072'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '105288486'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '106455606'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '106656526'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '107468638'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '107489584'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '108087789'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '107751609'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '108318118'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '108842731'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '110474550'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '110271809'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '109120690'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '109660667'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '110284255'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '110529993'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '110859957'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '112056454'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '113260820'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '111931141'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '112313350'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '113458941'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '113255715'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '113544026'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '114887799'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '114772975'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '114565278'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '115611809'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '115533072'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '115771550'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '115607830'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '118288972'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '118274884'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '116895224'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '116502893'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '118569503'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '118260545'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '118263614'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '118179656'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '119579731'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '121208208'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '119911410'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '120714684'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '120317003'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '121161526'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '121211443'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '122462429'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '123257818'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '123797565'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '122976003'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '123741316'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '123791168'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '124468906'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '125044634'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '126303749'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '126517069'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '126933036'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '128370389'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '129750283'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '129764137'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '129736562'
update archive13F set
compid = '167138',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006483'
where entryId = '128382863'
End Function
The Script is complete, exiting....