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: : 160364
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '160364'
The Shares Amount is 5050000
The cusip is 92189H706
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '92189H706'
Number of Rows :0
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '92189H706'
Number of Rows :105
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '90330241'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '92186835'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '93103704'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '93905812'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '93248868'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '93715959'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '92684845'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '92242315'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '93153764'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '93206388'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '93634192'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '93074856'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '93313923'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '93320177'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '93609972'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '93926045'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '94394531'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '95279447'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '94436745'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '95244809'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '94803425'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '94873053'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '95156148'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '95509219'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '95734736'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '95337293'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '95632761'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '95728196'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '95871012'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '95916007'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '95968613'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '94727827'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '96646748'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '96228358'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '96711985'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '96843254'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '96889206'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '96966689'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '97346603'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '97598690'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '97704688'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '97806356'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '98043951'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '98067003'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '98384011'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '98603015'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '99445411'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '99339316'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '99261759'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '99393471'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '103194581'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '103193219'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '103192117'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '99203715'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '99883563'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '100191296'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '100295917'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '100520684'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '100550472'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '101128021'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '103196054'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '101190478'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '101443919'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '101617553'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '101021169'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '102144951'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '101911729'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '102191592'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '102344561'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '102476114'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '102629347'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '102853214'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '103104448'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '103225109'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '102918489'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '103707258'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '103740056'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '103911842'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '103721389'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '104056795'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '105378878'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '104212087'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '105483353'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '104949517'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '105017330'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '105053909'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '105479884'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '105284944'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '105350349'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '105605390'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '103509768'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '105932763'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '106377195'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '106098486'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '107207619'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '107213327'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '108082390'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '108134556'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '107249357'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '108086287'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '108087698'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '108067612'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '108120466'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '108244289'
update archive13F set
compid = '160364',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004522'
where entryId = '108336485'
End Function
The Script is complete, exiting....