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: : 130869
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130869'
The Shares Amount is 168125000
The cusip is 172737108
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '172737108'
Number of Rows :108
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '1.36'
where entryId = '1223640'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '1366984'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.07'
where entryId = '1827258'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.09'
where entryId = '2207574'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '193.39'
where entryId = '2374310'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '6.84'
where entryId = '2827552'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.08'
where entryId = '2831213'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '10.43'
where entryId = '3504059'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '5.25'
where entryId = '3682496'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '200.75'
where entryId = '3727468'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '1.49'
where entryId = '3916626'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '4993630'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '5099639'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.57'
where entryId = '5217546'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '1.12'
where entryId = '5455233'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '14.07'
where entryId = '6059164'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '1.67'
where entryId = '6910110'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.46'
where entryId = '7429589'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '8499770'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '8502407'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '3.8'
where entryId = '9157860'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '37.32'
where entryId = '9341102'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '4.16'
where entryId = '9753975'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '188'
where entryId = '10231084'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '10874148'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '11038283'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '2.56'
where entryId = '11054240'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '1.22'
where entryId = '11076941'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '45.13'
where entryId = '11112367'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.72'
where entryId = '11264504'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '11273782'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '11369346'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '1.05'
where entryId = '11387622'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '4.06'
where entryId = '11423282'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '22.58'
where entryId = '11449248'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '12116066'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '1499.65'
where entryId = '12230766'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '12249706'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '8.66'
where entryId = '12286582'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.35'
where entryId = '12318232'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '12326570'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '2.92'
where entryId = '12389397'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '12423758'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '104.04'
where entryId = '12530047'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '3.27'
where entryId = '12655282'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.58'
where entryId = '12845505'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.01'
where entryId = '12934020'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '4.26'
where entryId = '12972086'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.04'
where entryId = '13022620'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '63.51'
where entryId = '13150981'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '13455620'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '6.46'
where entryId = '13467612'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '13504871'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '3.09'
where entryId = '13681546'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '1.67'
where entryId = '13684272'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '1.61'
where entryId = '13684575'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.27'
where entryId = '13937541'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '14019324'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '19.67'
where entryId = '14149203'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '14296976'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '8.92'
where entryId = '14355465'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '1.1'
where entryId = '14660954'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.02'
where entryId = '14677786'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '14822379'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.38'
where entryId = '14872927'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '2.71'
where entryId = '14912218'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '1.67'
where entryId = '15162115'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '1.61'
where entryId = '15162415'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.23'
where entryId = '15257862'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '72.12'
where entryId = '15301839'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '3.09'
where entryId = '15333356'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '44.98'
where entryId = '15340990'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.91'
where entryId = '15472594'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.19'
where entryId = '15994287'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.19'
where entryId = '15994373'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.37'
where entryId = '15994464'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.37'
where entryId = '15994551'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.37'
where entryId = '15994639'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.37'
where entryId = '15994730'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.37'
where entryId = '15995005'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.37'
where entryId = '15995092'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.37'
where entryId = '15995179'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.37'
where entryId = '15995266'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '11.9'
where entryId = '16049994'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '1.59'
where entryId = '16194033'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '16284707'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '2.44'
where entryId = '16582397'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '1.67'
where entryId = '16618527'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '1.61'
where entryId = '16618840'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.11'
where entryId = '16762811'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.08'
where entryId = '16938057'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '17000933'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '5.95'
where entryId = '17005489'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.8'
where entryId = '17014706'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '11.9'
where entryId = '17097641'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '17.3'
where entryId = '17196623'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0.82'
where entryId = '17468143'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '17804317'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '17804342'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '1.59'
where entryId = '17977681'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '2.19'
where entryId = '18116305'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '18273332'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '18355243'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '18615254'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '1.56'
where entryId = '19147472'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '1.02'
where entryId = '19494810'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '42456441'
update current13Fpositions set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599' ,
percentOut = '0'
where entryId = '64949160'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '172737108'
Number of Rows :44
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '969989'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '3847080'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '3688088'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '4399170'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '5240551'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '67160801'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '66276086'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '67271393'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '68341127'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '65266800'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '68613023'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '68975067'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '70100162'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '70154153'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '70337817'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '72439488'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '72099604'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '74776878'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '74050041'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '75915593'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '76169669'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '77767661'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '77934594'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '79878144'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '80403015'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '81824019'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '82555501'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '83810677'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '84602759'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '85926585'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '87936175'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '90311060'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '92327502'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '94006752'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '94220550'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '95217180'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '96550624'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '98591576'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '98598359'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '100978583'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '100934608'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '103539561'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '129644413'
update archive13F set
compid = '130869',
sectorNum = '105007',
sectorDes = 'Electronics Stores',
issuerCik = '0000104599'
where entryId = '129668760'
End Function
The Script is complete, exiting....