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: : 130806
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130806'
The Shares Amount is 127007000
The cusip is 303726103
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '303726103'
Number of Rows :157
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.03'
where entryId = '1827449'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '24.8'
where entryId = '2827689'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.06'
where entryId = '2831666'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '35.58'
where entryId = '3031449'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '1.58'
where entryId = '3504745'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '13.7'
where entryId = '3682576'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '414.52'
where entryId = '3728832'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '4415097'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '4417010'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '4436288'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '4993725'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '3.86'
where entryId = '5086215'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.02'
where entryId = '5086753'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '1.16'
where entryId = '9754616'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '131.66'
where entryId = '10234997'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '133.89'
where entryId = '11264908'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '3.35'
where entryId = '11449439'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '4.49'
where entryId = '12271565'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '1.2'
where entryId = '12287043'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '12326205'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '12423916'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '12561910'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '2.09'
where entryId = '12709718'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.25'
where entryId = '12845912'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.03'
where entryId = '12934227'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '167.62'
where entryId = '13020846'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.6'
where entryId = '13467743'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '13677520'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '2.09'
where entryId = '14073846'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '48.88'
where entryId = '14230839'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '25.54'
where entryId = '14327116'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '14552527'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.69'
where entryId = '14661146'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '166.13'
where entryId = '14676677'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '1.24'
where entryId = '14874007'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '15261290'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '15336820'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.65'
where entryId = '15449714'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '14.33'
where entryId = '15472966'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '43.9'
where entryId = '15774221'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.01'
where entryId = '15803625'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.69'
where entryId = '16117348'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '159.4'
where entryId = '16192398'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '16616719'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.01'
where entryId = '16727355'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.64'
where entryId = '16834938'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '18.67'
where entryId = '16908558'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '16919959'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.6'
where entryId = '16938391'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '7.3'
where entryId = '16982701'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '1.44'
where entryId = '17015067'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '48.72'
where entryId = '17044363'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '17074198'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '17104233'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '8.92'
where entryId = '17135191'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '10.39'
where entryId = '17144996'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '151.93'
where entryId = '17191215'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '14.33'
where entryId = '17198613'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.36'
where entryId = '17468267'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.24'
where entryId = '17520704'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.69'
where entryId = '17540598'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '17787272'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '9.93'
where entryId = '18177201'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '18293579'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.63'
where entryId = '18298042'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '47.28'
where entryId = '18382696'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '18658082'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '148.35'
where entryId = '18695594'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '18842130'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '19027040'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.22'
where entryId = '19104057'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '1.21'
where entryId = '19115556'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '1.72'
where entryId = '19116854'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.23'
where entryId = '19147956'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '19633355'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '7.53'
where entryId = '19902454'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '2.28'
where entryId = '21273994'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '1.91'
where entryId = '23170982'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '23644483'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.03'
where entryId = '24138301'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '24520317'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '15.75'
where entryId = '24822053'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '24907706'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '24928757'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '26910657'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '7.35'
where entryId = '27840717'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '28132720'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '1.07'
where entryId = '28296865'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '28642237'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '7.39'
where entryId = '28685005'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '28814653'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '9.66'
where entryId = '28889854'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '3.63'
where entryId = '29136260'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '2.46'
where entryId = '29509299'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '31253372'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '6.36'
where entryId = '32166239'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.22'
where entryId = '32907806'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '33878686'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.9'
where entryId = '34131087'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '14.64'
where entryId = '34508660'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.49'
where entryId = '35470154'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '17.23'
where entryId = '35848422'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '37905364'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '38727935'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '3.83'
where entryId = '38909415'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.18'
where entryId = '40854674'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '7.2'
where entryId = '41651074'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '5.29'
where entryId = '41674485'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '1.12'
where entryId = '42068179'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '1.45'
where entryId = '42092456'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '10.35'
where entryId = '42100690'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '1.15'
where entryId = '42103724'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '17.45'
where entryId = '42105788'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '1.18'
where entryId = '42114642'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.03'
where entryId = '42133603'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '1.46'
where entryId = '42145731'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.79'
where entryId = '42158066'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.16'
where entryId = '42162826'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '42166331'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.02'
where entryId = '42169418'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '2.16'
where entryId = '42171731'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.11'
where entryId = '42181308'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '23.62'
where entryId = '42186470'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '10.21'
where entryId = '42195761'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '315.7'
where entryId = '42215575'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '2.79'
where entryId = '42221053'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '8.06'
where entryId = '42224534'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '1'
where entryId = '42228800'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '402.59'
where entryId = '42234548'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '233.06'
where entryId = '42236961'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '3.28'
where entryId = '42245655'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '16.79'
where entryId = '42252720'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '42267594'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '42463268'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '42464056'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '1.81'
where entryId = '42574283'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '42685927'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.42'
where entryId = '43979326'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '7.82'
where entryId = '46538642'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '7.87'
where entryId = '48062004'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '7.07'
where entryId = '50089091'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.95'
where entryId = '50672733'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '1.62'
where entryId = '50733222'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '222.1'
where entryId = '50843829'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.46'
where entryId = '51210699'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '53273285'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.01'
where entryId = '53599474'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.33'
where entryId = '53612067'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '53667172'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '70.91'
where entryId = '56364560'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '1.45'
where entryId = '57841307'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '59463657'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '60081573'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0.21'
where entryId = '60347928'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '9.3'
where entryId = '62204906'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '64105918'
update current13Fpositions set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960' ,
percentOut = '0'
where entryId = '130459207'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '303726103'
Number of Rows :193
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '65628552'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '66554213'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64958010'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '66562624'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '66578917'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63446974'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63450995'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63445179'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63450721'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63448995'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63450371'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63451349'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63451167'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63528502'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63525928'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63524874'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63525385'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63527079'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63645940'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63650296'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63646594'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63751650'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64101609'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64108708'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64311014'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64100181'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63646302'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63650697'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64945472'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64118556'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63756224'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63757331'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63757346'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64114424'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63758278'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63528896'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63528943'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64948806'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64110680'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63757106'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64103638'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64955456'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64306661'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64116012'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64108151'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63757775'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64312914'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63651445'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64118842'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64118278'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63756665'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64101025'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64318751'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64318179'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64930390'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64108988'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64925980'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64103090'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63651849'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64105301'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64316772'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64920734'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63528574'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64116387'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64112303'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64113847'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64104698'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64967253'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64962075'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64104860'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64941291'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63448490'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64312325'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64936708'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64934664'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63756708'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64318017'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64925050'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64924867'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64107392'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64114669'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64117035'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64116718'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64317530'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63651920'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64108450'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64109963'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64116793'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64109468'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64106416'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64107482'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64315528'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64968464'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64966939'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64934840'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64110561'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64949371'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64933791'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64319162'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64303649'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64930699'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64319056'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63757459'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64933069'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64319106'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64318829'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64921504'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64116126'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64317971'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64922034'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63451708'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64317697'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64315341'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64315742'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64103751'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64972731'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64970445'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64970091'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64968142'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64966471'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64995365'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64962522'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64970999'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64959066'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64959925'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64104201'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64955617'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64465783'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64954649'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64938832'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64950567'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64938737'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64312743'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64954175'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64934258'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64931139'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64932412'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64932734'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64929005'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64928914'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64928023'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64927533'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63757425'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64926591'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64925801'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64925475'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64116542'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64925079'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64925198'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64924803'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64923972'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64102655'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64922161'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '63451883'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64920859'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64920466'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64315910'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64920265'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64919312'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64919257'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64918852'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64918630'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64918085'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64931975'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64920085'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64920599'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64919803'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64921266'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64104008'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64921760'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '64996076'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '77780724'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '79944947'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '81762746'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '83866439'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '86102032'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '87803036'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '90134417'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '92204429'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '94253502'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '96028064'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '98416960'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '100988988'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '103549409'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '105764104'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '109067756'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '111855020'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '114286514'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '116760509'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '119645621'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '122409630'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '124954425'
update archive13F set
compid = '130806',
sectorNum = '603005',
sectorDes = 'Semiconductor - Integrated Circuits',
issuerCik = '0001036960'
where entryId = '127815566'
End Function
The Script is complete, exiting....