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: : 133479
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '133479'
The Shares Amount is 248140000
The cusip is 637640103
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '637640103'
Number of Rows :248
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '1.59'
where entryId = '1141494'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '3.06'
where entryId = '1224293'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.2'
where entryId = '1265086'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '120.99'
where entryId = '1570034'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.01'
where entryId = '1827865'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.01'
where entryId = '1983730'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '16.32'
where entryId = '2207784'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '2297848'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.89'
where entryId = '2374586'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '14.96'
where entryId = '2827968'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '28.22'
where entryId = '2832605'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '3.4'
where entryId = '3031644'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '7.93'
where entryId = '3506135'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.88'
where entryId = '3682767'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '82.3'
where entryId = '3731722'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '3.03'
where entryId = '3917350'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '4436059'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.02'
where entryId = '5086905'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.55'
where entryId = '5218457'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '5415613'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.62'
where entryId = '5455505'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.47'
where entryId = '5468908'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '2.28'
where entryId = '6910732'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.66'
where entryId = '7430111'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.4'
where entryId = '8779393'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '2.67'
where entryId = '9341963'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.21'
where entryId = '9679873'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '44.79'
where entryId = '9756114'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.87'
where entryId = '10223669'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '274.14'
where entryId = '10243468'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.9'
where entryId = '10595646'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '10734184'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '11038526'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.66'
where entryId = '11054315'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '50.55'
where entryId = '11103390'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '2.53'
where entryId = '11122168'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '27.41'
where entryId = '11195046'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.75'
where entryId = '11265866'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '11274243'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.41'
where entryId = '11449877'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.02'
where entryId = '11464547'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.58'
where entryId = '11894149'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.63'
where entryId = '12075575'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '12116293'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '4.76'
where entryId = '12228656'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '5.54'
where entryId = '12288057'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.31'
where entryId = '12319642'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '12326792'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '19.25'
where entryId = '12389689'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '12424241'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '211.27'
where entryId = '12525521'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '2.86'
where entryId = '12539101'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '1.67'
where entryId = '12581944'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.85'
where entryId = '12709997'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '12790888'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.74'
where entryId = '12846897'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.02'
where entryId = '12934655'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '24.86'
where entryId = '13020952'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.12'
where entryId = '13024278'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '6.76'
where entryId = '13451350'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '13456103'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.53'
where entryId = '13468082'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '7.05'
where entryId = '13504560'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '13505306'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.04'
where entryId = '13625890'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.04'
where entryId = '13626208'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.04'
where entryId = '13626606'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '13645321'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '13678104'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '2.1'
where entryId = '13684400'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '1.67'
where entryId = '13684711'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '3.03'
where entryId = '13852749'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '6.51'
where entryId = '13900355'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.31'
where entryId = '13938912'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.01'
where entryId = '13968593'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '14019536'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.85'
where entryId = '14074120'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.54'
where entryId = '14140388'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.74'
where entryId = '14231760'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '14297405'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '3.81'
where entryId = '14327906'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '21.37'
where entryId = '14371510'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '207.41'
where entryId = '14509651'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '14552847'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '14575664'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.47'
where entryId = '14661573'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '24.71'
where entryId = '14676775'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.12'
where entryId = '14679398'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '14825619'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.26'
where entryId = '14876439'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '14944325'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '18.99'
where entryId = '14950139'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '19.01'
where entryId = '15090970'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '2.1'
where entryId = '15162238'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '1.67'
where entryId = '15162545'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '15174988'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.31'
where entryId = '15259271'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '15261875'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '3.03'
where entryId = '15265082'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.6'
where entryId = '15302900'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '15337137'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '1.27'
where entryId = '15450208'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.01'
where entryId = '15461262'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '10.12'
where entryId = '15473649'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.64'
where entryId = '15503047'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '2.12'
where entryId = '15537611'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '195.89'
where entryId = '15556323'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '9.45'
where entryId = '15635306'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '7.09'
where entryId = '15761441'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.63'
where entryId = '15775179'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '15778601'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '15983589'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.17'
where entryId = '16117772'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.01'
where entryId = '16175103'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '24.47'
where entryId = '16192498'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.02'
where entryId = '16195746'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '16287260'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '10.82'
where entryId = '16513186'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '16521377'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '1.82'
where entryId = '16565942'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.06'
where entryId = '16610882'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '16615235'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '2.1'
where entryId = '16618652'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '1.67'
where entryId = '16618979'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '3.39'
where entryId = '16632185'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '16633567'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '3.12'
where entryId = '16646198'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.45'
where entryId = '16680647'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.45'
where entryId = '16680929'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.45'
where entryId = '16681166'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.47'
where entryId = '16681703'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.45'
where entryId = '16703732'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.02'
where entryId = '16729424'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.29'
where entryId = '16764268'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '1.16'
where entryId = '16835435'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '10.35'
where entryId = '16838143'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '1.18'
where entryId = '16874644'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '16920275'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.48'
where entryId = '16938999'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '16950440'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '1.69'
where entryId = '16978654'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '183.87'
where entryId = '16984220'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '17013128'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.18'
where entryId = '17015864'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.59'
where entryId = '17045267'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.82'
where entryId = '17051703'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '17074740'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.01'
where entryId = '17098601'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '17104558'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '1.45'
where entryId = '17135278'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '9.45'
where entryId = '17161823'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.01'
where entryId = '17162246'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '24.39'
where entryId = '17191315'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '28.89'
where entryId = '17202988'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '1.29'
where entryId = '17275586'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '10.87'
where entryId = '17436534'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.1'
where entryId = '17436837'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.17'
where entryId = '17468529'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '2.12'
where entryId = '17485005'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '17.57'
where entryId = '17522047'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '17533020'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.18'
where entryId = '17541043'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.06'
where entryId = '17542293'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.06'
where entryId = '17557972'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '17673990'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.73'
where entryId = '17729683'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.17'
where entryId = '17979386'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.35'
where entryId = '17989781'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.1'
where entryId = '18033821'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '18041658'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '1.19'
where entryId = '18048637'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '18057975'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '2.1'
where entryId = '18076385'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '1.67'
where entryId = '18076760'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '18091556'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.04'
where entryId = '18116396'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '3.12'
where entryId = '18124238'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.23'
where entryId = '18182220'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '7.27'
where entryId = '18239383'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '18243017'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '18293887'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '1.09'
where entryId = '18298546'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '18304637'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.5'
where entryId = '18383585'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '211.54'
where entryId = '18489445'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '18551565'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '16.38'
where entryId = '18569641'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.13'
where entryId = '18623305'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '18658399'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '23.83'
where entryId = '18695688'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '18711482'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '1.39'
where entryId = '18761578'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '7.69'
where entryId = '18806124'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '8.59'
where entryId = '18852886'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.95'
where entryId = '18854016'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '19063435'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '19093110'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '12.16'
where entryId = '19105144'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.18'
where entryId = '19115988'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '1.91'
where entryId = '19116921'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.04'
where entryId = '19149136'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '19238476'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '19555630'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '8.12'
where entryId = '19880582'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '1.29'
where entryId = '19884707'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '5.81'
where entryId = '19987600'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '1.9'
where entryId = '19987706'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '2.91'
where entryId = '19987955'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '3.64'
where entryId = '20128449'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '4.85'
where entryId = '20128573'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '11.06'
where entryId = '20128688'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '20.44'
where entryId = '20128810'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.36'
where entryId = '20243595'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '11.15'
where entryId = '20306949'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.48'
where entryId = '20693422'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.94'
where entryId = '21064987'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '1.21'
where entryId = '21065337'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '21182516'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '22500082'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '9.09'
where entryId = '22865467'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '11.95'
where entryId = '23174711'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '2.53'
where entryId = '23355757'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '6.04'
where entryId = '23462581'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '1.05'
where entryId = '24087010'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.35'
where entryId = '24144661'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '24505051'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '24521532'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '24927217'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '26219116'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.08'
where entryId = '26773787'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '27406861'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '1.84'
where entryId = '27855850'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.44'
where entryId = '28321717'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '28642058'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0.24'
where entryId = '28730979'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '4.97'
where entryId = '29136672'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '29961117'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '31253888'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '31290204'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '426.62'
where entryId = '31774195'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '4.49'
where entryId = '31799803'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '2'
where entryId = '31889971'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '32966328'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '33166025'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '33178951'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '33693677'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '33878842'
update current13Fpositions set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530' ,
percentOut = '0'
where entryId = '130460285'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '637640103'
Number of Rows :23
update archive13F set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530'
where entryId = '64956302'
update archive13F set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530'
where entryId = '77781603'
update archive13F set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530'
where entryId = '79945813'
update archive13F set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530'
where entryId = '81762051'
update archive13F set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530'
where entryId = '83867276'
update archive13F set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530'
where entryId = '86102856'
update archive13F set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530'
where entryId = '87803883'
update archive13F set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530'
where entryId = '90135254'
update archive13F set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530'
where entryId = '92205259'
update archive13F set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530'
where entryId = '94254337'
update archive13F set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530'
where entryId = '96028896'
update archive13F set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530'
where entryId = '98417793'
update archive13F set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530'
where entryId = '100989825'
update archive13F set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530'
where entryId = '103550269'
update archive13F set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530'
where entryId = '105765069'
update archive13F set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530'
where entryId = '109068734'
update archive13F set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530'
where entryId = '111856004'
update archive13F set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530'
where entryId = '114287496'
update archive13F set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530'
where entryId = '116761490'
update archive13F set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530'
where entryId = '119646620'
update archive13F set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530'
where entryId = '122410679'
update archive13F set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530'
where entryId = '124955474'
update archive13F set
compid = '133479',
sectorNum = '603004',
sectorDes = 'Semiconductor- BroadLine',
issuerCik = '0000070530'
where entryId = '127816619'
End Function
The Script is complete, exiting....