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: : 167137
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '167137'
The Shares Amount is 9000000
The cusip is 09354A118
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '09354A118'
Number of Rows :2
update current13Fpositions set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482' ,
percentOut = '0'
where entryId = '130469195'
update current13Fpositions set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482' ,
percentOut = '0'
where entryId = '100978032'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '09354A118'
Number of Rows :120
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '74211112'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '75201406'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '75693111'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '75038676'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '74570530'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '75060363'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '77273349'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '77155495'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '77003815'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '77432463'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '77475152'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '79047120'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '79348485'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '79581380'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '81447007'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '80683036'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '81307273'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '81723274'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '82573683'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '82734920'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '82815537'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '83475291'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '83800009'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '83767467'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '84860285'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '85149696'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '85379778'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '85654115'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '85895878'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '86207907'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '86668469'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '86883771'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '87396985'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '87445558'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '87587374'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '87903982'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '87892677'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '89122639'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '89475898'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '89539114'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '89638732'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '90062984'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '90161783'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '91431724'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '91621493'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '89955481'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '90881532'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '92136774'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '93087670'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '93651647'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '93701880'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '92232251'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '93792446'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '93146704'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '93640748'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '94097367'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '95272282'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '94420602'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '95246666'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '95092440'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '95241583'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '95572785'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '95762199'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '95921556'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '96464913'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '96220983'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '97572749'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '97277517'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '97597196'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '97617509'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '97728008'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '98161433'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '98178373'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '98579393'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '100098697'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '99253727'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '100619314'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '103172167'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '103199087'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '101401747'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '102136403'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '102317589'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '102180484'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '103879510'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '104047951'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '104803908'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '105003589'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '107132784'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '106446735'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '106650361'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '107211033'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '107453950'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '107785191'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '108823251'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '109653956'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '110725670'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '109111561'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '110858019'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '112761245'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '111595168'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '112044118'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '112345125'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '111921886'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '114527499'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '114878554'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '114773448'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '114553342'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '116608266'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '116766997'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '118095297'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '116493927'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '118662294'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '120605984'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '120705718'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '120640859'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '121353946'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '121379466'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '122453331'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '124459859'
update archive13F set
compid = '167137',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006482'
where entryId = '127858257'
End Function
The Script is complete, exiting....