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: : 167152
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '167152'
The Shares Amount is 9000000
The cusip is 23130Q115
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '23130Q115'
Number of Rows :9
update current13Fpositions set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497' ,
percentOut = '11.11'
where entryId = '132095264'
update current13Fpositions set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497' ,
percentOut = '0'
where entryId = '100978012'
update current13Fpositions set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497' ,
percentOut = '0.56'
where entryId = '129958501'
update current13Fpositions set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497' ,
percentOut = '134.39'
where entryId = '132214966'
update current13Fpositions set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497' ,
percentOut = '6.76'
where entryId = '132132926'
update current13Fpositions set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497' ,
percentOut = '0'
where entryId = '130470223'
update current13Fpositions set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497' ,
percentOut = '0'
where entryId = '132618784'
update current13Fpositions set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497' ,
percentOut = '43.48'
where entryId = '132053460'
update current13Fpositions set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497' ,
percentOut = '0'
where entryId = '132575110'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '23130Q115'
Number of Rows :144
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '96464924'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '96520315'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '96959229'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '96880204'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '97181163'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '97255986'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '97399841'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '97729639'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '97863022'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '97889738'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '97442881'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '97707240'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '97769162'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '97874329'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '97930794'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '97939311'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '97995313'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '97997695'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '98002911'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '98049139'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '98117979'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '98185112'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '98579417'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '98665193'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '99254674'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '100115092'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '100077661'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '100092472'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '100096813'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '100105769'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '100657106'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '100118441'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '100119050'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '98762392'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '100174376'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '100618845'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '100266085'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '100286101'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '100359649'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '100394430'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '100411143'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '100646165'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '100646658'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '100472916'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '100527530'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '100545808'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '100615266'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '100657866'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '100468698'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '100865056'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '102137400'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '102998794'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '102181891'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '102582816'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '102630744'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '102693385'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '102736026'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '102805434'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '102856715'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '103059742'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '103120901'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '103012537'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '103230246'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '104048970'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '104442282'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '105005327'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '105487027'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '105054568'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '105495457'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '105523533'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '105510947'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '105384207'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '105159577'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '103585057'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '106266810'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '107132804'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '106447805'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '108085940'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '107510542'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '107785209'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '107919677'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '108260443'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '108526136'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '109011813'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '109112678'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '110858035'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '110870083'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '110728240'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '110624046'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '111370041'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '112045670'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '112345146'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '111923022'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '113142410'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '113316646'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '108460011'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '116077790'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '113960611'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '114879667'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '114395430'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '115701139'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '114553362'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '115420176'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '116729606'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '116647798'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '117367559'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '118095303'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '117707637'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '116494992'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '117801846'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '118056946'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '119560690'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '120195748'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '119900015'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '120706783'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '121119327'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '120832124'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '121074329'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '121385663'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '129290317'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '122259258'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '122454408'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '123257342'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '123714906'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '122865810'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '123434711'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '123788493'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '123690271'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '124221618'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '126152773'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '124460925'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '125033980'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '125697349'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '126118177'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '126301037'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '126897541'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '127665745'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '127859274'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '127585858'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '129692988'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '129173583'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '129068217'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '127969817'
update archive13F set
compid = '167152',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006497'
where entryId = '129140583'
End Function
The Script is complete, exiting....