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: : 130596
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130596'
The Shares Amount is 8271000
The cusip is 00305P106
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '00305P106'
Number of Rows :12
update current13Fpositions set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120' ,
percentOut = '9.45'
where entryId = '34295259'
update current13Fpositions set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120' ,
percentOut = '23.61'
where entryId = '42067796'
update current13Fpositions set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120' ,
percentOut = '4.19'
where entryId = '42167680'
update current13Fpositions set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120' ,
percentOut = '53.32'
where entryId = '42171271'
update current13Fpositions set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120' ,
percentOut = '108.79'
where entryId = '44935971'
update current13Fpositions set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120' ,
percentOut = '5.95'
where entryId = '51207095'
update current13Fpositions set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120' ,
percentOut = '3.1'
where entryId = '51442618'
update current13Fpositions set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120' ,
percentOut = '42.33'
where entryId = '57311182'
update current13Fpositions set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120' ,
percentOut = '0.69'
where entryId = '59707481'
update current13Fpositions set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120' ,
percentOut = '0'
where entryId = '64958733'
update current13Fpositions set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120' ,
percentOut = '14.21'
where entryId = '65088217'
update current13Fpositions set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120' ,
percentOut = '43.99'
where entryId = '69021146'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '00305P106'
Number of Rows :183
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '65499504'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '66313102'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '68047562'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '67562045'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '68156866'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '67698891'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '67341061'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '68027286'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '67507116'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '66458798'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '68166725'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '66978494'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '67590273'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '67963743'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '68021101'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '67815579'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '66736048'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '65901334'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '66559080'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '66363031'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '65236079'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '67923403'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '67216902'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '66935614'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '66033285'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '67251623'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '67275042'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '66722115'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '65865220'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '65635748'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '65413812'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '65432219'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '65659751'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '65210474'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '65178488'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '65120872'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '65899928'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '65344900'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '66279902'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '63392797'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '63403627'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '63467065'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '63497917'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '63633363'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '64306507'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '63756912'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '63718711'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '64013477'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '64622316'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '64411657'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '63749465'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '64952464'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '64119955'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '64472327'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '64460441'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '64265681'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '64546939'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '64558016'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '64582368'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '64949437'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '64941352'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '64731794'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '64647963'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '64919716'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '66836549'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '70191432'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '69100462'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '69906729'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '68945423'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '68688849'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '69214524'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '69124490'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '69200623'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '69355318'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '69797362'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '69529432'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '69612984'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '69551077'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '69550696'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '69430341'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '69475852'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '69527107'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '69216072'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '69678322'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '70100089'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '70293898'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '70191550'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '70308036'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '70324895'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '70688268'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '70713706'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '70783290'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '71102797'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '71279972'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '71527027'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '71585353'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '71581699'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '71345130'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '71030531'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '71505280'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '71211585'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '71790176'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '71754890'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '70992118'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '71389066'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '72365117'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '72117954'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '72473754'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '72415424'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '72798755'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '72299228'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '72107737'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '72577775'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '73514097'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '72528731'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '72868832'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '72536759'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '72391001'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '73587479'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '73584400'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '73579822'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '73401227'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '73722011'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '73524641'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '73350735'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '73568781'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '73123776'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '73020936'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '73320797'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '73188992'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '73495770'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '74243508'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '73990921'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '74124624'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '74337737'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '74851420'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '74264294'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '74549732'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '73912608'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '74409353'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '74479994'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '75576361'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '74462026'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '75436030'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '75429778'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '75399280'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '75191869'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '74962694'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '75358093'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '75390626'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '75123579'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '74665775'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '75374678'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '75058854'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '74921074'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '75232423'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '76759818'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '77569297'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '75814895'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '76253904'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '76763503'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '76571620'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '77624219'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '77631257'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '76761857'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '77598441'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '76749537'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '77595475'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '76251134'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '77630435'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '77628880'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '77585131'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '77573257'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '77601252'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '77570158'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '77592165'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '77578582'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '77589262'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '78595489'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '125138372'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '125139515'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '125140640'
update archive13F set
compid = '130596',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0000859120'
where entryId = '125362205'
End Function
The Script is complete, exiting....