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: : 167143
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '167143'
The Shares Amount is 9000000
The cusip is 92337U112
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '92337U112'
Number of Rows :5
update current13Fpositions set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488' ,
percentOut = '257.46'
where entryId = '131268907'
update current13Fpositions set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488' ,
percentOut = '10.35'
where entryId = '131720349'
update current13Fpositions set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488' ,
percentOut = '0'
where entryId = '130478580'
update current13Fpositions set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488' ,
percentOut = '53.58'
where entryId = '131179775'
update current13Fpositions set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488' ,
percentOut = '489.67'
where entryId = '132217930'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '92337U112'
Number of Rows :103
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '84500704'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '85149451'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '85190569'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '85230480'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '86684866'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '87420392'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '87487541'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '87396706'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '87418324'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '87587435'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '87608543'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '89025451'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '89050732'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '89475119'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '89488185'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '89638806'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '89685570'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '91430805'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '91449498'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '91621556'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '91689321'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '91520333'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '91495461'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '92945527'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '93792438'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '93153875'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '93836120'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '93532456'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '93536196'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '93640823'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '93726624'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '95279562'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '95871103'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '95023582'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '95873118'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '95921652'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '95953904'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '96228478'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '98239304'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '97992225'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '98178338'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '98107912'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '98376386'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '100662127'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '100575482'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '99261889'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '99393700'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '99717295'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '100464188'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '102145091'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '102021249'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '102430452'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '102794792'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '102968166'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '104056934'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '105017592'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '105288558'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '105319843'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '105441686'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '106456181'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '108119607'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '108086259'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '108007512'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '110110814'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '108842825'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '110272793'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '109121276'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '110687829'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '110855239'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '110860051'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '112388030'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '112057324'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '111931715'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '113388138'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '113546937'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '114888369'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '114408405'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '115864908'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '115611916'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '114580378'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '118620789'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '116896212'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '118418568'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '116503444'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '118263691'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '121293068'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '120626460'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '120715235'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '121211534'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '122462982'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '122645455'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '123133091'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '122976416'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '123791252'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '124469450'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '125045465'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '126303826'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '126509833'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '126847213'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '127867706'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '129525402'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '129293115'
update archive13F set
compid = '167143',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006488'
where entryId = '128382458'
End Function
The Script is complete, exiting....