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: : 130564
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130564'
The Shares Amount is 201322000
The cusip is 210371100
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '210371100'
Number of Rows :310
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '1.8'
where entryId = '1223705'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.92'
where entryId = '1264405'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '10.4'
where entryId = '1569571'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '1.16'
where entryId = '1701078'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.01'
where entryId = '1827314'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '2.81'
where entryId = '1858434'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.77'
where entryId = '1983452'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.01'
where entryId = '2207596'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '20.13'
where entryId = '2608184'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.36'
where entryId = '2827585'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '2.14'
where entryId = '2831352'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.66'
where entryId = '2883037'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '4.9'
where entryId = '3504227'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '3596512'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.56'
where entryId = '3682521'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '6.51'
where entryId = '3727845'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '2.41'
where entryId = '3916693'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.05'
where entryId = '5086696'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.2'
where entryId = '5194235'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '8.86'
where entryId = '5217634'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.53'
where entryId = '5264741'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '12.66'
where entryId = '6416123'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '1.61'
where entryId = '6910174'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '7536968'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.27'
where entryId = '7775252'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.37'
where entryId = '8272950'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '9027441'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '1.79'
where entryId = '9327443'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '3.63'
where entryId = '9341164'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.12'
where entryId = '9679470'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '3.28'
where entryId = '9754129'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '2.72'
where entryId = '10222999'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '157.57'
where entryId = '10232110'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '1.33'
where entryId = '10651158'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '10860266'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '11038311'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '11.64'
where entryId = '11102873'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.15'
where entryId = '11177052'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.44'
where entryId = '11225688'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '3.15'
where entryId = '11264622'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '11273830'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '11.43'
where entryId = '11387646'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '167.47'
where entryId = '11449297'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '4.82'
where entryId = '11464451'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.22'
where entryId = '11711818'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.56'
where entryId = '11778233'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '11819219'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '25.95'
where entryId = '11894214'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '12116090'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.54'
where entryId = '12135007'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '2.17'
where entryId = '12186431'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.1'
where entryId = '12191866'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.29'
where entryId = '12236569'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '3.8'
where entryId = '12286700'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '6.47'
where entryId = '12318362'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '12326594'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.21'
where entryId = '12341426'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '12.16'
where entryId = '12389423'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '12417935'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.01'
where entryId = '12423799'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.21'
where entryId = '12466061'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '12562613'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.97'
where entryId = '12581790'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.02'
where entryId = '12628924'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '1.25'
where entryId = '12655298'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.51'
where entryId = '12709070'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.57'
where entryId = '12709639'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.22'
where entryId = '12727088'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.7'
where entryId = '12778888'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.12'
where entryId = '12808474'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '3.15'
where entryId = '12845622'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.01'
where entryId = '12934075'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.97'
where entryId = '12986909'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.44'
where entryId = '13022744'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.4'
where entryId = '13242496'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.41'
where entryId = '13243764'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.56'
where entryId = '13244621'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '13276037'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '13455632'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.81'
where entryId = '13467649'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '13504921'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.19'
where entryId = '13647754'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.05'
where entryId = '13669320'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '13677908'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.69'
where entryId = '13684288'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.52'
where entryId = '13684591'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '13817346'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '13847726'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.2'
where entryId = '13850790'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.03'
where entryId = '13907269'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '6.47'
where entryId = '13937665'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.21'
where entryId = '13949092'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.01'
where entryId = '13968348'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.26'
where entryId = '13980669'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '14019346'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.03'
where entryId = '14045481'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.45'
where entryId = '14073759'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.97'
where entryId = '14106439'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '189.17'
where entryId = '14129125'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '1.25'
where entryId = '14149222'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.27'
where entryId = '14157093'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.56'
where entryId = '14193232'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '3.91'
where entryId = '14230545'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '14297024'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.4'
where entryId = '14309829'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '3.35'
where entryId = '14326853'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '3.2'
where entryId = '14330774'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.76'
where entryId = '14332579'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '14552413'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.14'
where entryId = '14568434'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.15'
where entryId = '14583011'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.81'
where entryId = '14661001'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.97'
where entryId = '14671679'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.41'
where entryId = '14677912'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '14822686'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.38'
where entryId = '14870171'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '3.02'
where entryId = '14873189'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '14885738'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '14944125'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '1.24'
where entryId = '14951760'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '15087101'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '2.86'
where entryId = '15132935'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.28'
where entryId = '15133873'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.69'
where entryId = '15162131'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.52'
where entryId = '15162431'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '15174786'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.19'
where entryId = '15216170'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '6.2'
where entryId = '15257996'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '15261676'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '15264503'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.19'
where entryId = '15335555'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '15336709'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.91'
where entryId = '15449527'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.01'
where entryId = '15461016'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.82'
where entryId = '15472684'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.23'
where entryId = '15557684'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '2.11'
where entryId = '15577396'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.01'
where entryId = '15594631'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.06'
where entryId = '15618403'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '1.8'
where entryId = '15620706'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.93'
where entryId = '15627430'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.45'
where entryId = '15634983'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.43'
where entryId = '15730310'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '15745825'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.15'
where entryId = '15760000'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '3.79'
where entryId = '15773931'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.17'
where entryId = '15815799'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.12'
where entryId = '15816946'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.38'
where entryId = '15890872'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.43'
where entryId = '15994379'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.43'
where entryId = '15994470'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.43'
where entryId = '15994558'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.41'
where entryId = '15994645'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.41'
where entryId = '15994736'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.34'
where entryId = '15994828'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.27'
where entryId = '15994918'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.41'
where entryId = '15995011'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.41'
where entryId = '15995098'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.41'
where entryId = '15995185'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.41'
where entryId = '15995272'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.16'
where entryId = '16028749'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '3.02'
where entryId = '16080191'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '1.4'
where entryId = '16110502'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.49'
where entryId = '16117201'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.1'
where entryId = '16172851'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '2.01'
where entryId = '16173968'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.45'
where entryId = '16194158'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '16284943'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.42'
where entryId = '16352814'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.42'
where entryId = '16354068'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '16434437'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '16520989'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.68'
where entryId = '16566912'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.32'
where entryId = '16610384'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '16615038'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.69'
where entryId = '16618543'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.52'
where entryId = '16618856'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.25'
where entryId = '16672978'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.29'
where entryId = '16680569'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.29'
where entryId = '16681625'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.29'
where entryId = '16681919'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.29'
where entryId = '16682243'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.29'
where entryId = '16682574'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.29'
where entryId = '16682903'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.28'
where entryId = '16683221'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.28'
where entryId = '16683538'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '16691234'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.5'
where entryId = '16703537'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '5.64'
where entryId = '16762940'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '16795467'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.25'
where entryId = '16800018'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '2.62'
where entryId = '16824912'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.89'
where entryId = '16834764'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '16919848'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '16945584'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '16950396'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '16955089'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.65'
where entryId = '16978528'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.2'
where entryId = '17014797'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '3.53'
where entryId = '17044088'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.01'
where entryId = '17051930'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '17074018'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '1.24'
where entryId = '17093813'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.01'
where entryId = '17098387'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '17107510'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '1.07'
where entryId = '17157763'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.67'
where entryId = '17160472'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.45'
where entryId = '17161506'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '29.84'
where entryId = '17197125'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '4.42'
where entryId = '17274762'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.38'
where entryId = '17367571'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.5'
where entryId = '17432823'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.12'
where entryId = '17468173'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '17482377'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '17526121'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '3.12'
where entryId = '17531598'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.49'
where entryId = '17540452'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.03'
where entryId = '17557513'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '1.19'
where entryId = '17560696'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '17671439'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '17787119'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '17813379'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.55'
where entryId = '17977799'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '7.41'
where entryId = '17989515'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '248.98'
where entryId = '17990342'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '18041280'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '18046025'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '1.34'
where entryId = '18048379'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.6'
where entryId = '18066772'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.11'
where entryId = '18067257'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.69'
where entryId = '18076243'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.52'
where entryId = '18076618'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '18091352'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '1.2'
where entryId = '18123953'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '6.76'
where entryId = '18177136'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '6.74'
where entryId = '18180976'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '18194921'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '18214056'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.01'
where entryId = '18252845'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '18293472'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.9'
where entryId = '18297864'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.01'
where entryId = '18304379'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.14'
where entryId = '18373885'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '3.29'
where entryId = '18382424'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '2.31'
where entryId = '18548828'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '18550956'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.01'
where entryId = '18568689'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '18660127'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.45'
where entryId = '18672809'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '18711102'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.04'
where entryId = '18761382'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '8.7'
where entryId = '18805649'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.73'
where entryId = '18818429'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '18823962'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '2.13'
where entryId = '18834314'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '19063169'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '19093112'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '8.7'
where entryId = '19111990'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '1'
where entryId = '19115410'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.43'
where entryId = '19147591'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '19236049'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '19555426'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '19880282'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '7.1'
where entryId = '20167851'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.34'
where entryId = '20243253'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.55'
where entryId = '20306903'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.65'
where entryId = '20307162'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.98'
where entryId = '20718499'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '2.5'
where entryId = '21064851'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '1.15'
where entryId = '21065201'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '21182312'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '22499879'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.31'
where entryId = '22686452'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.72'
where entryId = '22688238'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.43'
where entryId = '23146151'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '3.4'
where entryId = '23169707'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '1.19'
where entryId = '23355560'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '1.13'
where entryId = '24086804'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '24505279'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '24519890'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '24928523'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.47'
where entryId = '25062518'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.35'
where entryId = '26216381'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '2.99'
where entryId = '26733775'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.42'
where entryId = '26773623'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '27406121'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '27406134'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '28136482'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.34'
where entryId = '28325569'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '2.71'
where entryId = '28684992'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.25'
where entryId = '28730781'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.01'
where entryId = '28779161'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '9.13'
where entryId = '29136899'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.02'
where entryId = '30017709'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '31252762'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.68'
where entryId = '31889189'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '32575123'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '10.06'
where entryId = '32907632'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '1.18'
where entryId = '33103209'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.02'
where entryId = '33231666'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '33878639'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '3.4'
where entryId = '34540604'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.05'
where entryId = '35073712'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '35470077'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '35974991'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '36595644'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.25'
where entryId = '129884495'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0'
where entryId = '130458789'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.07'
where entryId = '119399664'
update current13Fpositions set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440' ,
percentOut = '0.05'
where entryId = '130932379'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '210371100'
Number of Rows :46
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '3688012'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '4399349'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '5240368'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '77780393'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '79944625'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '81762370'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '83866128'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '86101716'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '87802712'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '90134099'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '90813896'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '92568835'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '92204111'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '94253184'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '94371462'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '96027742'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '96558232'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '98785666'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '98416637'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '100815500'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '100988666'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '103292216'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '103549081'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '105763739'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '108342378'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '108827586'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '109067391'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '108966977'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '110950245'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '111854641'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '112740373'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '111130417'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '113715447'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '114534287'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '114286132'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '116102273'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '116239499'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '116760130'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '118910801'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '119645229'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '121475541'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '122409232'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '124149585'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '124954017'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '127038360'
update archive13F set
compid = '130564',
sectorNum = '1001005',
sectorDes = 'Multi Utilities',
issuerCik = '0001004440'
where entryId = '127815156'
End Function
The Script is complete, exiting....