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: : 167103
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '167103'
The Shares Amount is 4260000
The cusip is G4086B115
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = 'G4086B115'
Number of Rows :0
End Function
Retrive Rows from Table:
select * from archive13F where cusip = 'G4086B115'
Number of Rows :80
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '95274775'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '95023646'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '94459796'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '94800926'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '94866225'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '95034367'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '95485242'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '95875340'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '95386437'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '95476948'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '95812356'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '95813199'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '98129090'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '96223487'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '97573541'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '96882301'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '97145283'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '97256034'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '97612604'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '97836707'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '98247626'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '97620826'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '98164744'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '98165476'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '97996545'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '99149689'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '99256483'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '99386223'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '100116467'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '99616032'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '99759968'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '100467647'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '100474273'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '102285357'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '102345322'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '102139343'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '102316559'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '102184199'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '102624491'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '102798828'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '102811684'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '104051003'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '104804530'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '104514598'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '104777546'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '105008141'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '105049074'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '105295050'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '105309223'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '106449955'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '107228635'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '108117547'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '107459134'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '107515030'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '107822909'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '110539137'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '110262674'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '109114886'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '110320464'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '112777639'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '111925266'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '112375907'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '112985539'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '114881892'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '115621393'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '115099809'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '118408187'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '117147391'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '118500758'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '116885851'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '116497172'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '118595335'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '120604109'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '120313849'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '120624876'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '120708963'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '120492967'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '123258245'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '123945060'
update archive13F set
compid = '167103',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001768910'
where entryId = '123248713'
End Function
The Script is complete, exiting....