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: : 130599
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130599'
The Shares Amount is 8400000
The cusip is 46261V306
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '46261V306'
Number of Rows :0
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '46261V306'
Number of Rows :55
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '77807106'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '78330082'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '79273619'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '78369666'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '77878580'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '78939029'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '79140131'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '79427134'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '78538452'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '78662023'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '78671737'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '78818534'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '79033679'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '79233944'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '79122537'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '79653129'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '79587089'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '79773324'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '80558050'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '80045823'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '80285703'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '80426583'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '80903782'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '80630167'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '80972313'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '81342323'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '81364516'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '81471311'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '81656495'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '81010228'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '81018278'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '81502247'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '81551115'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '81245212'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '81334635'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '81494796'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '81610743'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '81839310'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '82166347'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '82468823'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '83557381'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '81974456'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '82173366'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '83536781'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '83555055'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '83555415'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '83569951'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '83072825'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '83583201'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '83592048'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '84684093'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '86959202'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '89159785'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '90951365'
update archive13F set
compid = '130599',
sectorNum = '604003',
sectorDes = 'Internet Software & Services',
issuerCik = '0001053374'
where entryId = '93843121'
End Function
The Script is complete, exiting....