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: : 131037
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '131037'
The Shares Amount is 119840000
The cusip is 46185R100
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '46185R100'
Number of Rows :155
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.74'
where entryId = '1144912'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.63'
where entryId = '1224047'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.91'
where entryId = '1264829'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '1.32'
where entryId = '1701195'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.01'
where entryId = '1827648'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.17'
where entryId = '2608289'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '8.29'
where entryId = '2827825'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.01'
where entryId = '2832129'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '3133939'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '5.32'
where entryId = '3505432'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '4.69'
where entryId = '3730287'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.08'
where entryId = '3917108'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '4415192'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '5580275'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '3.34'
where entryId = '5747364'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.35'
where entryId = '5792139'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.77'
where entryId = '6910497'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '1.64'
where entryId = '7306062'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.02'
where entryId = '7793230'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '1.31'
where entryId = '7954703'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.05'
where entryId = '8616803'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.27'
where entryId = '9180353'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.67'
where entryId = '9341634'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.65'
where entryId = '9755318'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '68.14'
where entryId = '10239066'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '28.97'
where entryId = '10302658'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '11068255'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '122.2'
where entryId = '11103193'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.83'
where entryId = '11194957'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '1.67'
where entryId = '11213463'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '11236733'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '15.29'
where entryId = '11394786'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.28'
where entryId = '11423466'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '3.66'
where entryId = '11449642'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '3.09'
where entryId = '11464519'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '35.87'
where entryId = '11894098'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.28'
where entryId = '12188107'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.37'
where entryId = '12236713'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '2.31'
where entryId = '12287519'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.64'
where entryId = '12290778'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '1.08'
where entryId = '12319140'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '12326267'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '2.11'
where entryId = '12389584'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.01'
where entryId = '12424073'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.29'
where entryId = '12448991'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.92'
where entryId = '12539372'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.01'
where entryId = '12629169'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.27'
where entryId = '12709333'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '12790828'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '1.09'
where entryId = '12807159'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '7.6'
where entryId = '12931220'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.17'
where entryId = '12934437'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.28'
where entryId = '12951940'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '3.12'
where entryId = '12992336'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.03'
where entryId = '13023616'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.36'
where entryId = '13242750'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '2.83'
where entryId = '13451253'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.08'
where entryId = '13468696'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '1.92'
where entryId = '13644333'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '13677582'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '2.81'
where entryId = '13900271'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.02'
where entryId = '13907542'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.29'
where entryId = '13928605'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '13932769'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '1.23'
where entryId = '13938424'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.91'
where entryId = '13988589'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '3.08'
where entryId = '14074522'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '3.92'
where entryId = '14156837'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '14257492'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '14266400'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '8.3'
where entryId = '14327529'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '14455588'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.01'
where entryId = '14552682'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '14575602'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '1.42'
where entryId = '14581706'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '2.25'
where entryId = '14649802'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.09'
where entryId = '14661352'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.06'
where entryId = '14678746'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '14824290'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '2.29'
where entryId = '14875133'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '19.81'
where entryId = '14951950'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.29'
where entryId = '15098789'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.28'
where entryId = '15105097'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '1.01'
where entryId = '15162195'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.62'
where entryId = '15162499'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '15179789'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.58'
where entryId = '15198973'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.51'
where entryId = '15242285'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '2.59'
where entryId = '15258781'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '15261350'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '1.43'
where entryId = '15321162'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '15336971'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '1.82'
where entryId = '15418758'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '1.84'
where entryId = '15447535'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.63'
where entryId = '15449956'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '32.68'
where entryId = '15473317'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.03'
where entryId = '15513804'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.05'
where entryId = '15618724'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '2.5'
where entryId = '15627507'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '7.71'
where entryId = '15815411'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.84'
where entryId = '15973003'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.84'
where entryId = '15973389'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '15983519'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.04'
where entryId = '16029042'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '58.18'
where entryId = '16060685'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '18.61'
where entryId = '16104008'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '16110837'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.18'
where entryId = '16117551'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.1'
where entryId = '16172990'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '5.92'
where entryId = '16175056'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.5'
where entryId = '16195049'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '16286201'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '1.12'
where entryId = '16362558'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '2.49'
where entryId = '16565858'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.05'
where entryId = '16610673'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '16614704'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '1.01'
where entryId = '16618607'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.62'
where entryId = '16618928'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '34.81'
where entryId = '16729125'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '2.53'
where entryId = '16763729'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '16795451'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.55'
where entryId = '16835173'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '3.84'
where entryId = '16836520'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.58'
where entryId = '16848705'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '16874037'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '16920105'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.4'
where entryId = '16938694'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '16950361'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '57.93'
where entryId = '16961496'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.72'
where entryId = '16982770'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '2.25'
where entryId = '17009581'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '1.09'
where entryId = '17015476'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.04'
where entryId = '17051966'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '17074472'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.12'
where entryId = '17107826'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '7.51'
where entryId = '17157562'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '5.75'
where entryId = '17162201'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '51.88'
where entryId = '17200522'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '1'
where entryId = '17436805'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '1.36'
where entryId = '17468401'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '59.94'
where entryId = '17482973'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '1.28'
where entryId = '17497407'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.01'
where entryId = '17526211'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '14.58'
where entryId = '17527615'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '11.85'
where entryId = '17529939'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.18'
where entryId = '17540814'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '17672798'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '17787498'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '31.17'
where entryId = '17859683'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0.5'
where entryId = '17978690'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '1'
where entryId = '18033789'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '18083989'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '18273920'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '18355831'
update current13Fpositions set
compid = '131037',
sectorNum = '401001',
sectorDes = 'Biotechnology',
issuerCik = '' ,
percentOut = '0'
where entryId = '18615311'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '46185R100'
Number of Rows :0
End Function
The Script is complete, exiting....