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: : 130959
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130959'
The Shares Amount is 302460000
The cusip is 716495106
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '716495106'
Number of Rows :174
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '1.99'
where entryId = '2828048'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '2.58'
where entryId = '3732502'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '4419013'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '1.16'
where entryId = '5218611'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '4.01'
where entryId = '5455551'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '18.72'
where entryId = '7169518'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.5'
where entryId = '7306094'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '153.1'
where entryId = '9342126'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.53'
where entryId = '9756547'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '8.59'
where entryId = '10223801'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '42.82'
where entryId = '10245736'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '1187.43'
where entryId = '11217612'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.72'
where entryId = '11266113'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '21.93'
where entryId = '11387865'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '11708727'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '13.23'
where entryId = '11894258'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '12192680'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.09'
where entryId = '12288342'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '3.33'
where entryId = '12290876'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '1.93'
where entryId = '12319927'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '66.4'
where entryId = '12811324'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.72'
where entryId = '12847153'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '3.08'
where entryId = '12924730'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '9.11'
where entryId = '12925355'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '14.5'
where entryId = '12926734'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '53.27'
where entryId = '13242972'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '13506838'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '13645095'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '13671804'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '13817853'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '1.39'
where entryId = '13900396'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '3.42'
where entryId = '13932736'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.49'
where entryId = '14157193'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '36.44'
where entryId = '14218923'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.62'
where entryId = '14232008'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '31.75'
where entryId = '14310361'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '7.57'
where entryId = '14328120'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '14826127'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.01'
where entryId = '14877124'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '1.18'
where entryId = '14952131'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '15132720'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '3.46'
where entryId = '15179759'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '3.23'
where entryId = '15259554'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '19.87'
where entryId = '15387512'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.62'
where entryId = '15399775'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '22.45'
where entryId = '15473855'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.21'
where entryId = '15503333'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.21'
where entryId = '15513930'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '15515790'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.3'
where entryId = '15610120'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.22'
where entryId = '15632534'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '11.77'
where entryId = '15761485'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.48'
where entryId = '15775439'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.22'
where entryId = '15815784'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '5.09'
where entryId = '16000573'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '1.28'
where entryId = '16029305'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '139.72'
where entryId = '16041775'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.03'
where entryId = '16196094'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '33.55'
where entryId = '16353412'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '33.55'
where entryId = '16354666'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '7.54'
where entryId = '16362250'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '105.1'
where entryId = '16362616'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '16528909'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.78'
where entryId = '16565989'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.37'
where entryId = '16610988'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '57.1'
where entryId = '16673719'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '47.87'
where entryId = '16729611'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '16789031'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '16874138'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '1.02'
where entryId = '16874645'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.02'
where entryId = '16938573'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '16945602'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '16950451'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '24.09'
where entryId = '16961739'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '13.25'
where entryId = '17012519'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.38'
where entryId = '17045509'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.11'
where entryId = '17051581'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.35'
where entryId = '17066929'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '17074895'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '17108154'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.66'
where entryId = '17157813'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '18.54'
where entryId = '17204303'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '17226362'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '5.58'
where entryId = '17419538'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '2.86'
where entryId = '17426076'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '1.98'
where entryId = '17458370'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '46.77'
where entryId = '17466571'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.15'
where entryId = '17468596'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.83'
where entryId = '17542406'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '1.98'
where entryId = '17561645'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '14.71'
where entryId = '17728216'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '17772152'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '17786695'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.72'
where entryId = '17859347'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '37.16'
where entryId = '17966500'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.01'
where entryId = '17979736'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '1.89'
where entryId = '17988275'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '22.19'
where entryId = '18037429'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '1'
where entryId = '18066268'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.05'
where entryId = '18067459'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '12.83'
where entryId = '18108764'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '12.15'
where entryId = '18149731'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '28.17'
where entryId = '18170867'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.31'
where entryId = '18182502'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '92.22'
where entryId = '18253145'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '18261354'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '18273736'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '18355647'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '14.09'
where entryId = '18375752'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.36'
where entryId = '18383822'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '37.9'
where entryId = '18493370'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '24.25'
where entryId = '18540731'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.34'
where entryId = '18545632'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '1.21'
where entryId = '18549136'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '18551692'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.19'
where entryId = '18564076'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '101.89'
where entryId = '18569836'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.01'
where entryId = '18660724'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.73'
where entryId = '18809949'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '4.13'
where entryId = '18819003'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '145.51'
where entryId = '19054409'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '19063487'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.82'
where entryId = '19092668'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '4.13'
where entryId = '19116763'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.01'
where entryId = '19149496'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '19238839'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.56'
where entryId = '19824354'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.62'
where entryId = '19884738'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.73'
where entryId = '19982915'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.38'
where entryId = '20110398'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '7.71'
where entryId = '20167293'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '130.92'
where entryId = '20168758'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.34'
where entryId = '20243663'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '3.93'
where entryId = '21207659'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.03'
where entryId = '21274095'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '55.36'
where entryId = '21359365'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.41'
where entryId = '21464806'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.03'
where entryId = '22313355'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.29'
where entryId = '22640135'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.14'
where entryId = '22686524'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '61.42'
where entryId = '22719179'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.5'
where entryId = '22745478'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.83'
where entryId = '23074106'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.03'
where entryId = '23159604'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '12.57'
where entryId = '23175750'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '1.02'
where entryId = '23355799'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '23404415'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '9.92'
where entryId = '23443581'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '3.56'
where entryId = '23477614'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '24013547'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.17'
where entryId = '24138686'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '24521882'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '24927404'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.38'
where entryId = '25354378'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.39'
where entryId = '26773824'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '28132818'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.02'
where entryId = '28779909'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '9.68'
where entryId = '29137925'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '9.27'
where entryId = '29318574'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '1.32'
where entryId = '29386131'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '43.81'
where entryId = '29672936'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '29696412'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.08'
where entryId = '30518767'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '30835266'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '31252905'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '31559089'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0.34'
where entryId = '31890122'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '32529668'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '32784648'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '32956743'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '32966302'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '33171899'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '33689975'
update current13Fpositions set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324' ,
percentOut = '0'
where entryId = '33691579'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '716495106'
Number of Rows :3
update archive13F set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324'
where entryId = '66068290'
update archive13F set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324'
where entryId = '65629314'
update archive13F set
compid = '130959',
sectorNum = '901001',
sectorDes = 'Independent Oil & Gas',
issuerCik = '0001059324'
where entryId = '64024570'
End Function
The Script is complete, exiting....