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: : 145517
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '145517'
The Shares Amount is 28723000
The cusip is 020936100
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '020936100'
Number of Rows :4
update current13Fpositions set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '' ,
percentOut = '0.35'
where entryId = '78504052'
update current13Fpositions set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '' ,
percentOut = '0.04'
where entryId = '129838754'
update current13Fpositions set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '' ,
percentOut = '0'
where entryId = '132577008'
update current13Fpositions set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '' ,
percentOut = '0'
where entryId = '130733314'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '020936100'
Number of Rows :82
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '67526064'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '65081112'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '67019590'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '65660002'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '65984801'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '67695966'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '67053383'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '68522186'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '65370274'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '65283856'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '63476301'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '63465904'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '64880234'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '64024025'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '68523143'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '68486556'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '68713820'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '68891023'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '69108633'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '71668695'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '70510410'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '70138929'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '70427315'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '72446430'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '72175058'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '73111623'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '73959090'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '74754023'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '76612170'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '77471078'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '77828475'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '79816571'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '81721731'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '83632896'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '83765494'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '85295827'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '85966345'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '86606577'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '87680190'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '87890355'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '87941600'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '89437469'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '90813070'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '90333286'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '90265671'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '91787295'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '93779969'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '93510276'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '92567976'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '94332972'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '94370552'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '96070470'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '96557286'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '98784660'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '100814463'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '98732232'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '103534788'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '102398969'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '102643070'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '103291348'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '104813060'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '105628626'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '106798196'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '110103945'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '112620209'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '114722399'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '116680137'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '120270563'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '120272672'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '119570062'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '120540821'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '120265429'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '123893278'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '123905391'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '123674580'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '124101051'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '125285510'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '126805329'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '126571981'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '126934271'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '127702349'
update archive13F set
compid = '145517',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '129579523'
End Function
The Script is complete, exiting....