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: : 131052
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '131052'
The Shares Amount is 2750000
The cusip is 27826E104
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '27826E104'
Number of Rows :15
update current13Fpositions set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690' ,
percentOut = '22.91'
where entryId = '9754434'
update current13Fpositions set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690' ,
percentOut = '151.1'
where entryId = '11443362'
update current13Fpositions set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690' ,
percentOut = '43.09'
where entryId = '11893802'
update current13Fpositions set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690' ,
percentOut = '52.02'
where entryId = '14267253'
update current13Fpositions set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690' ,
percentOut = '16.92'
where entryId = '15810999'
update current13Fpositions set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690' ,
percentOut = '43.09'
where entryId = '16961313'
update current13Fpositions set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690' ,
percentOut = '26.83'
where entryId = '23170522'
update current13Fpositions set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690' ,
percentOut = '0'
where entryId = '41966066'
update current13Fpositions set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690' ,
percentOut = '87.46'
where entryId = '42067872'
update current13Fpositions set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690' ,
percentOut = '5.27'
where entryId = '42078239'
update current13Fpositions set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690' ,
percentOut = '1.09'
where entryId = '42203977'
update current13Fpositions set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690' ,
percentOut = '5.45'
where entryId = '42240887'
update current13Fpositions set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690' ,
percentOut = '0'
where entryId = '51354570'
update current13Fpositions set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690' ,
percentOut = '5.45'
where entryId = '52243174'
update current13Fpositions set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690' ,
percentOut = '0'
where entryId = '65231467'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '27826E104'
Number of Rows :112
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '66983728'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '67601138'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '67702191'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '67869369'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '65908715'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '66458540'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '66093841'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '66366487'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '65672252'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '67963832'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '67821782'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '68166467'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '65901373'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '66039346'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '65350074'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '63391622'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '63723520'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '64008577'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '64472362'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '64272038'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '64332432'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '64731499'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '64651204'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '69130155'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '69803865'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '69612380'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '69475951'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '69488732'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '69373456'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '69678047'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '70719442'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '71651203'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '71560315'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '71508995'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '71189645'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '71409007'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '70998379'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '71388786'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '72479567'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '72902239'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '72813134'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '73569053'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '73528280'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '73324324'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '73195440'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '73495486'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '73453678'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '74130222'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '74462139'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '75606220'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '75610583'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '75062240'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '75668337'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '74927595'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '75232125'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '75899117'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '76942220'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '76053373'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '76548976'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '77537427'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '77399335'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '76872733'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '77440746'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '77257721'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '77005673'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '77868210'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '78210320'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '78590466'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '77921282'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '78019282'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '78219636'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '78669818'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '78862829'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '79149748'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '79195013'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '79300891'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '79331528'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '79553680'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '79625903'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '80343943'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '80678734'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '80467616'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '81129594'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '83658260'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '81016367'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '81039547'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '81063976'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '81204312'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '81306656'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '81333544'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '81346451'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '81392425'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '81421111'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '81843185'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '83674203'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '82596799'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '82605348'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '83549657'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '83070856'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '83570604'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '83571185'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '83579166'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '83589512'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '83593894'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '83597108'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '83597372'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '83592130'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '84682038'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '86957079'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '89157587'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '90949102'
update archive13F set
compid = '131052',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074690'
where entryId = '93843864'
End Function
The Script is complete, exiting....