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: : 151494
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '151494'
The Shares Amount is 366980000
The cusip is 38500T200
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '38500T200'
Number of Rows :72
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0.97'
where entryId = '131184234'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '1.49'
where entryId = '131806952'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '7.62'
where entryId = '131628139'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '3.19'
where entryId = '131023074'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '1.09'
where entryId = '130760793'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0'
where entryId = '132578721'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '2.55'
where entryId = '131778427'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0.14'
where entryId = '130859385'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '3.64'
where entryId = '131563532'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0.17'
where entryId = '131710897'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0.42'
where entryId = '132117739'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0'
where entryId = '132576202'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '7.35'
where entryId = '131175737'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0'
where entryId = '132535148'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '1.48'
where entryId = '131997079'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0.32'
where entryId = '129899212'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0.59'
where entryId = '132131075'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '20.88'
where entryId = '131651359'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0'
where entryId = '130403977'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '5.36'
where entryId = '130814571'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0.47'
where entryId = '131665187'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '20.71'
where entryId = '131802240'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0'
where entryId = '130797441'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0'
where entryId = '132608522'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0.66'
where entryId = '132128241'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '1.64'
where entryId = '131860693'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0'
where entryId = '127656445'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '13.48'
where entryId = '131857437'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0.32'
where entryId = '131600042'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0.21'
where entryId = '131657409'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '2.05'
where entryId = '131976581'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '21.05'
where entryId = '131150074'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0.1'
where entryId = '132241549'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '1.8'
where entryId = '131865437'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '1.4'
where entryId = '130586894'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '2.81'
where entryId = '132224029'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0.77'
where entryId = '130918843'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0'
where entryId = '132564837'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '8.57'
where entryId = '131150040'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0'
where entryId = '130472320'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '9.82'
where entryId = '132179379'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0'
where entryId = '132554600'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0'
where entryId = '132614180'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0.4'
where entryId = '132380753'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '10.98'
where entryId = '132141651'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '9.83'
where entryId = '131872051'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0.05'
where entryId = '131253930'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '1.46'
where entryId = '132266715'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0.78'
where entryId = '131415935'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '7.88'
where entryId = '131170382'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0.39'
where entryId = '130943939'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0'
where entryId = '132539783'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0.56'
where entryId = '131488781'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0.12'
where entryId = '130836521'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0.28'
where entryId = '131941654'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0.28'
where entryId = '130511072'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '17.74'
where entryId = '131647321'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '4.03'
where entryId = '130246512'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '43.48'
where entryId = '132186061'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0'
where entryId = '130189385'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0.42'
where entryId = '131649313'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0'
where entryId = '131377935'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0'
where entryId = '131298319'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0'
where entryId = '131363060'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0'
where entryId = '132596359'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0.27'
where entryId = '132083605'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '1.8'
where entryId = '132351402'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0.53'
where entryId = '132409724'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0.2'
where entryId = '132429255'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0.1'
where entryId = '132479700'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '0'
where entryId = '132519526'
update current13Fpositions set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441' ,
percentOut = '1.82'
where entryId = '132637134'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '38500T200'
Number of Rows :195
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '121151615'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '121494428'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '122217826'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '121812477'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '121696676'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '122308205'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '122218329'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '122456578'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '122218183'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '122393429'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '122072319'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '124117278'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '121711355'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '122250584'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '122636762'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '123073678'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '121755128'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '122557703'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126243793'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '121923492'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '122656565'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '123764047'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '123734145'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '123411483'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '123413301'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '123425861'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '123656841'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '123033932'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '122893612'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '123576395'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '123268892'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '123371942'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '122538838'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '122373610'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '123561590'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '123428523'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '123336173'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '122958594'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '123730961'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '123723669'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '123176019'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '123849735'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '123710801'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '123585727'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '122664623'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '123498898'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '123833920'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '122972003'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '123817088'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '123859663'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '123771357'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '123822865'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '124028335'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '122474545'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '124314759'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '124176883'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '124201652'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '125232405'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '124272270'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '124812609'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '125278940'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '125371121'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '124153259'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126923238'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '124463066'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '125463593'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '124945795'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '124575441'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126398762'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '125201418'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '125218543'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '124680727'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '124405492'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '125036670'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '125265994'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '124575493'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '125823413'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '124961154'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '125004432'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '125403759'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '125440807'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '125609380'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126807378'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126804028'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '125669068'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '125689239'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '125692153'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '125759480'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '125794510'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '125818917'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '125865787'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '125873326'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '125895901'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '125905076'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '125918923'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '125922097'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126018968'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126038574'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126102518'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126147805'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126150654'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126178941'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126210979'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126217287'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126245533'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126274105'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126854212'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126281875'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126334813'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126351457'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126402607'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126421097'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126852830'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126447227'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126462117'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126513089'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126520945'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126564987'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126578279'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126836409'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '126772292'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '127174245'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '127247349'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '127032997'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '127783444'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '127180554'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '127775905'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '127284353'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129223033'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128378074'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '127861422'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129727919'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129584867'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129435389'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128674253'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128163432'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128163401'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128381064'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129304321'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '127825379'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128850520'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '127846514'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128186299'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128945372'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129284796'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128411242'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '127880046'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129261206'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128617583'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128794399'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '127527984'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129205544'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129695304'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129252161'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128467483'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129313950'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129269327'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129745981'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129372384'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129258699'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128663382'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129702791'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129788234'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128666340'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129070804'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129384173'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '127919053'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128914833'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128775043'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '127912449'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129187127'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128890397'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129742448'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128619582'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129162040'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128848252'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128860629'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128880983'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128578425'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129707110'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129202384'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128641689'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128439950'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129570906'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128870582'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129022599'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129543424'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129217692'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129741228'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128016418'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129127647'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '128258299'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '127972734'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129751018'
update archive13F set
compid = '151494',
sectorNum = '901002',
sectorDes = 'Integrated Oil & Gas',
issuerCik = '0001273441'
where entryId = '129756075'
End Function
The Script is complete, exiting....