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: : 130702
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130702'
The Shares Amount is 169399000
The cusip is 017361106
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '017361106'
Number of Rows :224
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.43'
where entryId = '1223360'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.9'
where entryId = '1264055'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '28'
where entryId = '1569308'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '292.88'
where entryId = '1788630'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.04'
where entryId = '1827010'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '2.06'
where entryId = '2830634'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.45'
where entryId = '3503143'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.75'
where entryId = '3682375'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '6'
where entryId = '3725789'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.63'
where entryId = '3916345'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.15'
where entryId = '4112951'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '4436120'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.02'
where entryId = '5086591'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.31'
where entryId = '5217196'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '3.62'
where entryId = '5264695'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.34'
where entryId = '5468710'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.32'
where entryId = '6415905'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.58'
where entryId = '7429381'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.02'
where entryId = '7792981'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '2.38'
where entryId = '9227067'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '12.31'
where entryId = '9340742'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.05'
where entryId = '9679273'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '6.06'
where entryId = '9753118'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.09'
where entryId = '10222626'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '96.48'
where entryId = '10226072'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '2.8'
where entryId = '11065950'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.01'
where entryId = '11068026'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.63'
where entryId = '11076785'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '23.24'
where entryId = '11102602'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.51'
where entryId = '11194672'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.75'
where entryId = '11263975'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '27.26'
where entryId = '11387538'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '51.37'
where entryId = '11448985'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '20.66'
where entryId = '11893841'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '12115977'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '9.6'
where entryId = '12170422'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '12192440'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.37'
where entryId = '12208968'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.11'
where entryId = '12301053'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.35'
where entryId = '12317691'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '12326483'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '12423559'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '12562285'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.62'
where entryId = '12581702'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.01'
where entryId = '12628724'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '10.16'
where entryId = '12655230'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.24'
where entryId = '12709392'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.75'
where entryId = '12807942'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.75'
where entryId = '12844969'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.22'
where entryId = '12926458'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.01'
where entryId = '12933768'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.77'
where entryId = '13021969'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.51'
where entryId = '13243621'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.51'
where entryId = '13450979'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.44'
where entryId = '13467405'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '11.33'
where entryId = '13644246'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '13671607'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.09'
where entryId = '13671980'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '13677797'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.2'
where entryId = '13900023'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.01'
where entryId = '13907044'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.33'
where entryId = '13936995'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.01'
where entryId = '13968225'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '14019234'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '33.93'
where entryId = '14149151'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.76'
where entryId = '14229934'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '14266204'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '3.45'
where entryId = '14326309'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '8.34'
where entryId = '14330767'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '14510581'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '14552179'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '3.11'
where entryId = '14648876'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.45'
where entryId = '14660696'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.76'
where entryId = '14677134'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '14821094'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.72'
where entryId = '14870029'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '3.14'
where entryId = '14871559'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '9.6'
where entryId = '14912142'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '14944013'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.34'
where entryId = '15097127'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '15132578'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '15174676'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.33'
where entryId = '15196062'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.33'
where entryId = '15257324'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '15261568'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '15336482'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.75'
where entryId = '15399700'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '15447417'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.02'
where entryId = '15449163'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.01'
where entryId = '15460896'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '3.31'
where entryId = '15467995'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.01'
where entryId = '15594599'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.01'
where entryId = '15618129'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '40.3'
where entryId = '15627343'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.76'
where entryId = '15773331'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.63'
where entryId = '15890732'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '3.04'
where entryId = '15994268'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '2.77'
where entryId = '15994354'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '2.16'
where entryId = '15994443'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '2.23'
where entryId = '15994529'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.71'
where entryId = '15994619'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.67'
where entryId = '15994707'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.67'
where entryId = '15994799'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.23'
where entryId = '15994891'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.71'
where entryId = '15994985'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.71'
where entryId = '15995072'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.71'
where entryId = '15995159'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.71'
where entryId = '15995246'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.21'
where entryId = '16028519'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '182.02'
where entryId = '16077301'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '5.48'
where entryId = '16105052'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.01'
where entryId = '16109504'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '2.61'
where entryId = '16110458'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '16110674'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.15'
where entryId = '16116900'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.76'
where entryId = '16193330'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '16244698'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '16283696'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '4.72'
where entryId = '16362427'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '9.6'
where entryId = '16393007'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.32'
where entryId = '16565616'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.33'
where entryId = '16596541'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.36'
where entryId = '16608580'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.07'
where entryId = '16610123'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '16614928'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.57'
where entryId = '16703428'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.33'
where entryId = '16762254'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.01'
where entryId = '16834411'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '16873867'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '16919623'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.14'
where entryId = '16937852'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.26'
where entryId = '16982530'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '13.64'
where entryId = '17005475'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '92.96'
where entryId = '17009458'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.23'
where entryId = '17014242'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.78'
where entryId = '17043483'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.01'
where entryId = '17051918'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '17073644'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.01'
where entryId = '17098267'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '17107234'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '51.82'
where entryId = '17130296'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.01'
where entryId = '17135423'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '33.72'
where entryId = '17194171'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.2'
where entryId = '17274339'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.08'
where entryId = '17301992'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.1'
where entryId = '17367444'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '17532753'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.15'
where entryId = '17540153'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.03'
where entryId = '17557252'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '17663517'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '17670125'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '17786796'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '17813387'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.25'
where entryId = '17858940'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.77'
where entryId = '17976997'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '6.49'
where entryId = '17989358'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.51'
where entryId = '18048335'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '18091247'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.33'
where entryId = '18180336'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.91'
where entryId = '18258544'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '18261096'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '18293260'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.02'
where entryId = '18297513'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.01'
where entryId = '18304261'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.8'
where entryId = '18381869'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.72'
where entryId = '18548706'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '18550629'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.01'
where entryId = '18568163'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '18659883'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.73'
where entryId = '18755423'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '9.76'
where entryId = '18805405'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '55.78'
where entryId = '18834248'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '18915297'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.83'
where entryId = '18944237'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '19013156'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.17'
where entryId = '19052165'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '19063027'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.29'
where entryId = '19092934'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.17'
where entryId = '19115112'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.82'
where entryId = '19146775'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '19234812'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '2.89'
where entryId = '19263697'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '19555322'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '5.73'
where entryId = '19880087'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.24'
where entryId = '19987873'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '23.61'
where entryId = '20167054'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '2.05'
where entryId = '20167465'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.38'
where entryId = '20243068'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.89'
where entryId = '20307136'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '70.68'
where entryId = '20390530'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '20681617'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '20686295'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '21182208'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.87'
where entryId = '21269663'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '9.06'
where entryId = '21932670'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '22499776'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.01'
where entryId = '22560246'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.6'
where entryId = '22865330'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '2.01'
where entryId = '23061948'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.64'
where entryId = '23067618'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.99'
where entryId = '23146030'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '26.09'
where entryId = '23167147'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '23425334'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '3.14'
where entryId = '23468470'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '6.49'
where entryId = '24075308'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.75'
where entryId = '24086692'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.05'
where entryId = '24137957'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '24519030'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '12.29'
where entryId = '24604872'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '24928073'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '27136551'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '27406855'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '17.78'
where entryId = '27469475'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '1.48'
where entryId = '27475301'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.25'
where entryId = '28730677'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.7'
where entryId = '28748956'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.15'
where entryId = '28778911'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0.33'
where entryId = '28956466'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '4.29'
where entryId = '29136832'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '5.97'
where entryId = '29332289'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '258.12'
where entryId = '29663988'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '30835249'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '31253530'
update current13Fpositions set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673' ,
percentOut = '0'
where entryId = '130457961'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '017361106'
Number of Rows :30
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '77779724'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '79943958'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '32247891'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '81762823'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '83865457'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '86101068'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '87802063'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '90133474'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '90813044'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '92567950'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '92203505'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '94252567'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '94370525'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '96027118'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '96557259'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '98784630'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '98415998'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '100814432'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '100988027'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '103291402'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '103548421'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '105763002'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '109066641'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '111853884'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '114285373'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '116759371'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '119644445'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '122408425'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '124953206'
update archive13F set
compid = '130702',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0000003673'
where entryId = '127814340'
End Function
The Script is complete, exiting....