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: : 130587
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130587'
The Shares Amount is 504428000
The cusip is 285661104
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '285661104'
Number of Rows :153
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.36'
where entryId = '1141407'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '2.6'
where entryId = '1223821'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.25'
where entryId = '1264541'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '43.47'
where entryId = '1569661'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.17'
where entryId = '1827420'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.01'
where entryId = '1983501'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '302.92'
where entryId = '2285566'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '1.99'
where entryId = '2374384'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '4.54'
where entryId = '2827661'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.09'
where entryId = '2831571'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '2.67'
where entryId = '2883064'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.99'
where entryId = '3312049'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '3.56'
where entryId = '3504599'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.68'
where entryId = '3682555'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '16.66'
where entryId = '3728518'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.01'
where entryId = '3846516'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '1.43'
where entryId = '3918334'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '2.99'
where entryId = '3927919'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '4415198'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.01'
where entryId = '4574718'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.04'
where entryId = '5086738'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.4'
where entryId = '5217782'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '1.76'
where entryId = '5264756'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.33'
where entryId = '5455299'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.2'
where entryId = '5468803'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.22'
where entryId = '5482857'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '1.96'
where entryId = '6910285'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '3.45'
where entryId = '7306031'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.28'
where entryId = '7429720'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.28'
where entryId = '8273027'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.01'
where entryId = '8617004'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '9180265'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '34.02'
where entryId = '9341294'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.03'
where entryId = '9679539'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '4.12'
where entryId = '9754472'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.21'
where entryId = '9898248'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.22'
where entryId = '10223120'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '74.38'
where entryId = '10234181'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '10517156'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '10756297'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '10792147'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.19'
where entryId = '10825989'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '11038351'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '28.98'
where entryId = '11102979'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.26'
where entryId = '11225899'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.96'
where entryId = '11264834'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '11273913'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.54'
where entryId = '11324424'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '42.33'
where entryId = '11449403'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.1'
where entryId = '11450955'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '3.81'
where entryId = '11451512'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '4.69'
where entryId = '11464471'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '12116131'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '12182578'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.14'
where entryId = '12230577'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.13'
where entryId = '12286943'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.1'
where entryId = '12318599'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '12326634'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '8.71'
where entryId = '12389476'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '12423882'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.32'
where entryId = '12448921'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '31.61'
where entryId = '12530050'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '12556437'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '12561556'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '12570122'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.6'
where entryId = '12581822'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.79'
where entryId = '12627001'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.01'
where entryId = '12629002'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.49'
where entryId = '12709210'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '12790774'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.93'
where entryId = '12845840'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.94'
where entryId = '12934183'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.03'
where entryId = '12972407'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '4.66'
where entryId = '12992288'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.08'
where entryId = '13022999'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.11'
where entryId = '13243816'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '13455769'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.54'
where entryId = '13456709'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '1.5'
where entryId = '13467725'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '13504998'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '13644978'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.03'
where entryId = '13669361'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '13677948'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.85'
where entryId = '13684309'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.38'
where entryId = '13684615'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.25'
where entryId = '13783137'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '13817596'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '13823777'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.01'
where entryId = '13907352'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.32'
where entryId = '13928539'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '1.21'
where entryId = '13936594'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.12'
where entryId = '13937883'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.01'
where entryId = '13968394'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '14019385'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '2.79'
where entryId = '14074483'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.79'
where entryId = '14157019'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.91'
where entryId = '14230768'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '14297101'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '3.65'
where entryId = '14327030'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.5'
where entryId = '14389231'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '14552494'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '14575543'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.12'
where entryId = '14606123'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.54'
where entryId = '14610818'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '1.51'
where entryId = '14661105'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '1.27'
where entryId = '14662525'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.08'
where entryId = '14678166'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '14823169'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '3.38'
where entryId = '14873767'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '14944166'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '6.45'
where entryId = '14951824'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.85'
where entryId = '15162151'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.38'
where entryId = '15162454'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '15174827'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.11'
where entryId = '15258233'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '15261716'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '15336789'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '1.03'
where entryId = '15449664'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '15461058'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.31'
where entryId = '15472878'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.02'
where entryId = '15618502'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.04'
where entryId = '15630652'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.16'
where entryId = '15760039'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.84'
where entryId = '15774148'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '15778266'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.89'
where entryId = '15815495'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.07'
where entryId = '15890925'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '15983458'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.17'
where entryId = '15998139'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '16000429'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '5.66'
where entryId = '16006077'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.07'
where entryId = '16028850'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '7.93'
where entryId = '16049419'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '9.91'
where entryId = '16050039'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '1.05'
where entryId = '16117310'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '16172885'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.01'
where entryId = '16174065'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0.09'
where entryId = '16194426'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '16285345'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '16521066'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '16795446'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '16950465'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '17001158'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '17226245'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '17227035'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '17772205'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '17776427'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '17787224'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '17804305'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '17804349'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '18009407'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '2.56'
where entryId = '23821005'
update current13Fpositions set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456' ,
percentOut = '0'
where entryId = '130459079'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '285661104'
Number of Rows :23
update archive13F set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456'
where entryId = '3035107'
update archive13F set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456'
where entryId = '77780618'
update archive13F set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456'
where entryId = '79944843'
update archive13F set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456'
where entryId = '81762639'
update archive13F set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456'
where entryId = '83866338'
update archive13F set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456'
where entryId = '86101933'
update archive13F set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456'
where entryId = '87802930'
update archive13F set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456'
where entryId = '90134315'
update archive13F set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456'
where entryId = '92204324'
update archive13F set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456'
where entryId = '94253397'
update archive13F set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456'
where entryId = '96027957'
update archive13F set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456'
where entryId = '98416852'
update archive13F set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456'
where entryId = '100988884'
update archive13F set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456'
where entryId = '103549304'
update archive13F set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456'
where entryId = '105763993'
update archive13F set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456'
where entryId = '109067643'
update archive13F set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456'
where entryId = '111854903'
update archive13F set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456'
where entryId = '114286397'
update archive13F set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456'
where entryId = '116760393'
update archive13F set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456'
where entryId = '119645499'
update archive13F set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456'
where entryId = '122409506'
update archive13F set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456'
where entryId = '124954299'
update archive13F set
compid = '130587',
sectorNum = '602005',
sectorDes = 'Information Technology Services',
issuerCik = '0001007456'
where entryId = '127815442'
End Function
The Script is complete, exiting....