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: : 151578
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '151578'
The Shares Amount is 55604000
The cusip is 29359T102
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '29359T102'
Number of Rows :4
update current13Fpositions set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310' ,
percentOut = '0.05'
where entryId = '65086958'
update current13Fpositions set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310' ,
percentOut = '2.79'
where entryId = '65689795'
update current13Fpositions set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310' ,
percentOut = '0'
where entryId = '69358247'
update current13Fpositions set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310' ,
percentOut = '4.48'
where entryId = '79380001'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '29359T102'
Number of Rows :274
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '66004739'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '65802034'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '68150715'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '66131805'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '67966571'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '67592486'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '67760796'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '66984096'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '67745151'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '68229667'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '66097075'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '66915371'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '67856369'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '67061214'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '67615863'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '68279727'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '67552055'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '66366754'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '68033359'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '68361955'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '66637625'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '67689094'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '66722048'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '66460839'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '67894597'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '67872547'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '67161816'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '66334801'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '65174885'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '66223721'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '66206729'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '66298882'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '67656393'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '67783439'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '66528814'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '65866695'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '65859164'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '65765687'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '66431552'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '65382628'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '65434469'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '66118737'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '65525962'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '63391523'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '63405985'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '64033119'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '63723893'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '64151514'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '64031972'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '64173521'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '63872058'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '63915657'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '64237903'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '64615202'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '64566140'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '65123239'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '64701084'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '64475314'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '64153058'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '64361938'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '64810090'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '64375070'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '64335573'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '64734074'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '64651468'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '68765392'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '68069447'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '68695575'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '68776675'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '68873813'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '69185819'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '69360148'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '69664583'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '69789038'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '69939825'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '69335853'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '69190878'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '69423165'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '69039311'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '69974673'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '68978436'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '69397391'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '69478557'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '69376594'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '69461740'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '69706223'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '69056849'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '70177930'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '70334867'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '70546621'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '71474159'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '70807933'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '70844741'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '71106423'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '71652939'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '71313985'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '70390153'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '71533760'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '71685485'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '71685913'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '70357010'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '71670392'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '71624263'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '70907337'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '71519453'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '71242194'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '71410390'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '70941520'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '71544972'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '71170078'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '72090055'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '73705172'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '72665450'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '73080655'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '72953745'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '72389118'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '72356590'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '73215587'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '73081576'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '72780827'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '72540384'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '73553894'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '72615995'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '72431909'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '73716772'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '72813482'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '73613832'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '73154363'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '73534524'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '73373238'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '73324584'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '73023846'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '73172960'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '73292454'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '73456842'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '74158945'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '73977057'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '74796908'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '74159414'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '74119932'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '74314913'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '75494014'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '75577471'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '74343609'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '74765937'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '74338745'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '74483648'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '74592970'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '74205003'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '74689383'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '75468853'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '75367112'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '74879580'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '75456719'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '74868323'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '75148083'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '75285187'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '75637385'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '75671445'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '74897761'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '75380923'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '75084731'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '75032353'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '76082023'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '75930483'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '76027330'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '76224331'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '76384804'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '76487159'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '75824693'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '77624506'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '77402655'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '76911060'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '76838957'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '76992904'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '77626507'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '77670220'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '77625125'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '77231662'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '76212331'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '76667898'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '77005928'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '77080104'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '77313196'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '76206951'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '77621054'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '77042579'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '77614824'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '76812048'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '77793202'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '79505890'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '79237326'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '78524728'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '78569137'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '78515216'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '79098690'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '78302151'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '78362331'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '60901880'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '78953670'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '79138832'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '79424088'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '78669976'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '78680186'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '78772663'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '78815147'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '78852956'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '78863090'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '79212279'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '79301266'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '79335095'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '79121712'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '79550484'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '79650759'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '79831138'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '79720750'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '81652474'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '80310209'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '80102878'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '80900614'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '80019595'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '79970146'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '80326997'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '80739342'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '81001028'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '81129836'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '81627235'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '80176523'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '80314316'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '80643562'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '81016515'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '81496958'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '81068284'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '81086252'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '81502122'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '81146163'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '81178545'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '81333610'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '81346736'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '81538358'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '81424318'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '83566090'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '83564330'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '81838815'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '82173850'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '82468680'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '83532441'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '82675550'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '82604968'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '81758937'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '81844449'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '82616858'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '83549629'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '83560126'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '83540642'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '83071009'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '83573300'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '83576714'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '83575259'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '83563892'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '83593785'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '83597380'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '82457094'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '83591630'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '83571376'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '84601088'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '84651052'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '84682194'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '86919397'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '86957236'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '89157746'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '88952666'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '90949265'
update archive13F set
compid = '151578',
sectorNum = '1001001',
sectorDes = 'Electric Utilities',
issuerCik = '0001140310'
where entryId = '93843649'
End Function
The Script is complete, exiting....