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: : 130747
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130747'
The Shares Amount is 900000
The cusip is 74348A376
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '74348A376'
Number of Rows :11
update current13Fpositions set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569' ,
percentOut = '69.62'
where entryId = '51215358'
update current13Fpositions set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569' ,
percentOut = '0'
where entryId = '65231518'
update current13Fpositions set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569' ,
percentOut = '0.02'
where entryId = '130803660'
update current13Fpositions set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569' ,
percentOut = '0'
where entryId = '130202655'
update current13Fpositions set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569' ,
percentOut = '275.88'
where entryId = '131178301'
update current13Fpositions set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569' ,
percentOut = '0'
where entryId = '94718397'
update current13Fpositions set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569' ,
percentOut = '0'
where entryId = '130439083'
update current13Fpositions set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569' ,
percentOut = '5.56'
where entryId = '130771193'
update current13Fpositions set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569' ,
percentOut = '22.94'
where entryId = '131716824'
update current13Fpositions set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569' ,
percentOut = '0'
where entryId = '130476293'
update current13Fpositions set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569' ,
percentOut = '11.11'
where entryId = '132511670'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '74348A376'
Number of Rows :250
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '68055409'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '65664621'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '67707496'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '66849224'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '68026193'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '66589688'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '66591190'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '66321177'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '66590135'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '65218269'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '65636686'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '65438709'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '63389300'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '63440549'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '63469993'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '63669622'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '64220412'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '64592101'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '64924313'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '64552700'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '64813745'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '64656436'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '68578328'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '67266581'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '70811198'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '69608695'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '69978213'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '69558326'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '69969535'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '71646795'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '70871053'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '71403209'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '71609125'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '71195095'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '73539396'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '72775436'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '72812377'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '73428017'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '73601697'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '73748254'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '72557665'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '74838753'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '75489655'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '74780561'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '75249416'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '75458420'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '75067856'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '75034767'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '77598403'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '77207884'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '77011557'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '77336680'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '77381569'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '77298555'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '77632665'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '78182104'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '78673854'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '78868675'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '79087829'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '79196883'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '79235261'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '79293012'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '80414277'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '81294602'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '81135586'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '81365750'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '81020451'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '81532204'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '81354468'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '81381494'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '83669146'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '82488961'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '82546659'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '82627035'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '82742260'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '82940826'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '83075050'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '83593838'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '83440672'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '85270069'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '84280486'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '85492318'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '84686413'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '84868006'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '84585557'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '85107162'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '85303214'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '87733270'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '85875170'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '86566134'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '87642550'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '86895480'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '86961584'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '87353063'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '87681854'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '88394309'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '88132458'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '89290497'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '89765428'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '88430265'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '89134444'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '89162239'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '89445658'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '89631936'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '90124341'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '90329769'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '90355326'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '90353936'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '90693533'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '90953875'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '91381844'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '91724724'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '91885334'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '91493144'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '91808343'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '90893559'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '92200525'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '92525695'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '92660295'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '93099874'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '93867258'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '92345078'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '93152209'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '93312693'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '93421346'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '93448097'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '93870807'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '93557708'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '94041569'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '94382795'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '95277871'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '95869989'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '94432917'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '94720030'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '94870734'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '95580231'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '95976139'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '95972781'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '95809202'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '95882641'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '96200331'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '96577004'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '96226691'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '96708086'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '96886785'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '97924642'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '98004160'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '98375164'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '98608222'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '100661538'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '99259947'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '99390909'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '99199991'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '100387932'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '100477046'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '101497825'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '102142995'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '101910457'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '102188961'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '102472359'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '102727760'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '102809364'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '104054773'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '104848391'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '105014041'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '105470576'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '105300479'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '105183514'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '106453904'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '107841183'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '107272337'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '107465725'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '107518181'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '108262347'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '110132735'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '110725199'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '109118917'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '110680276'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '110040635'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '110729722'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '110776082'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '110528947'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '111221852'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '112606779'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '111836696'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '111875477'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '111929338'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '113254692'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '113691385'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '114185692'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '113982807'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '114886000'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '114404761'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '114460940'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '115846113'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '115606666'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '114842807'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '115404728'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '114811474'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '116284510'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '116673310'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '117449723'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '116892333'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '116985232'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '117260405'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '117418852'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '116501160'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '118602748'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '117806274'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '118337037'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '118576846'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '120181356'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '119032887'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '121394794'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '121206999'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '120672212'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '120636652'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '119908756'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '120712951'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '119261526'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '119687941'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '120008936'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '121386099'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '121756125'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '122460667'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '121699318'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '122642178'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '123569839'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '123298082'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '123601082'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '123256182'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '123255475'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '116741175'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '125181334'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '124813449'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '126822092'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '124467149'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '125470018'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '125376728'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '125388192'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '125412840'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '126515876'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '124445388'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '127404230'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '127647737'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '127865411'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '127831702'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '129750161'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '128421226'
update archive13F set
compid = '130747',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '9000000569'
where entryId = '127978611'
End Function
The Script is complete, exiting....