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: : 131051
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '131051'
The Shares Amount is 2116000
The cusip is 27826D106
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '27826D106'
Number of Rows :12
update current13Fpositions set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688' ,
percentOut = '27.17'
where entryId = '14267365'
update current13Fpositions set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688' ,
percentOut = '466.16'
where entryId = '14328987'
update current13Fpositions set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688' ,
percentOut = '24.93'
where entryId = '15811000'
update current13Fpositions set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688' ,
percentOut = '527.69'
where entryId = '15994000'
update current13Fpositions set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688' ,
percentOut = '2.36'
where entryId = '16639207'
update current13Fpositions set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688' ,
percentOut = '388.52'
where entryId = '17426836'
update current13Fpositions set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688' ,
percentOut = '160.68'
where entryId = '18299294'
update current13Fpositions set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688' ,
percentOut = '2.84'
where entryId = '18669322'
update current13Fpositions set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688' ,
percentOut = '17.01'
where entryId = '23170523'
update current13Fpositions set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688' ,
percentOut = '6.3'
where entryId = '37276910'
update current13Fpositions set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688' ,
percentOut = '35.5'
where entryId = '42230587'
update current13Fpositions set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688' ,
percentOut = '0'
where entryId = '80392208'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '27826D106'
Number of Rows :163
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '970384'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '67744894'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '67905992'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '67507071'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '65671853'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '66460667'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '66788421'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '68168566'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '67702194'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '67872308'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '67821780'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '67894349'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '66366490'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '66074074'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '66142550'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '66131566'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '66913109'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '66096831'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '66983730'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '67112768'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '66823817'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '66705508'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '66039343'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '65659833'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '65377799'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '65801783'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '65350077'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '66388675'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '65460390'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '65025063'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '63405943'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '63457291'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '63416651'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '63723522'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '63804936'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '63749536'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '64005190'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '63871819'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '64472353'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '64272037'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '64392206'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '65123200'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '63825337'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '64374830'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '64335339'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '64733875'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '64651207'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '68394532'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '70191446'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '68647514'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '68429659'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '69872575'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '68770999'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '68948319'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '69130157'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '69803863'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '69335604'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '69612812'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '69409621'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '69397143'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '69376367'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '69680357'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '70182837'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '70233579'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '70065525'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '70499791'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '70226433'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '70719445'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '70823029'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '71106182'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '70308149'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '71211616'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '71560488'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '71624001'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '71189648'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '71409006'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '70998377'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '71391016'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '72107937'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '72134936'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '72746593'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '72479569'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '72805628'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '72299240'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '72902425'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '72196510'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '72540147'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '73511852'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '73350770'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '73569041'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '73736317'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '73324330'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '73195438'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '73497909'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '73456622'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '74243519'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '74026788'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '74118637'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '74130224'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '75307983'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '74285429'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '74483393'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '74462141'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '75390854'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '75123623'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '75354124'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '75468566'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '75456664'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '75062243'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '75671226'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '74927592'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '75234646'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '75774693'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '76942222'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '75787296'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '76053376'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '76548978'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '76611699'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '76384534'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '77603727'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '77629407'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '77440748'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '75825203'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '76872731'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '77071892'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '77257708'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '76736731'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '77005677'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '77312909'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '77296552'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '76906707'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '78114349'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '78750181'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '78465648'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '78071935'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '77801893'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '78301902'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '78019285'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '78219705'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '78669820'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '78862834'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '79149729'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '79195015'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '79528922'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '79300893'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '79553682'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '79625901'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '78945358'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '79918760'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '80386229'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '80425412'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '80946365'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '79931779'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '80386921'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '81503988'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '81496607'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '81550953'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '81548299'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '81527677'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '81532012'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '81538397'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '81611633'
update archive13F set
compid = '131051',
sectorNum = '302002',
sectorDes = 'Closed - End Fund - Debt',
issuerCik = '0001074688'
where entryId = '51108845'
End Function
The Script is complete, exiting....