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: : 159803
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '159803'
The Shares Amount is 4000000
The cusip is 902641620
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '902641620'
Number of Rows :2
update current13Fpositions set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269' ,
percentOut = '22.31'
where entryId = '46117680'
update current13Fpositions set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269' ,
percentOut = '0.57'
where entryId = '65083965'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '902641620'
Number of Rows :117
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '66053287'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '65808881'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '67835881'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '66995611'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '68055776'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '66139174'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '68361725'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '66092479'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '68026866'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '67902310'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '66288148'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '66352603'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '66321509'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '68086457'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '67752167'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '65361931'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '63388477'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '63734602'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '64286486'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '64592428'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '64634095'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '64553298'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '64382372'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '69142772'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '69818771'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '69360860'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '69558652'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '69405205'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '69593136'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '69970249'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '70732255'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '71113569'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '71403503'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '71633148'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '71679833'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '71609763'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '71012514'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '72864162'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '72492682'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '72807875'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '73428645'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '73623273'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '73646838'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '73742593'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '73210140'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '74142942'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '73911893'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '75249810'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '75478615'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '75513854'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '74942473'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '76066217'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '76845354'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '76887946'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '77614479'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '77322958'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '77381882'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '78032166'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '78675233'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '79222365'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '79293356'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '79641710'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '79374521'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '78263140'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '81618241'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '80479581'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '81021775'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '81052673'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '81357152'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '81381867'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '81609268'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '81850142'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '82492082'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '83076420'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '83121994'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '83407984'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '83441026'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '84283688'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '84291184'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '84687851'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '84766051'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '85252215'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '85303553'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '86974003'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '86766717'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '86898680'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '86963071'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '87026230'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '87675374'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '87681769'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '89717916'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '88977592'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '88581168'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '89137668'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '89163781'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '89713003'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '90657384'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '90974262'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '90955452'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '90896852'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '93103207'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '93903420'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '92672211'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '93153563'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '93205828'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '93532232'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '95279245'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '94436256'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '95298118'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '95336753'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '95870875'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '94728729'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '97602341'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '96659022'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '97572678'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '98143816'
update archive13F set
compid = '159803',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004269'
where entryId = '98383986'
End Function
The Script is complete, exiting....