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: : 130970
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130970'
The Shares Amount is 117286000
The cusip is 90262T308
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '90262T308'
Number of Rows :119
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '1.55'
where entryId = '1209411'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0.02'
where entryId = '2207942'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '18.77'
where entryId = '2420594'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '27.33'
where entryId = '3127996'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0'
where entryId = '3167868'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '26.63'
where entryId = '3507424'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0'
where entryId = '3685847'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '9.77'
where entryId = '3734615'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0'
where entryId = '3885514'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '6.59'
where entryId = '3917816'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '4.26'
where entryId = '5274388'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '6.36'
where entryId = '7430442'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0.25'
where entryId = '8301393'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0.86'
where entryId = '9342546'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '4.34'
where entryId = '9757627'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '161.5'
where entryId = '10251532'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '1.23'
where entryId = '10548999'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '11.64'
where entryId = '10683615'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '37.98'
where entryId = '11119017'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '1.23'
where entryId = '11180533'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '2051.99'
where entryId = '11217691'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '2.65'
where entryId = '11266735'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '6.64'
where entryId = '12131703'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0'
where entryId = '12328347'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '59.02'
where entryId = '12418245'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '9.02'
where entryId = '12447617'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '3.12'
where entryId = '12449122'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '3.48'
where entryId = '12710178'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '36.63'
where entryId = '12723479'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '1.34'
where entryId = '12779274'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '1.23'
where entryId = '12781148'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '193.63'
where entryId = '12810146'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '127.01'
where entryId = '12811398'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '22.41'
where entryId = '12847799'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0.04'
where entryId = '13025374'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0.22'
where entryId = '13468836'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0'
where entryId = '13678821'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0'
where entryId = '13818712'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '1.64'
where entryId = '13928716'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '7.72'
where entryId = '13999231'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '1.23'
where entryId = '14045692'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '3.48'
where entryId = '14074316'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '141.66'
where entryId = '14219000'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '2.31'
where entryId = '14232656'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '26.37'
where entryId = '14299882'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '8.97'
where entryId = '14328697'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '99.1'
where entryId = '14378855'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '1'
where entryId = '14568725'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0.22'
where entryId = '14662020'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0'
where entryId = '14827591'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0.07'
where entryId = '14878929'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '1.23'
where entryId = '15054325'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '1.64'
where entryId = '15199075'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0'
where entryId = '15262595'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0'
where entryId = '15279546'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0'
where entryId = '15447627'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '4.8'
where entryId = '15450738'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '3.48'
where entryId = '15635497'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '1'
where entryId = '15760402'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '1.48'
where entryId = '15776085'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '20.3'
where entryId = '15876504'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0.32'
where entryId = '15973126'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0.32'
where entryId = '15973512'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0.08'
where entryId = '16118211'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0.04'
where entryId = '16196913'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '3.62'
where entryId = '16565443'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0'
where entryId = '16615962'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '6.57'
where entryId = '16765223'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '4.76'
where entryId = '16835950'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '1.42'
where entryId = '16848796'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0.02'
where entryId = '16939575'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '74'
where entryId = '16960734'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '28.27'
where entryId = '16961970'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '1.68'
where entryId = '17008224'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '71.19'
where entryId = '17009674'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0.75'
where entryId = '17016645'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '1.74'
where entryId = '17046125'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '4.42'
where entryId = '17157883'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '3.11'
where entryId = '17161991'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '23'
where entryId = '17302063'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '17.26'
where entryId = '17350470'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '2.25'
where entryId = '17383627'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '1.23'
where entryId = '17436916'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0.23'
where entryId = '17521442'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0.08'
where entryId = '17541495'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0.04'
where entryId = '17980557'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '1.23'
where entryId = '18033900'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '4.09'
where entryId = '18061608'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '1.42'
where entryId = '18154350'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '3.06'
where entryId = '18196595'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '190.29'
where entryId = '18291524'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '2.25'
where entryId = '18292892'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '4.98'
where entryId = '18299068'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '1.72'
where entryId = '18384434'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '13.75'
where entryId = '18490612'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0.67'
where entryId = '18623383'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '1.91'
where entryId = '18755878'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '4.22'
where entryId = '19055109'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0.27'
where entryId = '19104747'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0.17'
where entryId = '19116426'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0.04'
where entryId = '19150314'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0'
where entryId = '19240045'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0.9'
where entryId = '19495222'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0'
where entryId = '19592628'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0.06'
where entryId = '19880816'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '43.82'
where entryId = '20169150'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '3.21'
where entryId = '20693547'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0.75'
where entryId = '21017608'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0'
where entryId = '21552900'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0.46'
where entryId = '22447775'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '11.48'
where entryId = '22745502'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0'
where entryId = '22855191'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '5.44'
where entryId = '23178694'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '15.46'
where entryId = '23443615'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0'
where entryId = '24522801'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0'
where entryId = '24927841'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0.1'
where entryId = '32979387'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0'
where entryId = '130461451'
update current13Fpositions set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580' ,
percentOut = '0.49'
where entryId = '131090710'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '90262T308'
Number of Rows :48
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '67049610'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '66065169'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '65047184'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '63950812'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '64101450'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '68720137'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '70666073'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '72651601'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '74230248'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '76527945'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '77782526'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '78398681'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '79946733'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '80149770'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '81762404'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '82063847'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '85041151'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '83868177'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '86103740'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '86025857'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '87804787'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '88343181'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '90136131'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '90475700'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '92206136'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '92859365'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '94255224'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '94962827'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '96029785'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '97111404'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '98418689'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '98950582'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '100990741'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '101312164'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '103551196'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '104825951'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '105766107'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '109069784'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '111857062'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '114288554'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '116762543'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '119647703'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '122411832'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '122771515'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '124956621'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '125130405'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '127817761'
update archive13F set
compid = '130970',
sectorNum = '301009',
sectorDes = 'Domestic Regional Banks',
issuerCik = '0001061580'
where entryId = '128098367'
End Function
The Script is complete, exiting....