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: : 130721
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130721'
The Shares Amount is 8645000
The cusip is 860326107
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '860326107'
Number of Rows :4
update current13Fpositions set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860' ,
percentOut = '6.24'
where entryId = '51216741'
update current13Fpositions set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860' ,
percentOut = '16.81'
where entryId = '52199255'
update current13Fpositions set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860' ,
percentOut = '2.03'
where entryId = '65691991'
update current13Fpositions set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860' ,
percentOut = '1.08'
where entryId = '65722018'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '860326107'
Number of Rows :359
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '67371908'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '66590296'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '66994504'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '67708800'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '68127228'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '66744623'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '66646445'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '65330286'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '67559221'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '65493388'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '67638604'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '68053032'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '68369052'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '66373358'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '66944630'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '66787155'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '68361136'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '66318588'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '67338724'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '66590795'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '66705597'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '65758661'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '65360817'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '65712319'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '65988567'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '65131400'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '65123288'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '66125920'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '63412934'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '64057261'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '63733569'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '64008598'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '64195635'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '63964409'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '63917866'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '64212312'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '64589695'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '64381747'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '64729886'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '64657694'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '68696829'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '68636864'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '68429756'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '68496905'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '67225247'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '68617853'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '69275564'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '69361214'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '69141596'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '69225587'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '69012590'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '69493354'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '69888979'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '69198083'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '69608956'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '69977429'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '69100365'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '70044472'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '69426849'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '68643189'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '70137613'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '70233650'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '70238088'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '70170489'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '70435074'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '71659873'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '70509741'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '70731084'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '71028218'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '69079895'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '71336775'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '70563555'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '71014994'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '71639559'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '71046445'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '71583440'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '71593565'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '71749867'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '71196408'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '71011205'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '71754044'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '72026001'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '72452539'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '72367026'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '72130419'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '72431401'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '72491460'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '72191310'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '72465745'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '72638791'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '72884214'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '73011907'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '73244648'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '73583892'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '73593348'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '73686402'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '72517401'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '73274527'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '73331395'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '73058364'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '73208765'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '73451629'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '74819934'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '73817762'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '73967040'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '74022818'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '73873961'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '73992727'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '74042071'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '74141745'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '74804085'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '74819852'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '74958412'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '74386121'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '74615294'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '74945010'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '75690753'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '75320070'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '74979147'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '75432118'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '75443551'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '75554101'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '75015788'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '75069203'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '75666340'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '74941129'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '75230623'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '75091855'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '75813919'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '75950625'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '76014224'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '75826737'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '76065046'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '75969212'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '76150454'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '77328459'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '76510274'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '76890584'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '76923705'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '76962236'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '77397238'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '76342260'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '77631144'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '77000045'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '77286999'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '76280856'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '77278365'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '76241081'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '76232234'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '77528010'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '77180170'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '77012945'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '76718748'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '76886562'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '77772680'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '77834228'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '78067201'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '77798063'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '78114830'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '78159373'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '78385353'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '78030992'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '78749735'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '78763562'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '79507956'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '79456475'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '78475560'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '78642795'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '78674785'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '78786272'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '78825472'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '78870103'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '79165927'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '79178596'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '79312612'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '79473738'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '79416901'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '79454538'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '79640272'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '79657898'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '79070296'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '78649105'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '79722486'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '80038014'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '80157934'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '79898452'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '80125791'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '80422767'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '80565626'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '81467120'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '81580517'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '80929592'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '81616732'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '80478498'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '79828080'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '80560766'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '81137007'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '81325238'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '81366326'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '81478007'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '81495122'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '81021319'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '81051441'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '81080990'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '81502228'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '81153287'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '81219574'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '81326815'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '81360529'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '81385425'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '81404198'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '81479533'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '81773254'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '81778871'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '82440526'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '82441884'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '82592272'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '82928780'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '82068545'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '82544629'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '83150828'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '83025073'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '83473609'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '82491008'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '82218811'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '82676528'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '82743572'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '82909389'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '82941134'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '83075945'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '83120780'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '83181880'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '82305673'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '83580845'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '83311052'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '83377593'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '83411195'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '83596876'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '83601837'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '82497293'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '83818945'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '83861458'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '83712593'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '83853037'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '83830890'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '84173540'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '84172801'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '84171745'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '84165830'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '84236541'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '83958708'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '85270363'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '85712216'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '84282602'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '84601103'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '84438805'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '84482962'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '84512514'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '84601155'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '84687349'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '84764855'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '84768145'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '85481416'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '84805483'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '85519209'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '84869346'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '84894518'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '84902588'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '84950716'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '85028197'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '85070305'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '85128043'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '85144506'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '85200981'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '85538313'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '85541378'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '85300113'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '85356810'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '85608647'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '86075528'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '85965847'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '86295853'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '85933333'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '86221759'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '86570578'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '86682327'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '86728887'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '86914856'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '87200360'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '86464720'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '87496008'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '87706512'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '86231637'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '86232347'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '86233149'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '86572680'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '86677570'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '86705280'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '86726625'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '86897607'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '86938583'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '86962550'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '87025003'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '87076598'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '87095712'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '87140509'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '87645778'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '87280387'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '87308546'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '87353513'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '87387335'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '87670350'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '87455359'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '87527910'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '87554732'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '87569786'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '87370450'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '87798143'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '88147094'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '88151310'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '88956796'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '89704302'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '89706694'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '88520059'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '88954889'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '88955801'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '88927745'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '88932874'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '89117573'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '89115652'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '89716407'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '89716719'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '89163237'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '89720242'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '89720489'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '89721666'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '89729413'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '89730209'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '89732403'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '89733317'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '89709052'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '89739992'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '89741612'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '89742836'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '89743155'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '89700835'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '89700744'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '89700699'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '89703272'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '89799124'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '89717986'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '90954893'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '93843108'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '51038467'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '85109592'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '96634000'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '98135588'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '87028929'
update archive13F set
compid = '130721',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001023860'
where entryId = '106365982'
End Function
The Script is complete, exiting....