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: : 130808
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130808'
The Shares Amount is 79445000
The cusip is 45822P105
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '45822P105'
Number of Rows :342
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.09'
where entryId = '7775333'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.36'
where entryId = '8273195'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.17'
where entryId = '8616722'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '2.2'
where entryId = '9341613'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '8.23'
where entryId = '9424627'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.02'
where entryId = '9679693'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '9.4'
where entryId = '9755260'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '6.14'
where entryId = '10223359'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '101.33'
where entryId = '10238720'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.88'
where entryId = '10835258'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '11038439'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '3.62'
where entryId = '11077169'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.28'
where entryId = '11180403'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '6282.08'
where entryId = '11217515'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '11251106'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.5'
where entryId = '11265305'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.12'
where entryId = '11324456'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.49'
where entryId = '11387753'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '29.39'
where entryId = '11449625'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '60.92'
where entryId = '11632603'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '3.7'
where entryId = '11778397'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.48'
where entryId = '11894357'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '12116205'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '12192309'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '270.47'
where entryId = '12230808'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.5'
where entryId = '12251009'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.17'
where entryId = '12287466'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.28'
where entryId = '12290770'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.21'
where entryId = '12319100'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '12326707'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.01'
where entryId = '12424059'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '13.48'
where entryId = '12446260'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '12446540'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.35'
where entryId = '12570223'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.1'
where entryId = '12629159'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.79'
where entryId = '12709312'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '60.42'
where entryId = '12716634'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.3'
where entryId = '12781023'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.71'
where entryId = '12809079'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '87.81'
where entryId = '12811240'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.43'
where entryId = '12846320'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.49'
where entryId = '12926649'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.1'
where entryId = '12934418'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.78'
where entryId = '13023578'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.43'
where entryId = '13242736'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '2'
where entryId = '13244779'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '5.88'
where entryId = '13456742'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.49'
where entryId = '13468691'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '13505140'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '11.1'
where entryId = '13507108'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '13671470'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '13678019'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.53'
where entryId = '13681417'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '4.27'
where entryId = '13684351'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '2.04'
where entryId = '13684657'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '13709680'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.77'
where entryId = '13717720'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '13818628'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.11'
where entryId = '13907529'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.28'
where entryId = '13932951'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.21'
where entryId = '13938376'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '13.92'
where entryId = '13965876'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '14019452'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '14132581'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.5'
where entryId = '14140350'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.88'
where entryId = '14193397'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '96.96'
where entryId = '14218845'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.42'
where entryId = '14231214'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '14297238'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.87'
where entryId = '14310084'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '3.3'
where entryId = '14327494'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '61.94'
where entryId = '14500582'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.01'
where entryId = '14552669'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.76'
where entryId = '14583618'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '6'
where entryId = '14610851'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.5'
where entryId = '14661334'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.09'
where entryId = '14665502'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.81'
where entryId = '14678708'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '14824215'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '2'
where entryId = '14875035'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.3'
where entryId = '14913125'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '14944238'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '11.13'
where entryId = '14954738'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.7'
where entryId = '15161795'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '4.27'
where entryId = '15162190'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '2.04'
where entryId = '15162494'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '15174899'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.33'
where entryId = '15179978'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.26'
where entryId = '15212674'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.35'
where entryId = '15258732'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '15263031'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.53'
where entryId = '15333232'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.01'
where entryId = '15336958'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.99'
where entryId = '15449936'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.02'
where entryId = '15461140'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '16.83'
where entryId = '15473282'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '13.72'
where entryId = '15590003'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '169.31'
where entryId = '15593949'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.1'
where entryId = '15618708'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '59.8'
where entryId = '15711739'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.62'
where entryId = '15730479'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.49'
where entryId = '15774602'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.78'
where entryId = '15815774'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.3'
where entryId = '15914745'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '103.55'
where entryId = '16000493'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '6'
where entryId = '16039812'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.06'
where entryId = '16117533'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.13'
where entryId = '16172986'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.03'
where entryId = '16175052'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.97'
where entryId = '16195004'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '16286146'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '11.14'
where entryId = '16304328'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.53'
where entryId = '16353084'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.53'
where entryId = '16354338'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '16521205'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.22'
where entryId = '16565848'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.67'
where entryId = '16566996'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.42'
where entryId = '16582626'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.15'
where entryId = '16610663'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '16615146'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '4.27'
where entryId = '16618602'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '2.04'
where entryId = '16618923'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '2.44'
where entryId = '16635447'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.48'
where entryId = '16703643'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '17'
where entryId = '16729097'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.35'
where entryId = '16763681'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '59.8'
where entryId = '16775161'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.7'
where entryId = '16776350'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.3'
where entryId = '16786616'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.97'
where entryId = '16835153'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '14.12'
where entryId = '16846144'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.75'
where entryId = '16908615'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.01'
where entryId = '16920093'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.13'
where entryId = '16939472'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.46'
where entryId = '16961484'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '174.58'
where entryId = '16963584'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.22'
where entryId = '17015442'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '104.44'
where entryId = '17022168'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.61'
where entryId = '17044713'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '17074445'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '6'
where entryId = '17091921'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.94'
where entryId = '17093840'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.02'
where entryId = '17098513'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '17105171'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.1'
where entryId = '17107809'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.75'
where entryId = '17157920'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '29.99'
where entryId = '17200376'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.34'
where entryId = '17275228'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.07'
where entryId = '17540793'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.6'
where entryId = '17557781'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.22'
where entryId = '17666139'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '17672739'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.53'
where entryId = '17727892'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '17787477'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.07'
where entryId = '17978645'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '11.49'
where entryId = '17987623'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '7.12'
where entryId = '17989669'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '18041492'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.46'
where entryId = '18048744'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.57'
where entryId = '18066108'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.69'
where entryId = '18066848'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '4.27'
where entryId = '18076324'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '2.04'
where entryId = '18076699'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '18091466'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.7'
where entryId = '18115938'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.38'
where entryId = '18116356'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.41'
where entryId = '18181674'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.01'
where entryId = '18293707'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.98'
where entryId = '18298268'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.02'
where entryId = '18304508'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.42'
where entryId = '18383035'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.26'
where entryId = '18540499'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '18551298'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.63'
where entryId = '18569278'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '75.32'
where entryId = '18625470'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '18658992'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.1'
where entryId = '18660401'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.82'
where entryId = '18672745'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.22'
where entryId = '18710603'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '18711316'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '14.14'
where entryId = '18776402'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '6'
where entryId = '18804931'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '9.42'
where entryId = '18805901'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.15'
where entryId = '19053681'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '19063322'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '178.92'
where entryId = '19064830'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.22'
where entryId = '19093034'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.1'
where entryId = '19115746'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.02'
where entryId = '19148421'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '19237283'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.28'
where entryId = '19269955'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '19555542'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '2.26'
where entryId = '19880453'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '23.1'
where entryId = '20167247'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.37'
where entryId = '20243450'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.18'
where entryId = '20390469'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '7.45'
where entryId = '20718550'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.04'
where entryId = '20791378'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '20894567'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '4.27'
where entryId = '21064930'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '2.04'
where entryId = '21065280'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '21182428'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '7.07'
where entryId = '21269697'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '22499994'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.65'
where entryId = '22639990'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '6.19'
where entryId = '23172481'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '23425219'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '8.2'
where entryId = '24086921'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.09'
where entryId = '24138438'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '24489547'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '24520884'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '24929031'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.08'
where entryId = '26369486'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.34'
where entryId = '26733865'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.11'
where entryId = '26773715'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.33'
where entryId = '28325643'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.21'
where entryId = '28730893'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.03'
where entryId = '28779487'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '28814666'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '4.79'
where entryId = '29135736'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '31252964'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '33.09'
where entryId = '31799473'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '2.66'
where entryId = '31891051'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.98'
where entryId = '32908019'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.01'
where entryId = '33346749'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '33878709'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '3.44'
where entryId = '34540744'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '2.56'
where entryId = '36185823'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.49'
where entryId = '36945186'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.65'
where entryId = '38324144'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '2.12'
where entryId = '38909462'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '3.2'
where entryId = '39309254'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '40618075'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '5.31'
where entryId = '40853733'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '95.75'
where entryId = '41651402'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '3.12'
where entryId = '41674751'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.03'
where entryId = '42060934'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '3.62'
where entryId = '42063392'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.01'
where entryId = '42069149'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.34'
where entryId = '42071003'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '2.77'
where entryId = '42074076'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '8.34'
where entryId = '42074887'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.5'
where entryId = '42079569'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.9'
where entryId = '42081362'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.75'
where entryId = '42082338'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.48'
where entryId = '42084985'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '2.94'
where entryId = '42086714'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '2.4'
where entryId = '42087066'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.13'
where entryId = '42092747'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '4.33'
where entryId = '42095208'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '42096648'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.07'
where entryId = '42099711'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '8.51'
where entryId = '42100861'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.64'
where entryId = '42101847'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.55'
where entryId = '42102373'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '2.17'
where entryId = '42103793'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '17.36'
where entryId = '42106215'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '79.49'
where entryId = '42108245'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '12.47'
where entryId = '42110416'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.1'
where entryId = '42112228'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.86'
where entryId = '42114826'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '32.3'
where entryId = '42118143'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.04'
where entryId = '42119861'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '2.84'
where entryId = '42121939'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.53'
where entryId = '42123149'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '7.44'
where entryId = '42125344'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.92'
where entryId = '42132850'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.29'
where entryId = '42134664'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.59'
where entryId = '42135646'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.46'
where entryId = '42136356'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '2.26'
where entryId = '42139697'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '3.4'
where entryId = '42141211'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.81'
where entryId = '42144066'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '2.7'
where entryId = '42146067'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '2.14'
where entryId = '42149241'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.59'
where entryId = '42152576'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.55'
where entryId = '42158281'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '6.43'
where entryId = '42163069'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.37'
where entryId = '42164579'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.08'
where entryId = '42166557'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.71'
where entryId = '42169950'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.58'
where entryId = '42173215'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '6.8'
where entryId = '42180163'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.35'
where entryId = '42181524'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '3.46'
where entryId = '42186566'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.03'
where entryId = '42190281'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '2.39'
where entryId = '42190925'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.02'
where entryId = '42193026'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '48.38'
where entryId = '42195837'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '2.96'
where entryId = '42199499'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.37'
where entryId = '42203963'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '3.13'
where entryId = '42205150'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.03'
where entryId = '42205912'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.02'
where entryId = '42206634'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.03'
where entryId = '42207450'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.01'
where entryId = '42209365'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.05'
where entryId = '42216507'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.76'
where entryId = '42221564'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.4'
where entryId = '42223335'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '6.33'
where entryId = '42224902'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '8.71'
where entryId = '42227061'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '73.89'
where entryId = '42229836'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.77'
where entryId = '42233021'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.03'
where entryId = '42235802'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '2.75'
where entryId = '42239522'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '13.77'
where entryId = '42245817'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '9.38'
where entryId = '42248999'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.87'
where entryId = '42250557'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '4.09'
where entryId = '42251356'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.02'
where entryId = '42252860'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '42457534'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '42459369'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '42459685'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '42459856'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '42461482'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '42468106'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.2'
where entryId = '43980094'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.5'
where entryId = '45405336'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '2.42'
where entryId = '45538826'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.1'
where entryId = '47118483'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1'
where entryId = '47250976'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.28'
where entryId = '47280873'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '5.8'
where entryId = '47969536'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '3.46'
where entryId = '48062096'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.71'
where entryId = '48477987'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '50527654'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '50561542'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.02'
where entryId = '50836695'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '49.63'
where entryId = '51212116'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '32.55'
where entryId = '51244851'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.04'
where entryId = '51508240'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.97'
where entryId = '51685818'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.01'
where entryId = '52243384'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.01'
where entryId = '53599853'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '53612144'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.04'
where entryId = '53700084'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0.07'
where entryId = '54162052'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '54220332'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '1.75'
where entryId = '54515435'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '54885218'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '55573878'
update current13Fpositions set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863' ,
percentOut = '0'
where entryId = '56833060'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '45822P105'
Number of Rows :15
update archive13F set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863'
where entryId = '67171515'
update archive13F set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863'
where entryId = '67076714'
update archive13F set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863'
where entryId = '63755776'
update archive13F set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863'
where entryId = '57184284'
update archive13F set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863'
where entryId = '51037438'
update archive13F set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863'
where entryId = '100678832'
update archive13F set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863'
where entryId = '96632985'
update archive13F set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863'
where entryId = '100678863'
update archive13F set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863'
where entryId = '100678895'
update archive13F set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863'
where entryId = '100678928'
update archive13F set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863'
where entryId = '100678960'
update archive13F set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863'
where entryId = '100678993'
update archive13F set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863'
where entryId = '100684177'
update archive13F set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863'
where entryId = '38278516'
update archive13F set
compid = '130808',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0000916863'
where entryId = '125369398'
End Function
The Script is complete, exiting....