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: : 133712
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '133712'
The Shares Amount is 56800000
The cusip is 929297109
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '929297109'
Number of Rows :179
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.02'
where entryId = '1265700'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '72.36'
where entryId = '1728344'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.07'
where entryId = '2354947'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '6.18'
where entryId = '2828284'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '5.17'
where entryId = '3735318'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '5099666'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '23.89'
where entryId = '5455725'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '7.43'
where entryId = '6416831'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '2.54'
where entryId = '8563666'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '9415446'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '10.23'
where entryId = '9757851'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '53.07'
where entryId = '10252762'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '129.34'
where entryId = '11103824'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '19.4'
where entryId = '11112534'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '1.38'
where entryId = '11391220'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '135.18'
where entryId = '11450404'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '108.7'
where entryId = '12186565'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '14.51'
where entryId = '12228866'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '1.19'
where entryId = '12236966'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.58'
where entryId = '12289197'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '12327550'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.01'
where entryId = '12424597'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '211.75'
where entryId = '13021091'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '4.52'
where entryId = '13025550'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '18.53'
where entryId = '13151140'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.17'
where entryId = '13468458'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '13678853'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '13818817'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '2.48'
where entryId = '13900528'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '3.33'
where entryId = '13939953'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '5015.7'
where entryId = '14129295'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '8.82'
where entryId = '14328884'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '2.15'
where entryId = '14333272'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.01'
where entryId = '14553194'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '2.84'
where entryId = '14584786'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.17'
where entryId = '14662131'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '224.01'
where entryId = '14676912'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.97'
where entryId = '14680673'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '14827845'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '24.46'
where entryId = '14879325'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '3.1'
where entryId = '14912570'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '14.45'
where entryId = '15070568'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '5.09'
where entryId = '15260432'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '15262639'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '1.28'
where entryId = '15283449'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.01'
where entryId = '15337480'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '68.42'
where entryId = '15387571'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '7.82'
where entryId = '15450868'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '12.04'
where entryId = '15474510'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '15522599'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '146.47'
where entryId = '15577673'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '15748157'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '24.58'
where entryId = '15761609'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '15803688'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '2.36'
where entryId = '16029644'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.06'
where entryId = '16118324'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '213.63'
where entryId = '16192633'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '1.07'
where entryId = '16197099'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '16288995'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '15.26'
where entryId = '16353763'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '15.26'
where entryId = '16355017'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.89'
where entryId = '16583071'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.11'
where entryId = '16611356'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '16616859'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.32'
where entryId = '16673231'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '73.97'
where entryId = '16673787'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '16727420'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '1.34'
where entryId = '16730198'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.32'
where entryId = '16800271'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '3.7'
where entryId = '16825155'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '4.96'
where entryId = '16836029'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.01'
where entryId = '16920622'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.03'
where entryId = '16939691'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '1.76'
where entryId = '16958291'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '15.26'
where entryId = '16983023'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '24.67'
where entryId = '17012634'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.62'
where entryId = '17016771'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '17075362'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '17104923'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '14.47'
where entryId = '17135403'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.01'
where entryId = '17162349'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '197.1'
where entryId = '17191444'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '20.76'
where entryId = '17208205'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '37.55'
where entryId = '17211007'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '6.94'
where entryId = '17276332'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '1.25'
where entryId = '17468848'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.56'
where entryId = '17521555'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.06'
where entryId = '17541607'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '62.9'
where entryId = '17728551'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '17786314'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '74.32'
where entryId = '17859476'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '1.37'
where entryId = '17980755'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '4.09'
where entryId = '18177528'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '3.94'
where entryId = '18183272'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '24.74'
where entryId = '18184387'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '3.67'
where entryId = '18228866'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '86.61'
where entryId = '18253221'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '18294222'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '5.14'
where entryId = '18299192'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '2.89'
where entryId = '18374542'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '11.96'
where entryId = '18493665'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '29'
where entryId = '18494083'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '23.24'
where entryId = '18572954'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '18658749'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '225.92'
where entryId = '18695802'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.09'
where entryId = '19055378'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.57'
where entryId = '19104846'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.06'
where entryId = '19116534'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '3.17'
where entryId = '19150535'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '38.13'
where entryId = '19264613'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '3.79'
where entryId = '19522832'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '2.38'
where entryId = '19707958'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '28.98'
where entryId = '19824418'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '2.72'
where entryId = '19880865'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '157.6'
where entryId = '20169227'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '5.78'
where entryId = '20791588'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.35'
where entryId = '22313538'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '1.92'
where entryId = '22449526'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.83'
where entryId = '22686571'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.02'
where entryId = '23159841'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.05'
where entryId = '23165633'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '45.96'
where entryId = '23179673'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '15.62'
where entryId = '23441459'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.18'
where entryId = '24138991'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '24523080'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.9'
where entryId = '24632863'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '24927974'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '3.06'
where entryId = '25415005'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '3.29'
where entryId = '26520187'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '28132803'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.61'
where entryId = '29136477'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '29960700'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '29961059'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '31253867'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '3.29'
where entryId = '32167753'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.25'
where entryId = '32908883'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '1.03'
where entryId = '33104454'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '33670670'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '33672408'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '33691410'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '34255201'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '37309175'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '38479305'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '40897063'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '41208479'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '11.49'
where entryId = '41652637'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '7.57'
where entryId = '41675734'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '109.07'
where entryId = '42076727'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '62.5'
where entryId = '42078528'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '107.33'
where entryId = '42081127'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '44.37'
where entryId = '42087318'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '16.8'
where entryId = '42107723'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '11.41'
where entryId = '42108787'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '1.55'
where entryId = '42115514'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.02'
where entryId = '42133949'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '6.81'
where entryId = '42147288'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '1.53'
where entryId = '42156399'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.48'
where entryId = '42159108'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.01'
where entryId = '42167653'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '2.4'
where entryId = '42172621'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.12'
where entryId = '42182303'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '6.16'
where entryId = '42186081'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.05'
where entryId = '42203603'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '13.64'
where entryId = '42208010'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '146.97'
where entryId = '42219206'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '2.89'
where entryId = '42221309'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '15.06'
where entryId = '42226195'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '14.47'
where entryId = '42232370'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '44.38'
where entryId = '42244833'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '5.69'
where entryId = '42253398'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '42266756'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '42266844'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '42269179'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '42270110'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '42468405'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '1.7'
where entryId = '42499406'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0.45'
where entryId = '43980023'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '7.22'
where entryId = '45300888'
update current13Fpositions set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077' ,
percentOut = '0'
where entryId = '47013787'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '929297109'
Number of Rows :3
update archive13F set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077'
where entryId = '47662771'
update archive13F set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077'
where entryId = '115495289'
update archive13F set
compid = '133712',
sectorNum = '603001',
sectorDes = 'Diversified Electronics',
issuerCik = '0000350077'
where entryId = '117386660'
End Function
The Script is complete, exiting....