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: : 131049
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '131049'
The Shares Amount is 2856000
The cusip is 27826G109
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '27826G109'
Number of Rows :23
update current13Fpositions set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686' ,
percentOut = '36.34'
where entryId = '11264817'
update current13Fpositions set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686' ,
percentOut = '36.34'
where entryId = '12845824'
update current13Fpositions set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686' ,
percentOut = '9.45'
where entryId = '13022959'
update current13Fpositions set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686' ,
percentOut = '36.34'
where entryId = '14230750'
update current13Fpositions set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686' ,
percentOut = '160.71'
where entryId = '14328989'
update current13Fpositions set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686' ,
percentOut = '9.45'
where entryId = '14678123'
update current13Fpositions set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686' ,
percentOut = '245.69'
where entryId = '15137147'
update current13Fpositions set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686' ,
percentOut = '3.15'
where entryId = '15455200'
update current13Fpositions set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686' ,
percentOut = '39.5'
where entryId = '15774132'
update current13Fpositions set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686' ,
percentOut = '158.96'
where entryId = '15994003'
update current13Fpositions set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686' ,
percentOut = '9.45'
where entryId = '16194381'
update current13Fpositions set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686' ,
percentOut = '246.13'
where entryId = '16552176'
update current13Fpositions set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686' ,
percentOut = '150.21'
where entryId = '17426839'
update current13Fpositions set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686' ,
percentOut = '9.45'
where entryId = '17978015'
update current13Fpositions set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686' ,
percentOut = '197.13'
where entryId = '18075899'
update current13Fpositions set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686' ,
percentOut = '143.74'
where entryId = '18299297'
update current13Fpositions set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686' ,
percentOut = '11.9'
where entryId = '19147811'
update current13Fpositions set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686' ,
percentOut = '4.3'
where entryId = '23170528'
update current13Fpositions set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686' ,
percentOut = '1.75'
where entryId = '35073761'
update current13Fpositions set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686' ,
percentOut = '74.47'
where entryId = '42067877'
update current13Fpositions set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686' ,
percentOut = '24.47'
where entryId = '42078191'
update current13Fpositions set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686' ,
percentOut = '49.69'
where entryId = '51210251'
update current13Fpositions set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686' ,
percentOut = '55.33'
where entryId = '70669716'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '27826G109'
Number of Rows :231
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '66039350'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '66983753'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '67601144'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '67917399'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '67978705'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '68007591'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '67905997'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '66096833'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '67702212'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '66460669'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '67734982'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '68168568'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '67135522'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '65671794'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '67347846'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '67963822'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '68366099'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '67821785'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '67872310'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '67894350'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '66705373'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '66142554'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '66366507'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '65562351'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '65901363'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '65953151'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '66166076'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '65210322'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '66131567'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '66910947'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '66848192'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '63413924'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '65711587'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '65972999'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '65350101'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '66386528'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '65502969'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '63405810'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '63633274'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '63723547'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '64227532'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '64005070'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '63945414'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '63590040'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '64981320'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '64272042'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '64392209'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '65123066'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '63823228'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '64374831'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '64335341'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '64733877'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '64651225'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '68492695'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '69988219'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '68429517'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '67224516'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '68768760'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '69223630'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '69130179'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '69803870'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '69317072'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '69608131'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '69409626'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '69423111'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '69102246'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '70043837'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '69475943'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '69916538'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '69397145'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '69510877'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '69376369'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '69680359'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '71819040'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '70233491'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '70497557'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '70095720'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '70406927'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '70719466'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '71266862'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '71211621'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '71560308'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '71624002'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '71141375'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '71590084'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '71242141'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '71189668'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '71409009'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '70998383'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '71391018'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '72097681'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '72739600'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '72790889'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '72479593'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '72183375'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '72774073'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '72586166'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '73587315'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '73350776'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '73568809'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '73528288'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '73678089'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '73613560'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '73282180'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '72645886'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '72837631'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '73590909'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '73373187'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '73324347'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '73195444'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '73497911'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '73456624'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '74243542'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '73983099'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '74096264'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '73963739'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '74130247'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '75626658'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '74791503'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '74844723'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '75188673'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '74462150'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '75435865'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '75390860'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '74779008'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '75123629'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '75354131'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '75545974'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '75468567'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '75094611'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '75439246'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '75148029'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '75062262'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '75671228'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '74927599'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '75234648'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '75912686'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '76689039'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '76942230'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '76033672'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '77597399'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '75787319'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '76053399'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '76548985'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '76517341'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '77036539'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '77206551'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '77629347'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '77440763'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '77100271'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '77071898'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '76872737'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '77595554'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '77610539'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '77005698'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '77312910'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '77279266'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '76194239'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '77282896'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '78114376'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '77984151'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '78003367'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '78210314'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '78180533'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '78562934'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '79174592'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '78019309'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '78219634'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '78973192'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '79471954'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '79535799'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '78669832'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '78862853'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '78890458'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '79149733'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '79168842'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '79211990'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '79232973'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '79300910'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '79553686'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '78167870'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '79625907'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '78945363'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '79866255'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '79785514'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '79934272'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '80223995'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '80412904'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '80801382'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '80678737'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '80467637'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '81129613'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '81165305'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '81322705'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '81534653'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '81016377'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '81039549'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '81063982'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '81204318'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '81306641'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '81346453'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '81392441'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '81573258'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '81593182'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '81760783'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '83651431'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '82596801'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '83550208'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '82459333'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '82467406'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '82605445'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '81969562'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '83549637'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '83554507'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '83070866'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '83570680'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '83571240'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '83603862'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '83579178'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '83589500'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '83593839'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '83597143'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '84682048'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '86957089'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '89157597'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '90949112'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '93843858'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '51036992'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '96632541'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '66818820'
update archive13F set
compid = '131049',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074686'
where entryId = '126869006'
End Function
The Script is complete, exiting....