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: : 130609
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130609'
The Shares Amount is 144912000
The cusip is 604675991
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '604675991'
Number of Rows :4
update current13Fpositions set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775' ,
percentOut = '0.03'
where entryId = '42196464'
update current13Fpositions set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775' ,
percentOut = '0'
where entryId = '42468648'
update current13Fpositions set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775' ,
percentOut = '1.08'
where entryId = '57152805'
update current13Fpositions set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775' ,
percentOut = '1.48'
where entryId = '70540312'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '604675991'
Number of Rows :143
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '66276673'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '67150447'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '67544024'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '67381112'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '68334090'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '67043216'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '66842387'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '68018380'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '66682649'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '65081612'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '62487887'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '66562735'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '66905339'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '66952708'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '66856505'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '65270871'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '67543819'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '67020035'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '68522740'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '66626602'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '65588496'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '65843348'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '65416571'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '65370724'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '65876504'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '65313928'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '65379374'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '65237332'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '66068302'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '65178909'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '63427316'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '63476126'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '63487257'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '63639643'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '63603834'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '63779881'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '63743239'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '63933300'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '64077835'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '63895773'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '64024492'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '64670811'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '64542239'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '68523360'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '68539818'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '68562643'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '68613986'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '69279194'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '68891468'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '67219051'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '67499812'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '69176714'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '68912486'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '70045155'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '68911400'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '70094853'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '71682542'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '71669177'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '70288769'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '70083815'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '70436574'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '70510964'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '70539926'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '69431348'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '70427765'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '71184596'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '72924279'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '71989254'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '72446696'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '72096014'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '72208005'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '72392216'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '72430535'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '72175550'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '73179704'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '73743266'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '73005114'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '73809324'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '73810640'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '73863305'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '74123535'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '75695521'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '74667347'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '73959354'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '74339036'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '74754510'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '75218290'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '74850312'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '74082753'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '75710488'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '75773634'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '75820262'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '76612866'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '77646291'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '76723505'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '77575863'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '77634465'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '77363662'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '76236164'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '76151170'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '77775112'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '77748950'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '77740657'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '78278597'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '77828736'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '80373691'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '79447638'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '79076912'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '78202168'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '77781532'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '79476983'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '78322469'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '77849563'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '79783478'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '79816843'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '79945742'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '80374191'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '79923141'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '80394147'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '80361056'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '80289627'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '81645030'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '80383129'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '79724893'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '81620470'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '81757338'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '81758146'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '81764282'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '81762660'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '82173430'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '82177235'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '81974178'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '83560954'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '83604443'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '85465490'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '87695641'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '90816074'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '92571126'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '94373870'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '96560746'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '98788321'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '100818249'
update archive13F set
compid = '130609',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001010775'
where entryId = '103292821'
End Function
The Script is complete, exiting....