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: : 168475
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168475'
The Shares Amount is 0
The cusip is G3194F125
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = 'G3194F125'
Number of Rows :0
End Function
Retrive Rows from Table:
select * from archive13F where cusip = 'G3194F125'
Number of Rows :110
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '99719204'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '98781739'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '99050850'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '99562351'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '99994984'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '99097949'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '99525309'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '99796038'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '100457413'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '99255404'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '99384946'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '99425035'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '99476960'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '99663723'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '99759928'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '99814717'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '99891271'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '99893145'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '100587344'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '100290277'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '100318186'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '100359715'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '100394516'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '100395788'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '100399573'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '100419113'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '100438070'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '100467612'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '100486800'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '100493821'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '100522215'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '100534923'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '100543802'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '99917072'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '103534715'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '98811129'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '103959420'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '100600305'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '101123512'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '101507369'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '101457774'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '102345284'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '102445701'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '102383650'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '101924106'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '102138192'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '102316491'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '101935985'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '102431233'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '102445519'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '101572569'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '102061749'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '101709825'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '101907588'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '102182893'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '102226104'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '102416574'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '102983030'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '102985435'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '102990298'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '102734584'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '102736123'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '102744354'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '102757336'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '103001221'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '102798792'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '103008366'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '102854811'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '103007276'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '102906360'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '103012122'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '103062851'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '101307715'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '103481586'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '103678116'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '100905518'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '103926909'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '103961901'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '104049806'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '104804552'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '104792943'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '105118757'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '105502594'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '104821040'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '104536302'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '104807854'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '104795367'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '105006616'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '105048206'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '105476181'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '105500317'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '105505785'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '105470486'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '105295016'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '105513626'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '105515894'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '105482372'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '105633686'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '105757939'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '105500583'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '106097551'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '105761093'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '106377066'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '106366089'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '107213321'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '108074552'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '107246006'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '108085897'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '108087675'
update archive13F set
compid = '168475',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832505'
where entryId = '108115960'
End Function
The Script is complete, exiting....