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: : 159784
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '159784'
The Shares Amount is 126230000
The cusip is 466140100
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '466140100'
Number of Rows :4
update current13Fpositions set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250' ,
percentOut = '0.37'
where entryId = '42102911'
update current13Fpositions set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250' ,
percentOut = '0.28'
where entryId = '42113125'
update current13Fpositions set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250' ,
percentOut = '0.67'
where entryId = '42149274'
update current13Fpositions set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250' ,
percentOut = '0'
where entryId = '42266843'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '466140100'
Number of Rows :117
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '66563183'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '68151576'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '67754522'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '67181115'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '67503332'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '66754986'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '66432413'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '66626223'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '65286289'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '65876431'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '65811228'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '65161307'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '63611114'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '64975919'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '63881187'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '64670758'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '64701978'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '64868639'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '70002082'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '67250849'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '69101134'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '69665499'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '69345297'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '69865089'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '70832792'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '70111336'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '71115951'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '70437784'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '70908208'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '71155542'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '72113002'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '72194712'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '72225386'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '73356764'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '72550013'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '73155275'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '73310661'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '73813011'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '74547504'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '74432612'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '74493387'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '74880492'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '75046173'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '75762001'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '75855639'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '76321131'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '76394873'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '76974295'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '76812855'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '77799998'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '77681708'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '78053573'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '78312103'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '78837160'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '79550087'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '79760398'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '79937296'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '79705781'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '81171868'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '80029911'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '81002040'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '81700957'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '81993717'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '82523934'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '81959615'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '82234191'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '82617813'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '83717785'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '83887196'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '84613834'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '84456703'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '84652007'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '84850066'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '85479020'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '85801332'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '86608625'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '85987001'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '86647736'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '86920368'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '86836741'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '87180707'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '87758832'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '89688705'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '87943556'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '89274338'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '89842718'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '88571259'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '89898389'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '90815616'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '91824983'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '90616645'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '91828533'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '91146011'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '91961868'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '92570644'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '93731373'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '93277677'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '93864908'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '94072644'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '94373353'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '95167366'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '94894788'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '96047217'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '96592388'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '96560208'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '96892719'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '98787755'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '98392444'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '98494723'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '100610716'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '100817654'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '100974142'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '101170069'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '103292417'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '103312610'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '105699048'
update archive13F set
compid = '159784',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004250'
where entryId = '108420241'
End Function
The Script is complete, exiting....