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: : 133806
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '133806'
The Shares Amount is 45214000
The cusip is 654086107
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '654086107'
Number of Rows :184
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.19'
where entryId = '1144962'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.43'
where entryId = '1224314'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.44'
where entryId = '1265117'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '638'
where entryId = '1570052'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.01'
where entryId = '1827887'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '23.04'
where entryId = '1983738'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '60.91'
where entryId = '2832653'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.84'
where entryId = '3506209'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '15.03'
where entryId = '3731896'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.67'
where entryId = '3917371'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '4415419'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.07'
where entryId = '5086912'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '5580217'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.43'
where entryId = '6910753'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.03'
where entryId = '8273403'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '3.81'
where entryId = '9341989'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.15'
where entryId = '9419634'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '6.42'
where entryId = '9756186'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '10.01'
where entryId = '10223689'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '189.6'
where entryId = '10243862'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '2.63'
where entryId = '10835282'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '11038534'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '2.94'
where entryId = '11077358'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '244.42'
where entryId = '11103407'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.33'
where entryId = '11180450'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.06'
where entryId = '11226001'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '11274260'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.17'
where entryId = '11387832'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '199.17'
where entryId = '11449896'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '6.33'
where entryId = '11778504'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '12116299'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.55'
where entryId = '12135126'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.3'
where entryId = '12182740'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '612.14'
where entryId = '12230872'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '19.16'
where entryId = '12288116'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.4'
where entryId = '12319689'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '12326798'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.01'
where entryId = '12424257'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.3'
where entryId = '12570313'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '5.53'
where entryId = '12627091'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.19'
where entryId = '12709419'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '3.16'
where entryId = '12710005'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.37'
where entryId = '12781068'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '11.08'
where entryId = '12809525'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.17'
where entryId = '12926709'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.09'
where entryId = '12934677'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.98'
where entryId = '12972462'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.23'
where entryId = '13024332'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '3.83'
where entryId = '13242917'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '6.33'
where entryId = '13244878'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '13455822'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.17'
where entryId = '13468094'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '13505318'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '13645036'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.55'
where entryId = '13647866'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.01'
where entryId = '13669531'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '13678110'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.68'
where entryId = '13681454'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.44'
where entryId = '13938948'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '14019542'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.29'
where entryId = '14045608'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '2.67'
where entryId = '14074128'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '3.87'
where entryId = '14193496'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '14297418'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '3.78'
where entryId = '14310294'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '18.28'
where entryId = '14327952'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '5.15'
where entryId = '14332955'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '2.19'
where entryId = '14389157'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.01'
where entryId = '14552863'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '8.91'
where entryId = '14584062'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.17'
where entryId = '14661597'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '23.09'
where entryId = '14662580'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.02'
where entryId = '14679449'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '14825690'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '289.72'
where entryId = '14876562'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '14944331'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '15174994'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '8.43'
where entryId = '15212707'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.55'
where entryId = '15216286'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.44'
where entryId = '15259314'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '15261881'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.68'
where entryId = '15333462'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.01'
where entryId = '15337151'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.03'
where entryId = '15450237'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.09'
where entryId = '15461268'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.01'
where entryId = '15618949'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '2.27'
where entryId = '15635315'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '3.65'
where entryId = '15730574'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '15778613'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.29'
where entryId = '15973041'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.29'
where entryId = '15973427'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '4.19'
where entryId = '15998975'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.77'
where entryId = '16117795'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.09'
where entryId = '16173063'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.02'
where entryId = '16195800'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '16287308'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '5.47'
where entryId = '16353333'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '5.47'
where entryId = '16354587'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '16521389'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.02'
where entryId = '16553991'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.42'
where entryId = '16582661'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.16'
where entryId = '16610896'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '16615241'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '16633583'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.57'
where entryId = '16703738'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.44'
where entryId = '16764313'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1'
where entryId = '16835462'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '13.26'
where entryId = '16908680'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.01'
where entryId = '16920289'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.01'
where entryId = '16938459'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '17013132'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.03'
where entryId = '17015904'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '17074768'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.09'
where entryId = '17098608'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '17104580'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.01'
where entryId = '17108056'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.05'
where entryId = '17135288'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.22'
where entryId = '17157983'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '2.06'
where entryId = '17161831'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '29.76'
where entryId = '17203212'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.29'
where entryId = '17436839'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.56'
where entryId = '17468542'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.04'
where entryId = '17526271'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.77'
where entryId = '17541068'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.41'
where entryId = '17542295'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.66'
where entryId = '17557990'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '17674041'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '2.86'
where entryId = '17728138'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.02'
where entryId = '17979439'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '8.34'
where entryId = '17989791'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.29'
where entryId = '18033823'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '18041670'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.51'
where entryId = '18048487'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '18057983'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '18091562'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.41'
where entryId = '18116398'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.44'
where entryId = '18182260'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.01'
where entryId = '18293901'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.02'
where entryId = '18298577'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.09'
where entryId = '18304642'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '10.31'
where entryId = '18493304'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '18551587'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.01'
where entryId = '18569669'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '2.65'
where entryId = '18572833'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '4.2'
where entryId = '18576658'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.22'
where entryId = '18623307'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.01'
where entryId = '18660629'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.55'
where entryId = '18672784'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '18711494'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.31'
where entryId = '18761581'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '9.78'
where entryId = '18806138'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '2.16'
where entryId = '18852895'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.62'
where entryId = '19116012'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.02'
where entryId = '19149194'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '19238529'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '19555636'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '13.92'
where entryId = '19615429'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '19880596'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '17.47'
where entryId = '19902531'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.47'
where entryId = '20693425'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '18.06'
where entryId = '20718587'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '21182522'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '3.67'
where entryId = '21269716'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '22500088'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.99'
where entryId = '23146378'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '10.76'
where entryId = '23174919'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '23.55'
where entryId = '24075443'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.56'
where entryId = '24087017'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '24521604'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '24927270'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.38'
where entryId = '25181187'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '20.66'
where entryId = '26733919'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.25'
where entryId = '28730987'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '29312381'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '169.22'
where entryId = '29664056'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0.09'
where entryId = '29832130'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '31253135'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '136.38'
where entryId = '31740845'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '3.12'
where entryId = '31889988'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '1.05'
where entryId = '32908304'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '3.34'
where entryId = '33028441'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '5.3'
where entryId = '42132788'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '4.28'
where entryId = '42151538'
update current13Fpositions set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020' ,
percentOut = '0'
where entryId = '42266723'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '654086107'
Number of Rows :4
update archive13F set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020'
where entryId = '63446097'
update archive13F set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020'
where entryId = '63646765'
update archive13F set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020'
where entryId = '35182357'
update archive13F set
compid = '133806',
sectorNum = '1001003',
sectorDes = 'Gas Utilities',
issuerCik = '0000072020'
where entryId = '79912838'
End Function
The Script is complete, exiting....