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: : 167142
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '167142'
The Shares Amount is 12490000
The cusip is 636375115
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '636375115'
Number of Rows :1
update current13Fpositions set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487' ,
percentOut = '0'
where entryId = '89561206'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '636375115'
Number of Rows :123
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '67706055'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '67556218'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '67864801'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '67898628'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '68163622'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '68769240'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '69195054'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '69613648'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '69401477'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '69674878'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '70498035'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '70828574'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '71628968'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '71193617'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '71385838'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '71174216'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '73055579'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '72183816'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '73618818'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '73328481'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '73492186'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '73296602'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '74791942'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '74733390'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '75176886'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '75473984'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '75066338'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '75228795'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '75088888'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '76689485'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '77695362'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '77447919'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '76997071'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '77130096'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '77010182'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '77318327'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '77306315'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '77989733'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '78503795'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '78867334'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '79002952'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '79206057'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '79218138'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '79308251'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '79654922'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '81340988'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '80301814'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '81134202'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '81446610'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '79883547'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '81150320'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '81235430'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '81352798'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '81399826'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '83033747'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '82387305'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '81923771'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '82740987'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '83308129'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '83403593'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '83429220'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '83277898'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '84583592'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '84516993'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '84866659'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '85067482'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '85233584'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '85247743'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '85351662'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '85651267'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '87451900'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '86086495'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '87245003'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '87589662'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '86674860'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '87305714'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '87466832'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '87549523'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '89289166'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '88066114'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '88733531'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '89088102'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '88460225'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '89406705'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '89602508'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '90578151'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '90168161'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '90552821'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '90457168'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '91883496'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '91582412'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '91339673'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '93835405'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '92322482'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '93710943'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '92238610'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '93151248'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '93844453'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '93627514'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '93768065'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '95088814'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '95276876'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '94126165'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '94430685'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '94869303'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '95151963'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '95502374'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '95781331'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '97554517'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '96225656'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '96525991'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '97572649'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '96885372'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '97088606'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '97339643'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '97485932'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '98845191'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '100110521'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '100069649'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '100064698'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '100077701'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '100087350'
update archive13F set
compid = '167142',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006487'
where entryId = '100102709'
End Function
The Script is complete, exiting....