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: : 159693
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '159693'
The Shares Amount is 9000000
The cusip is 06740L493
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '06740L493'
Number of Rows :3
update current13Fpositions set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159' ,
percentOut = '1.82'
where entryId = '51208098'
update current13Fpositions set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159' ,
percentOut = '0'
where entryId = '65231622'
update current13Fpositions set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159' ,
percentOut = '3.09'
where entryId = '69269475'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '06740L493'
Number of Rows :104
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '68083916'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '67856450'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '68054111'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '66095122'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '67870648'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '65671638'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '67688523'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '68023818'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '66284274'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '66350136'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '66364196'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '66319948'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '65765032'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '63392444'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '64006941'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '64202315'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '64590869'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '64631602'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '64550550'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '64333670'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '64649048'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '69557174'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '69590690'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '69966932'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '69374723'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '71401995'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '71677401'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '71606869'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '71404881'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '72751997'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '73425645'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '73644222'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '73598975'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '73454968'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '75493685'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '75248009'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '75511295'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '75456007'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '75669578'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '77400737'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '77003501'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '77480206'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '76206647'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '77380266'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '77295876'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '79530357'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '78636107'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '78668374'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '78860623'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '79194417'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '79291563'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '79333072'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '79517810'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '81127367'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '80991212'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '81014938'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '81332884'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '81379960'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '81422505'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '82734582'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '83051827'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '83069378'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '83439203'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '83460739'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '83614105'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '83385527'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '84640954'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '84680494'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '84859943'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '85301867'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '85325287'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '85404902'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '85411737'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '85653999'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '86907981'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '87642514'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '86763277'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '86771091'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '86955479'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '87445453'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '87681499'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '87573229'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '88560281'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '89155892'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '89539016'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '89624716'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '89713233'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '89660237'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '90910168'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '91652684'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '90947287'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '91489716'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '91808278'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '92650655'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '93146470'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '93528002'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '93600715'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '93661105'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '95588977'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '94755507'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '95984978'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '95989725'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '95992929'
update archive13F set
compid = '159693',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004159'
where entryId = '97582686'
End Function
The Script is complete, exiting....