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: : 131050
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '131050'
The Shares Amount is 2719000
The cusip is 27826T101
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '27826T101'
Number of Rows :24
update current13Fpositions set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687' ,
percentOut = '60.58'
where entryId = '12256234'
update current13Fpositions set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687' ,
percentOut = '36.78'
where entryId = '12318574'
update current13Fpositions set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687' ,
percentOut = '4.66'
where entryId = '13648636'
update current13Fpositions set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687' ,
percentOut = '36.78'
where entryId = '13937860'
update current13Fpositions set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687' ,
percentOut = '137.92'
where entryId = '14328990'
update current13Fpositions set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687' ,
percentOut = '4.65'
where entryId = '14678124'
update current13Fpositions set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687' ,
percentOut = '4.66'
where entryId = '15158920'
update current13Fpositions set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687' ,
percentOut = '36.78'
where entryId = '15258207'
update current13Fpositions set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687' ,
percentOut = '143.99'
where entryId = '15994004'
update current13Fpositions set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687' ,
percentOut = '1.93'
where entryId = '16639212'
update current13Fpositions set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687' ,
percentOut = '18.39'
where entryId = '16763148'
update current13Fpositions set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687' ,
percentOut = '4.66'
where entryId = '17144370'
update current13Fpositions set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687' ,
percentOut = '4.66'
where entryId = '17254016'
update current13Fpositions set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687' ,
percentOut = '126.59'
where entryId = '17426840'
update current13Fpositions set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687' ,
percentOut = '0'
where entryId = '17776227'
update current13Fpositions set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687' ,
percentOut = '18.39'
where entryId = '18181180'
update current13Fpositions set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687' ,
percentOut = '75.06'
where entryId = '18299298'
update current13Fpositions set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687' ,
percentOut = '0'
where entryId = '23406675'
update current13Fpositions set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687' ,
percentOut = '42.33'
where entryId = '42078192'
update current13Fpositions set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687' ,
percentOut = '18.23'
where entryId = '42191673'
update current13Fpositions set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687' ,
percentOut = '12.99'
where entryId = '42198529'
update current13Fpositions set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687' ,
percentOut = '5.16'
where entryId = '57474193'
update current13Fpositions set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687' ,
percentOut = '38.8'
where entryId = '62081868'
update current13Fpositions set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687' ,
percentOut = '7.36'
where entryId = '65087054'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '27826T101'
Number of Rows :166
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '66366511'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '66590881'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '67821789'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '67917400'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '66096835'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '67702214'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '67905999'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '65671895'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '68168571'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '66615662'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '67963823'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '68366979'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '67872312'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '68360472'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '66166077'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '66074151'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '66142556'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '67540356'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '66039353'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '67744896'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '66983756'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '67112769'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '65315447'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '65801785'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '65460391'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '65350105'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '63391621'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '63723551'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '64006058'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '63871820'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '64472355'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '64272045'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '64392210'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '64416489'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '64335343'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '64733880'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '64863467'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '66836559'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '70191443'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '68948320'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '69130182'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '69803873'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '69335607'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '69611003'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '69409628'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '69423112'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '70044923'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '69475944'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '69376371'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '69680362'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '70191555'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '70719471'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '70823030'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '71106185'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '71720058'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '71211623'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '71560309'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '71242142'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '71189673'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '71409011'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '70998387'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '71391021'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '72365727'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '72479599'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '72805627'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '72299275'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '72540148'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '73689381'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '73580441'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '73350778'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '73728178'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '73373188'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '73324348'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '73195448'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '73497914'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '73456626'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '74243559'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '73991490'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '74130251'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '74285430'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '75400102'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '74483396'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '75556880'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '75123631'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '75148030'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '75062268'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '75671230'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '74927603'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '75234650'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '76942233'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '75787327'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '76053403'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '76611700'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '76384538'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '77206554'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '77402406'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '77440766'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '77100272'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '77071900'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '76872740'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '77257712'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '76239821'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '77530966'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '77005702'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '76575339'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '78215413'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '78465650'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '78210242'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '78301904'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '77921284'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '78019313'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '78973194'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '79471951'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '79455178'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '78669835'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '78862858'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '79149734'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '79300913'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '79334842'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '79436019'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '79553688'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '79575977'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '79625910'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '78945365'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '79679651'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '80223996'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '80386231'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '80967811'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '80678738'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '80928351'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '80019362'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '80467641'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '81129617'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '81548849'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '81471091'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '81016380'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '81039551'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '81063985'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '81204321'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '81306642'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '81392444'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '81424114'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '81573259'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '81967928'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '82599692'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '83557407'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '82596795'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '82459332'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '82604860'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '82605353'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '83549635'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '83070869'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '83570560'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '83571242'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '83603861'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '83579197'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '83589354'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '83596919'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '83597511'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '84682051'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '86957092'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '89157600'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '90949115'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '93843648'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '51036993'
update archive13F set
compid = '131050',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074687'
where entryId = '96632542'
End Function
The Script is complete, exiting....