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: : 168392
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168392'
The Shares Amount is 0
The cusip is 08179B202
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '08179B202'
Number of Rows :0
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '08179B202'
Number of Rows :65
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '99330922'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '99525273'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '99253551'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '99382329'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '99476773'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '99663600'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '99759853'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '99814620'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '100418245'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '100471844'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '100422576'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '100171217'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '103055260'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '102439734'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '101210788'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '102383535'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '102136226'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '102316332'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '102069563'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '102180225'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '102432648'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '102756350'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '102804476'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '103079422'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '103116701'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '104114899'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '104047757'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '104441260'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '104444379'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '104560502'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '104924389'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '105003250'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '105172634'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '105213836'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '105302106'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '105524863'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '105621972'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '107225345'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '106378470'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '106446523'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '107225626'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '107371076'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '107837295'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '108075296'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '108212634'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '108251449'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '107453562'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '108100481'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '108105319'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '110049813'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '110257317'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '109111344'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '109150803'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '109673540'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '113357001'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '112043797'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '111921674'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '113431190'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '114878334'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '114772985'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '114570270'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '114948084'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '117374592'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '116747253'
update archive13F set
compid = '168392',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001828735'
where entryId = '118611352'
End Function
The Script is complete, exiting....