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: : 130730
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130730'
The Shares Amount is 57040000
The cusip is 206708109
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '206708109'
Number of Rows :159
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '1599399'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '8.77'
where entryId = '3504199'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '3685807'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '7.21'
where entryId = '3727790'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '103.45'
where entryId = '4374148'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '8.78'
where entryId = '9754111'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '30.68'
where entryId = '10231975'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '23.6'
where entryId = '11449290'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '1.92'
where entryId = '12195976'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '12327104'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.01'
where entryId = '12986903'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '2.7'
where entryId = '13022728'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '121.54'
where entryId = '13242491'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '13401962'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.03'
where entryId = '13467645'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '3.33'
where entryId = '13644285'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '13644868'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '13678414'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '13755643'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.07'
where entryId = '13907262'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '9.74'
where entryId = '13932229'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '3.03'
where entryId = '13937645'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '108.71'
where entryId = '14309825'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '24.21'
where entryId = '14326841'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.03'
where entryId = '14660994'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '1.89'
where entryId = '14677895'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '14822644'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '3.67'
where entryId = '14873155'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '15230909'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '15257975'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '15262181'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '7.01'
where entryId = '15323004'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '86.18'
where entryId = '15387375'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '3.86'
where entryId = '15449520'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '16.78'
where entryId = '15478600'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '8.58'
where entryId = '15537494'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.07'
where entryId = '15618396'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.54'
where entryId = '16109537'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.01'
where entryId = '16117194'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '2.5'
where entryId = '16194142'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '109.44'
where entryId = '16352807'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '109.44'
where entryId = '16354061'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '1.73'
where entryId = '16393100'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '16615542'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '174.12'
where entryId = '16645237'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '1.32'
where entryId = '16666244'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '90.33'
where entryId = '16673607'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '16762917'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '3.81'
where entryId = '16834757'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '18.51'
where entryId = '16961249'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.6'
where entryId = '17014785'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '2.29'
where entryId = '17051472'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '17104148'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.04'
where entryId = '17107503'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.54'
where entryId = '17135459'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '1.28'
where entryId = '17157938'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '59.22'
where entryId = '17197067'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '8.53'
where entryId = '17484885'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.11'
where entryId = '17520536'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.01'
where entryId = '17540445'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.05'
where entryId = '17557508'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '92.77'
where entryId = '17727637'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '17772223'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '2.45'
where entryId = '17977786'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.54'
where entryId = '18065111'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '29.59'
where entryId = '18175226'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '5.89'
where entryId = '18184021'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '94.72'
where entryId = '18253032'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '3.92'
where entryId = '18297857'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '42.26'
where entryId = '18386341'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '9.36'
where entryId = '18393748'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '98.29'
where entryId = '18492883'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '18.7'
where entryId = '18540267'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '18550947'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '18657994'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.11'
where entryId = '18660119'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '5.57'
where entryId = '18783646'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.08'
where entryId = '19103922'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.01'
where entryId = '19115403'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '1.92'
where entryId = '19147577'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '25.72'
where entryId = '19824241'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.05'
where entryId = '19880276'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '12.82'
where entryId = '19967618'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '47.79'
where entryId = '20128640'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '42.18'
where entryId = '20128762'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '27.35'
where entryId = '20306901'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '27.42'
where entryId = '20307160'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '20890063'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '20937684'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '22.81'
where entryId = '21466294'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '11.22'
where entryId = '21467173'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '6.11'
where entryId = '22369316'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '9.01'
where entryId = '22785584'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '1.23'
where entryId = '23169664'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '24505283'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '24519873'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '24921658'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '24928514'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '13.89'
where entryId = '29136237'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '29960507'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '31252792'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '270.85'
where entryId = '31774071'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '3.86'
where entryId = '32165972'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '19.8'
where entryId = '32907625'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '14.39'
where entryId = '33324672'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '34607608'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '35974992'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.02'
where entryId = '37276760'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '1.52'
where entryId = '38324724'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '4.53'
where entryId = '40855479'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '40863100'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '41115248'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '41123165'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '24.73'
where entryId = '41650820'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '4.86'
where entryId = '41674267'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '3.7'
where entryId = '42062238'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.89'
where entryId = '42068136'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.05'
where entryId = '42069019'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '9.79'
where entryId = '42074845'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '1.44'
where entryId = '42092220'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '42096467'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '16.53'
where entryId = '42100540'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '14.26'
where entryId = '42105465'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '2.16'
where entryId = '42114486'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '1.16'
where entryId = '42118426'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '42133554'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.71'
where entryId = '42145477'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.5'
where entryId = '42148843'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.61'
where entryId = '42156125'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.11'
where entryId = '42157885'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.04'
where entryId = '42168863'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.12'
where entryId = '42181133'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '42203303'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '1.88'
where entryId = '42221008'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '6.81'
where entryId = '42224248'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.69'
where entryId = '42226720'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '14.57'
where entryId = '42230260'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '155.99'
where entryId = '42231025'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '2'
where entryId = '42236855'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '41.98'
where entryId = '42244600'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '207.93'
where entryId = '42244997'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.73'
where entryId = '42251074'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.57'
where entryId = '42252106'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '4.77'
where entryId = '42252589'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '42267132'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '1.01'
where entryId = '42497803'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.47'
where entryId = '43979157'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.45'
where entryId = '45604810'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0.93'
where entryId = '46116637'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '10.35'
where entryId = '46538525'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '1.14'
where entryId = '49940971'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '50512139'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '50907876'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '31.99'
where entryId = '51209472'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '170.21'
where entryId = '51244837'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '5.62'
where entryId = '51524434'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '1.44'
where entryId = '51608842'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '53577914'
update current13Fpositions set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026' ,
percentOut = '0'
where entryId = '53592722'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '206708109'
Number of Rows :2
update archive13F set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026'
where entryId = '51383481'
update archive13F set
compid = '130730',
sectorNum = '602008',
sectorDes = 'Technical & System Software',
issuerCik = '0001066026'
where entryId = '91718046'
End Function
The Script is complete, exiting....