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: : 130614
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130614'
The Shares Amount is 77210000
The cusip is 05564E106
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '05564E106'
Number of Rows :168
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '20.44'
where entryId = '1569443'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.03'
where entryId = '2831010'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '3168039'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.25'
where entryId = '3503739'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '7.79'
where entryId = '3726868'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.49'
where entryId = '5217338'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.39'
where entryId = '6761827'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '7798957'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.9'
where entryId = '7805473'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.64'
where entryId = '9340884'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '6.52'
where entryId = '9419498'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '170.99'
where entryId = '9655223'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.75'
where entryId = '9753455'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '36.78'
where entryId = '10228142'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.74'
where entryId = '10683484'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '16.03'
where entryId = '10719782'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.7'
where entryId = '10825980'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '25.75'
where entryId = '11122126'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.1'
where entryId = '11778160'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '12326124'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.01'
where entryId = '12423646'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '15.96'
where entryId = '12442162'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '12562615'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.02'
where entryId = '12933927'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.05'
where entryId = '13022207'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.1'
where entryId = '13244573'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '12.24'
where entryId = '13457343'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.07'
where entryId = '13468523'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.78'
where entryId = '13473417'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '13505695'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '14.83'
where entryId = '13666378'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '13677425'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '11.01'
where entryId = '13852705'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '16.17'
where entryId = '13997676'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.13'
where entryId = '14193182'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.63'
where entryId = '14259118'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '14297796'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '12.65'
where entryId = '14326600'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '574.11'
where entryId = '14340978'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.01'
where entryId = '14552266'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.08'
where entryId = '14660854'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.05'
where entryId = '14677370'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.34'
where entryId = '14872052'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '14.69'
where entryId = '15247928'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '15261209'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '14.32'
where entryId = '15265037'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.01'
where entryId = '15336565'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.2'
where entryId = '15449358'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '16.17'
where entryId = '15525349'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.6'
where entryId = '15620699'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.13'
where entryId = '15730262'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '561.46'
where entryId = '16018167'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.5'
where entryId = '16028651'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.08'
where entryId = '16117057'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.05'
where entryId = '16193590'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '16521764'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '16614550'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.68'
where entryId = '16618825'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '14.43'
where entryId = '16646151'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '16.12'
where entryId = '16833868'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.2'
where entryId = '16834529'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.22'
where entryId = '16865940'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.01'
where entryId = '16919708'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '90.56'
where entryId = '16982590'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.97'
where entryId = '17014430'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.04'
where entryId = '17051444'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '17073766'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '10.88'
where entryId = '17195082'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '3.63'
where entryId = '17274577'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '629.6'
where entryId = '17442864'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.08'
where entryId = '17540310'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '17786911'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '4.74'
where entryId = '17859501'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.12'
where entryId = '17977250'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '18009478'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '18042043'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.26'
where entryId = '18076210'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.08'
where entryId = '18076585'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '17.41'
where entryId = '18100434'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '6.26'
where entryId = '18124196'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '18293335'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.19'
where entryId = '18297699'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '15.51'
where entryId = '18375367'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '18711862'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '668.38'
where entryId = '18779575'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.91'
where entryId = '18783571'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.07'
where entryId = '19115260'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.05'
where entryId = '19147028'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.48'
where entryId = '19984498'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '9.35'
where entryId = '20167586'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '20234775'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.58'
where entryId = '21064820'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.32'
where entryId = '21065170'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.44'
where entryId = '21258163'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.44'
where entryId = '22004766'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.92'
where entryId = '22455288'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '142.47'
where entryId = '22464276'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.19'
where entryId = '23146103'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '7.57'
where entryId = '23168528'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.22'
where entryId = '23246290'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '23641881'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '24012650'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '24505407'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '24519472'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '4.97'
where entryId = '29135886'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '8.46'
where entryId = '29332363'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '52.12'
where entryId = '29474624'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '29960518'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.82'
where entryId = '30518674'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '30554645'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '6.08'
where entryId = '30912150'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '31253686'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '3.06'
where entryId = '32165763'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.21'
where entryId = '32907467'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.75'
where entryId = '32979034'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '2.07'
where entryId = '33324612'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.19'
where entryId = '33346590'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '34607931'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '34744966'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.06'
where entryId = '35073652'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '45.56'
where entryId = '38323450'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '38468673'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '12.37'
where entryId = '39908416'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.3'
where entryId = '40856512'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '14.28'
where entryId = '41650621'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '5.26'
where entryId = '41674087'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '3'
where entryId = '41698063'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '266.02'
where entryId = '42058790'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.8'
where entryId = '42061728'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.11'
where entryId = '42068477'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '5.69'
where entryId = '42072898'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '17.24'
where entryId = '42092010'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '4.79'
where entryId = '42098969'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.81'
where entryId = '42103580'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '17.39'
where entryId = '42105208'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.79'
where entryId = '42114346'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.04'
where entryId = '42119626'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '42133487'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '155.42'
where entryId = '42137392'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '7.23'
where entryId = '42145277'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.05'
where entryId = '42152226'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '62.73'
where entryId = '42155098'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.1'
where entryId = '42157638'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '2.67'
where entryId = '42162352'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '2.8'
where entryId = '42164319'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.03'
where entryId = '42166003'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.1'
where entryId = '42180907'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '2.59'
where entryId = '42186105'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '2.4'
where entryId = '42186294'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.06'
where entryId = '42191608'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.56'
where entryId = '42195621'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.22'
where entryId = '42200948'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.34'
where entryId = '42201952'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '2.82'
where entryId = '42220963'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '9.92'
where entryId = '42223905'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '16.68'
where entryId = '42228503'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.58'
where entryId = '42235112'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '1.74'
where entryId = '42245352'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '5.82'
where entryId = '42252441'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '42460634'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '42467409'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '42469068'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.62'
where entryId = '42497633'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0.51'
where entryId = '43978836'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '17.03'
where entryId = '46539408'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '239.5'
where entryId = '47280538'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '49532075'
update current13Fpositions set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174' ,
percentOut = '0'
where entryId = '50525077'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '05564E106'
Number of Rows :5
update archive13F set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174'
where entryId = '969962'
update archive13F set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174'
where entryId = '47197864'
update archive13F set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174'
where entryId = '67780747'
update archive13F set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174'
where entryId = '65629189'
update archive13F set
compid = '130614',
sectorNum = '304004',
sectorDes = 'REIT - Diversified',
issuerCik = '0001011174'
where entryId = '32247848'
End Function
The Script is complete, exiting....