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: : 159614
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '159614'
The Shares Amount is 9000000
The cusip is 903002202
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '903002202'
Number of Rows :2
update current13Fpositions set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080' ,
percentOut = '1.81'
where entryId = '51217477'
update current13Fpositions set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080' ,
percentOut = '183.11'
where entryId = '55043643'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '903002202'
Number of Rows :80
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '66053346'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '67835943'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '66590852'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '67580127'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '67082989'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '67709503'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '67970902'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '67755391'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '67595271'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '68053072'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '65812114'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '66374104'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '66946767'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '65879608'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '66229329'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '67124947'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '65666004'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '67427500'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '66815791'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '66995683'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '67060945'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '66318631'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '67230280'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '66209475'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '66161027'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '65792973'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '65362000'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '65301499'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '65255376'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '65653510'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '65293026'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '65300508'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '63665960'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '63586973'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '63780724'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '63813053'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '63734669'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '64095986'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '64713770'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '63882050'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '64133759'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '64286544'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '64479627'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '64589737'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '64410509'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '64155824'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '64730511'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '64658412'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '68573297'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '68529338'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '68736658'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '68632199'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '68606302'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '69142848'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '69207619'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '69311684'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '69818835'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '69346199'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '69610706'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '69977467'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '69482822'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '69034750'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '69464519'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '70226874'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '70519529'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '70511049'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '70137731'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '70511214'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '70859012'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '70860554'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '71750404'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '71740710'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '71810879'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '71772671'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '71810507'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '71807908'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '71754717'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '71743462'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '51038625'
update archive13F set
compid = '159614',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004080'
where entryId = '96634156'
End Function
The Script is complete, exiting....