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: : 142441
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '142441'
The Shares Amount is 1740000000
The cusip is 097751200
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '097751200'
Number of Rows :15
update current13Fpositions set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029' ,
percentOut = '0.07'
where entryId = '15164345'
update current13Fpositions set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029' ,
percentOut = '0'
where entryId = '15447443'
update current13Fpositions set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029' ,
percentOut = '0.89'
where entryId = '15626663'
update current13Fpositions set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029' ,
percentOut = '0.07'
where entryId = '16584147'
update current13Fpositions set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029' ,
percentOut = '6.32'
where entryId = '17009486'
update current13Fpositions set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029' ,
percentOut = '1.56'
where entryId = '17482829'
update current13Fpositions set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029' ,
percentOut = '0.57'
where entryId = '17527066'
update current13Fpositions set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029' ,
percentOut = '0.07'
where entryId = '18197104'
update current13Fpositions set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029' ,
percentOut = '0.26'
where entryId = '18664481'
update current13Fpositions set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029' ,
percentOut = '0'
where entryId = '35982304'
update current13Fpositions set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029' ,
percentOut = '0.17'
where entryId = '40887025'
update current13Fpositions set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029' ,
percentOut = '0.68'
where entryId = '42160250'
update current13Fpositions set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029' ,
percentOut = '0.06'
where entryId = '42209092'
update current13Fpositions set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029' ,
percentOut = '0'
where entryId = '42266827'
update current13Fpositions set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029' ,
percentOut = '0.06'
where entryId = '73973710'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '097751200'
Number of Rows :122
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '67464847'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '66675786'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '68382737'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '66810029'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '67930695'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '67543681'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '65585320'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '66788088'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '65775601'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '65079446'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '66909826'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '66181575'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '66747191'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '66821972'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '65667749'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '66674242'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '65515672'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '65128182'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '65152799'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '66655711'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '65024218'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '63361492'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '63386523'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '63409758'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '63492757'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '63419777'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '63954056'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '64074750'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '64668177'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '64967642'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '63951210'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '64828069'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '63701583'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '64250723'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '68579313'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '68491936'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '68542150'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '68433007'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '69208672'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '68576614'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '69617664'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '70015188'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '69906869'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '70098678'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '70179924'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '71703512'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '71367134'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '70559776'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '72170171'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '73411954'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '72358123'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '72095353'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '73002028'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '74762658'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '73823639'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '75210003'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '74230746'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '74832565'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '75321520'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '75760382'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '75751837'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '77608266'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '76639355'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '77162292'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '78588168'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '79053452'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '79261982'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '79076156'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '79859866'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '80379151'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '80836451'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '81266056'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '81820484'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '83322855'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '83414249'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '83804100'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '83507029'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '85531817'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '85278546'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '85282986'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '87678107'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '86606882'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '85918541'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '87516706'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '87941890'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '88471186'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '89081805'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '90803195'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '90813467'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '91849728'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '92202792'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '92568387'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '92998218'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '94370996'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '95918394'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '96557750'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '98362623'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '100806021'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '98785154'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '100240331'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '100814974'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '100806305'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '102980201'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '103275045'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '103664149'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '103684153'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '103388113'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '105275232'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '105729614'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '106368848'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '108219149'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '106081963'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '108112260'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '108391853'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '109832401'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '105734089'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '112523922'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '111812156'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '108681627'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '111789094'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '114771106'
update archive13F set
compid = '142441',
sectorNum = '101005',
sectorDes = 'Trucks & Other Vehicles',
issuerCik = '9000000029'
where entryId = '113559774'
End Function
The Script is complete, exiting....