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: : 130805
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130805'
The Shares Amount is 6800000
The cusip is 56165R103
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '56165R103'
Number of Rows :6
update current13Fpositions set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511' ,
percentOut = '6.47'
where entryId = '42078245'
update current13Fpositions set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511' ,
percentOut = '211.44'
where entryId = '42230612'
update current13Fpositions set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511' ,
percentOut = '4.08'
where entryId = '51213280'
update current13Fpositions set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511' ,
percentOut = '113.65'
where entryId = '57032001'
update current13Fpositions set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511' ,
percentOut = '20.48'
where entryId = '62082194'
update current13Fpositions set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511' ,
percentOut = '15.13'
where entryId = '70670499'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '56165R103'
Number of Rows :222
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '66074071'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '66288770'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '68027363'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '67979441'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '67875201'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '66045788'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '67906046'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '67705508'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '67918291'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '68170709'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '67682408'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '67748293'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '66703779'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '65490213'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '68123557'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '66535429'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '66462804'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '68052870'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '67828248'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '68366892'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '68372890'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '66319132'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '66142603'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '66369925'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '67071524'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '65326724'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '66934835'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '66989104'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '65275631'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '67150796'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '68047024'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '66318420'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '68053568'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '66911956'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '66099680'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '66892257'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '66947841'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '67158557'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '66166937'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '65445544'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '65906505'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '65355446'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '65519694'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '66387498'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '65672802'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '65095385'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '65205610'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '66312192'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '65805101'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '63404901'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '63739325'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '63994482'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '64053707'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '63728542'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '64027579'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '63671176'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '63839874'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '63875087'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '63754772'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '64472792'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '64278651'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '64816578'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '64392255'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '64553766'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '64590235'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '64589529'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '64581261'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '65121379'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '64926427'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '64417344'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '63824166'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '64338021'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '64736187'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '64654456'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '68566601'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '68428611'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '68765205'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '68656865'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '68769847'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '68743946'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '68734295'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '69224403'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '69290165'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '69135910'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '69810715'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '70046726'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '69529511'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '69907809'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '69338982'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '69606080'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '69409666'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '69424023'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '69977264'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '70044962'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '69556538'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '69401008'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '69096403'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '69379163'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '69682745'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '71817160'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '70202418'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '70232889'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '70498649'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '70334676'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '70400907'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '70593155'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '70725292'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '71109616'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '71635989'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '70554331'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '71639396'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '71014913'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '71030603'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '71211659'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '71640092'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '70693612'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '71628406'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '71243095'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '71193065'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '71416464'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '71004945'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '71393281'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '72587635'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '71980777'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '72485548'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '72356383'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '72902268'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '72732674'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '72897944'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '72184418'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '72743271'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '72543654'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '73715785'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '72747892'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '72002787'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '73222071'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '73350820'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '73569059'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '73528527'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '73626975'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '72940798'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '73618221'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '72838473'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '73374156'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '73327889'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '73058204'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '73202285'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '73500466'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '73459538'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '73931052'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '73918134'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '74136021'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '74269103'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '74725758'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '74850995'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '75626622'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '74317012'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '74792586'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '74486945'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '75690592'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '74832150'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '75429859'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '74841325'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '74962790'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '75451073'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '75596602'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '75606224'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '75123673'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '75610547'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '75482880'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '75473378'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '75149026'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '75065784'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '75674056'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '74934537'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '75237278'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '75117744'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '76037380'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '76690175'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '76682121'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '76059628'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '77566312'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '76187162'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '76388367'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '77114622'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '76174811'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '77405955'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '77446984'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '75825242'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '77101433'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '77071941'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '76880296'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '77009605'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '77275353'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '77317721'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '77329239'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '77638432'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '77590058'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '76906758'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '79486747'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '78003190'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '78213692'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '78127980'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '78595156'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '78557072'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '79589545'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '78565865'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '78219145'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '79489125'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '79514494'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '79468291'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '79167344'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '79528869'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '79530700'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '79484106'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '79473828'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '79591539'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '79677565'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '79490087'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '80403667'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '32247711'
update archive13F set
compid = '130805',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001235511'
where entryId = '81529645'
End Function
The Script is complete, exiting....