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: : 168748
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168748'
The Shares Amount is 43180000
The cusip is 20460L104
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '20460L104'
Number of Rows :26
update current13Fpositions set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987' ,
percentOut = '833.61'
where entryId = '132023914'
update current13Fpositions set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987' ,
percentOut = '0.01'
where entryId = '130755460'
update current13Fpositions set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987' ,
percentOut = '0.02'
where entryId = '131973929'
update current13Fpositions set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987' ,
percentOut = '44.58'
where entryId = '132106117'
update current13Fpositions set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987' ,
percentOut = '0.05'
where entryId = '131707737'
update current13Fpositions set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987' ,
percentOut = '0'
where entryId = '130470029'
update current13Fpositions set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987' ,
percentOut = '0.05'
where entryId = '130794316'
update current13Fpositions set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987' ,
percentOut = '12.16'
where entryId = '131174224'
update current13Fpositions set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987' ,
percentOut = '4.63'
where entryId = '132328439'
update current13Fpositions set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987' ,
percentOut = '2.98'
where entryId = '132240780'
update current13Fpositions set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987' ,
percentOut = '4.72'
where entryId = '132220946'
update current13Fpositions set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987' ,
percentOut = '2.54'
where entryId = '130049497'
update current13Fpositions set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987' ,
percentOut = '2.32'
where entryId = '132214328'
update current13Fpositions set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987' ,
percentOut = '13.14'
where entryId = '132115530'
update current13Fpositions set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987' ,
percentOut = '84.95'
where entryId = '131073857'
update current13Fpositions set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987' ,
percentOut = '13.9'
where entryId = '131793478'
update current13Fpositions set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987' ,
percentOut = '14.47'
where entryId = '125683350'
update current13Fpositions set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987' ,
percentOut = '0.01'
where entryId = '131288202'
update current13Fpositions set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987' ,
percentOut = '1024.43'
where entryId = '131824123'
update current13Fpositions set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987' ,
percentOut = '0'
where entryId = '132546590'
update current13Fpositions set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987' ,
percentOut = '0'
where entryId = '132590763'
update current13Fpositions set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987' ,
percentOut = '559.81'
where entryId = '132104705'
update current13Fpositions set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987' ,
percentOut = '1143.23'
where entryId = '130485993'
update current13Fpositions set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987' ,
percentOut = '40.9'
where entryId = '132380684'
update current13Fpositions set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987' ,
percentOut = '0.74'
where entryId = '132392354'
update current13Fpositions set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987' ,
percentOut = '40.9'
where entryId = '132411729'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '20460L104'
Number of Rows :49
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '124674072'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '125460367'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '125033653'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '125532394'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '125703931'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '125777462'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '125805345'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '125855122'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '126007314'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '126053721'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '126123034'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '126124653'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '126135136'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '126299727'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '126309574'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '126336648'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '126349549'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '126434098'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '126499526'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '126502216'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '126581931'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '126952488'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '127512811'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '127859077'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '127822153'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '129822512'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '128301978'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '128406110'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '129748019'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '128668109'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '129318053'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '129586375'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '128784807'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '129811798'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '128833142'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '129067966'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '129392602'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '129112626'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '129184882'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '128114509'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '129514956'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '129197269'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '129740882'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '129695917'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '128382407'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '129289640'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '129296147'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '129693968'
update archive13F set
compid = '168748',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001838987'
where entryId = '129179355'
End Function
The Script is complete, exiting....