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: : 131717
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '131717'
The Shares Amount is 138450000
The cusip is 210795308
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '210795308'
Number of Rows :112
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '1366996'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '2.17'
where entryId = '1701079'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '203.26'
where entryId = '1779889'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0.01'
where entryId = '1827315'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0.06'
where entryId = '2207597'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '210.38'
where entryId = '2608185'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '1.41'
where entryId = '2831355'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '1.02'
where entryId = '3504229'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '4.41'
where entryId = '3682522'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '7.67'
where entryId = '3727848'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '1.68'
where entryId = '3916694'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '42.18'
where entryId = '5455260'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '5581092'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '5.06'
where entryId = '6059174'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '6484230'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '10.83'
where entryId = '6793569'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0.48'
where entryId = '6811801'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '17.18'
where entryId = '7429625'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '22.02'
where entryId = '8276559'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '8499772'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '1'
where entryId = '8616547'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '9057468'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '1.43'
where entryId = '9157874'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '1.12'
where entryId = '9341165'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0.5'
where entryId = '9754133'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '6.84'
where entryId = '10223002'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '282.2'
where entryId = '10232129'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0.72'
where entryId = '10833971'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '1.74'
where entryId = '11065997'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '11115582'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0.48'
where entryId = '11225978'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0.57'
where entryId = '11264624'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '17.18'
where entryId = '11293732'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0.09'
where entryId = '11443197'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '7.58'
where entryId = '11451495'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '2.56'
where entryId = '11464452'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '10.26'
where entryId = '12286702'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '179.07'
where entryId = '12600473'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '12709640'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '12790742'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0.12'
where entryId = '12934077'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '1.81'
where entryId = '12956724'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0.06'
where entryId = '12972396'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '1.35'
where entryId = '12986910'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '12990452'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '2.58'
where entryId = '12992267'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '13817314'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '2.55'
where entryId = '14074461'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0.08'
where entryId = '14267075'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '1.36'
where entryId = '14326855'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '126.63'
where entryId = '14344153'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '14455598'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '14575514'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '2.1'
where entryId = '14648921'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '2.53'
where entryId = '14662514'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '14822689'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '5.47'
where entryId = '14873194'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '114.6'
where entryId = '15301908'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '59.83'
where entryId = '15341022'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '2.1'
where entryId = '15468086'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '15515797'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '19.03'
where entryId = '15580603'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0.07'
where entryId = '15618404'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '15983429'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '16284948'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '3.37'
where entryId = '16675805'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0.23'
where entryId = '16938035'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '16945589'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '17074020'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0.07'
where entryId = '17137513'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '1.45'
where entryId = '17157881'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '6.33'
where entryId = '17197130'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0.94'
where entryId = '17468174'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0.02'
where entryId = '17526122'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0.88'
where entryId = '17557514'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '17671442'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '17787120'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '56.51'
where entryId = '17859073'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '2.69'
where entryId = '18149497'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '18154047'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '2.93'
where entryId = '18177137'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '3.76'
where entryId = '18258612'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0.09'
where entryId = '18312330'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '1.24'
where entryId = '18568690'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '1.08'
where entryId = '18664516'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '9.23'
where entryId = '18783649'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0.09'
where entryId = '19147594'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '9.01'
where entryId = '19263881'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '1.41'
where entryId = '19494816'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '19629251'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '19633432'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '124.38'
where entryId = '19679405'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0.01'
where entryId = '19880283'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '20937801'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '142.48'
where entryId = '21042475'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '21430214'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '1.81'
where entryId = '22639909'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '7.27'
where entryId = '22865374'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '15.25'
where entryId = '23169714'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '24505278'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '24519894'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '24533992'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '5.13'
where entryId = '24593380'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '24928528'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '21.67'
where entryId = '25062519'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '23.29'
where entryId = '26083467'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '26595319'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0.75'
where entryId = '26773624'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '28814642'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '29312386'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '29960597'
update current13Fpositions set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687' ,
percentOut = '0'
where entryId = '130458798'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '210795308'
Number of Rows :26
update archive13F set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687'
where entryId = '970002'
update archive13F set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687'
where entryId = '4399350'
update archive13F set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687'
where entryId = '5243681'
update archive13F set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687'
where entryId = '65629322'
update archive13F set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687'
where entryId = '77780396'
update archive13F set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687'
where entryId = '79944628'
update archive13F set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687'
where entryId = '81762372'
update archive13F set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687'
where entryId = '83866131'
update archive13F set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687'
where entryId = '86101719'
update archive13F set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687'
where entryId = '87802715'
update archive13F set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687'
where entryId = '90134102'
update archive13F set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687'
where entryId = '92204114'
update archive13F set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687'
where entryId = '94253187'
update archive13F set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687'
where entryId = '96027745'
update archive13F set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687'
where entryId = '98416640'
update archive13F set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687'
where entryId = '100988669'
update archive13F set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687'
where entryId = '103549084'
update archive13F set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687'
where entryId = '105763743'
update archive13F set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687'
where entryId = '109067395'
update archive13F set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687'
where entryId = '111854645'
update archive13F set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687'
where entryId = '114286139'
update archive13F set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687'
where entryId = '116760137'
update archive13F set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687'
where entryId = '119645236'
update archive13F set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687'
where entryId = '122409239'
update archive13F set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687'
where entryId = '124954024'
update archive13F set
compid = '131717',
sectorNum = '505003',
sectorDes = 'Major Airlines',
issuerCik = '0000319687'
where entryId = '127815163'
End Function
The Script is complete, exiting....