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: : 159688
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '159688'
The Shares Amount is 9000000
The cusip is 06740P650
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '06740P650'
Number of Rows :2
update current13Fpositions set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154' ,
percentOut = '0.11'
where entryId = '51208156'
update current13Fpositions set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154' ,
percentOut = '0.13'
where entryId = '65087871'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '06740P650'
Number of Rows :65
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '68054127'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '65671576'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '66591345'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '66319964'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '63392443'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '64008185'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '64590885'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '64649082'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '69557190'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '71650719'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '71402011'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '72750296'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '73425661'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '73322028'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '75492375'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '75248025'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '75060035'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '77003487'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '77592985'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '77380272'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '78636095'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '78668416'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '78860642'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '79291569'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '81127397'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '80991224'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '81014943'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '81379965'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '82734615'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '83051834'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '83069383'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '83439208'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '84640961'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '84680499'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '84859948'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '85301872'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '86907987'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '86668162'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '86955484'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '87681444'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '89282392'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '88560293'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '89155897'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '90161435'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '90910157'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '90947292'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '92650663'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '92231904'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '93146475'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '95272046'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '94755499'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '94862495'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '95906841'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '96220748'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '96715085'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '96878539'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '98177918'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '99208158'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '99253481'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '99382241'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '102136157'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '102427986'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '102180150'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '104803851'
update archive13F set
compid = '159688',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004154'
where entryId = '105474938'
End Function
The Script is complete, exiting....