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: : 142471
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '142471'
The Shares Amount is 63468000
The cusip is N07045102
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = 'N07045102'
Number of Rows :40
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '2.65'
where entryId = '3503433'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '2.57'
where entryId = '9898361'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '9.6'
where entryId = '10225049'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '63.86'
where entryId = '11102676'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '1.18'
where entryId = '12448846'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '1.26'
where entryId = '12476674'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '0.12'
where entryId = '12628683'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '0.37'
where entryId = '12933846'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '0.22'
where entryId = '13907004'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '1.18'
where entryId = '13928472'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '2.41'
where entryId = '14326456'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '21.36'
where entryId = '14332430'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '5.91'
where entryId = '14871236'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '1.18'
where entryId = '15198853'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '1.18'
where entryId = '16848593'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '0'
where entryId = '16955693'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '7.69'
where entryId = '17135103'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '1.18'
where entryId = '18154146'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '0'
where entryId = '23406338'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '220.74'
where entryId = '23455684'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '0'
where entryId = '24519243'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '0'
where entryId = '33693579'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '0'
where entryId = '35981553'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '0'
where entryId = '40618172'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '0.01'
where entryId = '42097064'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '0.99'
where entryId = '42148583'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '78.78'
where entryId = '42250896'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '0.54'
where entryId = '51207833'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '0'
where entryId = '132545971'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '0.24'
where entryId = '132153138'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '0.01'
where entryId = '130357569'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '0'
where entryId = '131721323'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '0.13'
where entryId = '130400360'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '0.06'
where entryId = '130462004'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '0.14'
where entryId = '131087170'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '0.03'
where entryId = '130915849'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '0'
where entryId = '131762336'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '0.03'
where entryId = '130008555'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '1.01'
where entryId = '130204056'
update current13Fpositions set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483' ,
percentOut = '0.25'
where entryId = '132439013'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = 'N07045102'
Number of Rows :98
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '67085213'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '67133361'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '65010000'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '63410397'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '68433777'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '68618939'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '70325508'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '70093165'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '70464242'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '72170959'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '72073210'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '72382172'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '74114616'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '73831428'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '76042295'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '82920528'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '85505693'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '89809511'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '51036414'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '93778612'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '96631973'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '98647218'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '101004778'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '103712571'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '105668147'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '102008081'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '106358349'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '107738512'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '108337323'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '109973170'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '109898336'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '109707953'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '110750346'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '110348276'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '111813678'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '112742568'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '112083862'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '111654075'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '111074447'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '113510209'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '111043273'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '114230426'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '113914540'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '114424246'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '114633589'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '115949499'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '116041482'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '117356676'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '116184236'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '114272989'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '117029545'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '118642154'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '117192000'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '116916007'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '120680775'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '119491683'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '119626692'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '119847087'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '119648221'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '120872619'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '118457110'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '120095804'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '122313720'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '122260856'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '122390435'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '122412357'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '122767876'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '123902597'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '120486461'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '123908155'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '123630487'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '122595358'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '122625647'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '124952792'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '124881893'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '125738076'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '124829271'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '124957156'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '125126817'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '125709487'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '125293230'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '125971959'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '126575571'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '126744574'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '127769804'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '127714357'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '128234862'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '127314517'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '129710390'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '127818304'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '129682349'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '128094807'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '128375933'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '129863814'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '129757259'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '129501065'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '128163921'
update archive13F set
compid = '142471',
sectorNum = '603008',
sectorDes = 'Semiconductor Equipment & Materials',
issuerCik = '0000351483'
where entryId = '128697475'
End Function
The Script is complete, exiting....