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: : 159665
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '159665'
The Shares Amount is 9000000
The cusip is 16950T102
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '16950T102'
Number of Rows :7
update current13Fpositions set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131' ,
percentOut = '0.15'
where entryId = '130008933'
update current13Fpositions set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131' ,
percentOut = '0.03'
where entryId = '111394777'
update current13Fpositions set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131' ,
percentOut = '0.3'
where entryId = '108370567'
update current13Fpositions set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131' ,
percentOut = '120.66'
where entryId = '123599472'
update current13Fpositions set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131' ,
percentOut = '1.05'
where entryId = '130916105'
update current13Fpositions set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131' ,
percentOut = '0.02'
where entryId = '130357737'
update current13Fpositions set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131' ,
percentOut = '38.45'
where entryId = '131087681'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '16950T102'
Number of Rows :113
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '69863961'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '71154367'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '73309483'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '73876392'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '75044986'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '75875150'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '76315865'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '76973119'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '76811487'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '77740553'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '78048214'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '78835958'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '79591888'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '79783393'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '79700360'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '81170678'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '81000457'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '81711055'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '81988130'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '82232994'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '82616315'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '83743347'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '83881646'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '84650506'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '84848864'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '85278603'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '85763460'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '86060338'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '87677753'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '86607119'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '85981375'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '86918848'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '87179517'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '87763443'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '87782215'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '87981402'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '89273131'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '89833629'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '88569774'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '89864577'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '90629106'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '91824964'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '91827048'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '91144834'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '91973468'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '93276506'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '93865127'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '94019979'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '94893615'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '96124942'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '96144525'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '96891536'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '98696563'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '98494046'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '98628327'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '100267503'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '100718781'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '101138173'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '102351344'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '101774803'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '103197588'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '102643553'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '103328687'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '103385665'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '105655913'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '104336608'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '104520355'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '105530821'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '105819399'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '106038818'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '106103543'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '106999528'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '107622206'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '107797965'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '107550056'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '108543887'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '109418409'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '109267193'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '109638674'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '110731137'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '111313229'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '112081944'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '112186309'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '112760646'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '114087242'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '114424637'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '115323289'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '116544621'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '116582044'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '117029612'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '117930494'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '116913862'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '118919623'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '119139122'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '120308722'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '120872859'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '120604816'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '121000866'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '122139278'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '122768395'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '123630554'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '122027715'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '122625879'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '123233225'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '125736132'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '125127331'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '124644245'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '125972020'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '126632429'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '129710451'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '128095317'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '129864074'
update archive13F set
compid = '159665',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004131'
where entryId = '129761175'
End Function
The Script is complete, exiting....