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: : 130922
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130922'
The Shares Amount is 267736000
The cusip is 12686C109
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '12686C109'
Number of Rows :279
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '2.08'
where entryId = '1095716'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.41'
where entryId = '1223571'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '4.27'
where entryId = '1264254'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '1493164'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '1493168'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '24.28'
where entryId = '1728230'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.01'
where entryId = '1827183'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.47'
where entryId = '2282077'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.69'
where entryId = '2374286'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.02'
where entryId = '2831058'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '3168034'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '2.44'
where entryId = '3503792'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.68'
where entryId = '3726996'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.08'
where entryId = '3916549'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.04'
where entryId = '4574640'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.05'
where entryId = '5086650'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '64.29'
where entryId = '6793553'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.56'
where entryId = '6910040'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '2.2'
where entryId = '7300497'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.7'
where entryId = '7306009'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.19'
where entryId = '7429523'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.58'
where entryId = '7775219'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '10.31'
where entryId = '8276552'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '5.93'
where entryId = '9157834'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '8.04'
where entryId = '9341003'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '2.04'
where entryId = '9753763'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.87'
where entryId = '10119482'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '65.83'
where entryId = '10142699'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '33.82'
where entryId = '10229827'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.27'
where entryId = '11054226'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '11068096'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.52'
where entryId = '11076897'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '11464430'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '5.06'
where entryId = '12083529'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '11.18'
where entryId = '12228386'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.85'
where entryId = '12269214'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.34'
where entryId = '12389360'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '24.08'
where entryId = '12525323'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '12562646'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.28'
where entryId = '12655270'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.02'
where entryId = '12709592'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '2.9'
where entryId = '12895644'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.02'
where entryId = '12933951'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '13276019'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.62'
where entryId = '13451063'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '67.5'
where entryId = '13457154'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '13628514'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '13628967'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '13817485'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.63'
where entryId = '13900103'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '51.27'
where entryId = '14052503'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.02'
where entryId = '14073703'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.75'
where entryId = '14149194'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.27'
where entryId = '14157000'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '6.26'
where entryId = '14330577'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '4.77'
where entryId = '14355464'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '21.67'
where entryId = '14509462'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.04'
where entryId = '14677636'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '14822092'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '4.05'
where entryId = '14872569'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '14885724'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '15008485'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '30.36'
where entryId = '15070115'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '8.47'
where entryId = '15449383'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.04'
where entryId = '15472477'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.52'
where entryId = '15594572'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.74'
where entryId = '15627392'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.02'
where entryId = '15634931'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '5.91'
where entryId = '15761195'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '51.27'
where entryId = '15786988'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.33'
where entryId = '15815548'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.77'
where entryId = '16028665'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '4.01'
where entryId = '16049993'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.1'
where entryId = '16193863'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '16244732'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '16284491'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '16363026'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.18'
where entryId = '16672962'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '8.93'
where entryId = '16728404'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.06'
where entryId = '16762684'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.18'
where entryId = '16800002'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '8.92'
where entryId = '16834639'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.01'
where entryId = '16938210'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '16952518'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '3.5'
where entryId = '16960469'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '3.44'
where entryId = '16961174'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '6.05'
where entryId = '17012242'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.33'
where entryId = '17051485'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '2.91'
where entryId = '17097640'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '17107422'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.54'
where entryId = '17109544'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '2.6'
where entryId = '17135128'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '17144315'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '3.44'
where entryId = '17144961'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.48'
where entryId = '17157646'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.02'
where entryId = '17161465'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.01'
where entryId = '17162107'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '2.47'
where entryId = '17196067'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '37.2'
where entryId = '17210599'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '17226978'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '17253961'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '40.47'
where entryId = '17274609'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '17393206'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '2.38'
where entryId = '17458811'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.28'
where entryId = '17557410'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '17670959'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '17787006'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '17804345'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.12'
where entryId = '17977522'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '3.93'
where entryId = '18149454'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.06'
where entryId = '18180759'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '31.58'
where entryId = '18183978'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '10.84'
where entryId = '18297724'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.01'
where entryId = '18374226'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.41'
where entryId = '18429211'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '3.44'
where entryId = '18540187'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '18550828'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.01'
where entryId = '18568475'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.01'
where entryId = '18660043'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.44'
where entryId = '18672580'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1'
where entryId = '18783581'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '3.14'
where entryId = '18812324'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.02'
where entryId = '18852501'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.19'
where entryId = '19052595'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '19063111'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.05'
where entryId = '19147305'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '19264918'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '19.8'
where entryId = '19556177'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '19592582'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '102.03'
where entryId = '20167705'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.33'
where entryId = '20243181'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '45.74'
where entryId = '20287120'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.01'
where entryId = '20791082'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '10.16'
where entryId = '21207570'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '21552852'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '3.74'
where entryId = '23159140'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '6.57'
where entryId = '23168697'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.9'
where entryId = '23355511'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '5.98'
where entryId = '23443514'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.28'
where entryId = '23456648'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.03'
where entryId = '24138091'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '24519527'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '24921681'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '24928335'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.01'
where entryId = '26733747'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.06'
where entryId = '26773590'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.68'
where entryId = '27478651'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '7.01'
where entryId = '27855835'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '6.96'
where entryId = '27897523'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.09'
where entryId = '28047013'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '2.21'
where entryId = '28313245'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.17'
where entryId = '28325543'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.22'
where entryId = '28730742'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.34'
where entryId = '29509258'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '29696452'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.87'
where entryId = '30669547'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '31253673'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.54'
where entryId = '31412716'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.38'
where entryId = '31798860'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '7.16'
where entryId = '32907491'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '191.61'
where entryId = '33204070'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '33346598'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '33878591'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '2.69'
where entryId = '34540552'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.87'
where entryId = '34585583'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.01'
where entryId = '35470018'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '2.11'
where entryId = '36185981'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '36600026'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.01'
where entryId = '37276610'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.08'
where entryId = '38323860'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '38483934'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.47'
where entryId = '38909321'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '40508239'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '5.14'
where entryId = '40856016'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '5.7'
where entryId = '41650647'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '2.63'
where entryId = '41674114'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '41976500'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '2.6'
where entryId = '42061786'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '2.25'
where entryId = '42073922'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.67'
where entryId = '42090675'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.44'
where entryId = '42091255'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '5.57'
where entryId = '42092039'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.6'
where entryId = '42098691'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.55'
where entryId = '42099632'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '7.75'
where entryId = '42100419'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.68'
where entryId = '42103612'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '12.68'
where entryId = '42105243'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '303.66'
where entryId = '42107927'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '4.95'
where entryId = '42109874'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.37'
where entryId = '42112449'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.93'
where entryId = '42112862'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '2.48'
where entryId = '42116748'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.13'
where entryId = '42119637'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.37'
where entryId = '42121693'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '4.61'
where entryId = '42125142'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.23'
where entryId = '42134505'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '8.5'
where entryId = '42137596'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '2.76'
where entryId = '42141057'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '7.83'
where entryId = '42144659'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.26'
where entryId = '42145302'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.1'
where entryId = '42148707'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.28'
where entryId = '42152240'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '8.34'
where entryId = '42156965'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.01'
where entryId = '42157755'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '10.27'
where entryId = '42162378'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.01'
where entryId = '42164359'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.01'
where entryId = '42166021'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '35.53'
where entryId = '42171475'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '3.57'
where entryId = '42179291'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '5.51'
where entryId = '42179842'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '93.75'
where entryId = '42186303'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '2.09'
where entryId = '42187312'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.01'
where entryId = '42197784'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '3.95'
where entryId = '42199334'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.08'
where entryId = '42202787'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '2.19'
where entryId = '42204958'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.59'
where entryId = '42221415'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '5.42'
where entryId = '42224062'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '35.55'
where entryId = '42228525'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '430.41'
where entryId = '42231707'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.79'
where entryId = '42232945'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '4.78'
where entryId = '42234455'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.51'
where entryId = '42236792'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.75'
where entryId = '42244733'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.3'
where entryId = '42245435'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '15.81'
where entryId = '42248596'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '11.59'
where entryId = '42250989'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.83'
where entryId = '42252514'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '42265188'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '42266189'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '42266594'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '42459411'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '42461085'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.87'
where entryId = '42497655'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.71'
where entryId = '42565919'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '42690120'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '3.21'
where entryId = '43978927'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '3.24'
where entryId = '45691076'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.59'
where entryId = '46116543'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '46127785'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '2.14'
where entryId = '47143296'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '8.36'
where entryId = '47250740'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.25'
where entryId = '47280296'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '3.31'
where entryId = '47291087'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '47683206'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '48012151'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '11.21'
where entryId = '48061839'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '2.1'
where entryId = '48477757'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '4.87'
where entryId = '49940915'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '3.27'
where entryId = '50088949'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.88'
where entryId = '50160935'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '9.18'
where entryId = '50673227'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '23.47'
where entryId = '51208643'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '6.08'
where entryId = '51622402'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.81'
where entryId = '51668617'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.01'
where entryId = '51751158'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '52673594'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '53273301'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.73'
where entryId = '53429099'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.17'
where entryId = '53598510'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.14'
where entryId = '53611917'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.19'
where entryId = '53699828'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.39'
where entryId = '54094853'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.06'
where entryId = '54161905'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.8'
where entryId = '54477628'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.02'
where entryId = '54885056'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '56152675'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '50.66'
where entryId = '56363832'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '39.51'
where entryId = '56497102'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '17.13'
where entryId = '57152546'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '57361919'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.75'
where entryId = '57840960'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0.02'
where entryId = '57889114'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '2.64'
where entryId = '59840004'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '0'
where entryId = '60283911'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.55'
where entryId = '60345707'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.93'
where entryId = '60363056'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '3.47'
where entryId = '61349927'
update current13Fpositions set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112' ,
percentOut = '1.16'
where entryId = '61541569'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '12686C109'
Number of Rows :18
update archive13F set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112'
where entryId = '47662954'
update archive13F set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112'
where entryId = '63319656'
update archive13F set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112'
where entryId = '64963853'
update archive13F set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112'
where entryId = '63652144'
update archive13F set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112'
where entryId = '63755734'
update archive13F set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112'
where entryId = '64104662'
update archive13F set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112'
where entryId = '64940701'
update archive13F set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112'
where entryId = '62234876'
update archive13F set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112'
where entryId = '32247846'
update archive13F set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112'
where entryId = '17821356'
update archive13F set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112'
where entryId = '51036605'
update archive13F set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112'
where entryId = '53503167'
update archive13F set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112'
where entryId = '96632160'
update archive13F set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112'
where entryId = '98134757'
update archive13F set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112'
where entryId = '103141519'
update archive13F set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112'
where entryId = '103196597'
update archive13F set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112'
where entryId = '117021038'
update archive13F set
compid = '130922',
sectorNum = '104004',
sectorDes = 'CATV Systems',
issuerCik = '0001053112'
where entryId = '120618265'
End Function
The Script is complete, exiting....