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: : 168355
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168355'
The Shares Amount is 26320000
The cusip is 89680M101
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '89680M101'
Number of Rows :29
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0.04'
where entryId = '130614077'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '10.8'
where entryId = '132124211'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '3.8'
where entryId = '130415243'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0'
where entryId = '132543278'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '5.91'
where entryId = '130332822'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0.59'
where entryId = '132243814'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '5.06'
where entryId = '131561798'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0.11'
where entryId = '131745460'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0.5'
where entryId = '130806505'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0'
where entryId = '132613379'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0.25'
where entryId = '130646514'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '20.7'
where entryId = '131494480'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0.15'
where entryId = '131719572'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '4.01'
where entryId = '130776116'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '13.28'
where entryId = '132047312'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '16.95'
where entryId = '130637241'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0'
where entryId = '131794341'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0'
where entryId = '130478115'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '16.02'
where entryId = '131046710'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0'
where entryId = '132629046'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0.25'
where entryId = '130625795'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '120.04'
where entryId = '132252204'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '6.72'
where entryId = '132130242'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0.82'
where entryId = '132009386'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '63.51'
where entryId = '131084582'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '9.28'
where entryId = '131105882'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '0'
where entryId = '132234948'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '50.95'
where entryId = '132109212'
update current13Fpositions set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667' ,
percentOut = '2.09'
where entryId = '132395706'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '89680M101'
Number of Rows :30
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '124604186'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '126152892'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '125472929'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '125044753'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '124386482'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '125629689'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '125805957'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '126051142'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '126127846'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '128177601'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '127728333'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '129379071'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '128260760'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '127867246'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '127116533'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '127834598'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '128969462'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '129833358'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '129100806'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '128195368'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '129316219'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '127789469'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '129193652'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '129147115'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '128599549'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '129200399'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '127453869'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '127981369'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '128785504'
update archive13F set
compid = '168355',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001826667'
where entryId = '129334175'
End Function
The Script is complete, exiting....