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: : 160357
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '160357'
The Shares Amount is 4550000
The cusip is 46138E883
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '46138E883'
Number of Rows :0
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '46138E883'
Number of Rows :90
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '77491384'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '76520634'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '76451662'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '77634256'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '76494436'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '77404850'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '77185928'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '77444692'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '76304700'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '76877510'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '77207774'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '76830560'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '77522566'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '77512421'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '77008238'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '77481508'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '77385292'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '76207194'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '77380940'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '76562474'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '77297448'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '77283596'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '79530080'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '78213675'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '79175301'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '78369497'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '78341061'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '78394001'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '78489891'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '79485472'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '79537148'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '79269019'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '79507887'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '79502814'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '78671627'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '78865350'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '79475154'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '79493776'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '79195867'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '79215305'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '79292341'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '79304967'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '79337446'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '79416184'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '79630896'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '79372956'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '78322276'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '79740167'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '80660932'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '80957404'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '80110035'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '80423492'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '80953675'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '80978613'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '81132124'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '81364498'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '81466368'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '80578814'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '81018238'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '81043664'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '81179922'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '81334611'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '81349874'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '81380801'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '81396510'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '81426537'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '81620291'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '81598266'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '83627842'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '81968689'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '82175236'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '82457126'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '83549515'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '83555383'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '83557116'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '83072785'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '83570565'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '83577073'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '83604462'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '83593885'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '83597032'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '83595999'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '83597365'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '83629785'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '83592586'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '84684036'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '86959144'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '89159727'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '90951306'
update archive13F set
compid = '160357',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004515'
where entryId = '93843258'
End Function
The Script is complete, exiting....