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: : 160383
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '160383'
The Shares Amount is 1330000
The cusip is 06740L477
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '06740L477'
Number of Rows :2
update current13Fpositions set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541' ,
percentOut = '16.37'
where entryId = '51208158'
update current13Fpositions set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541' ,
percentOut = '48.57'
where entryId = '69269473'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '06740L477'
Number of Rows :85
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '66035270'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '67817606'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '68054109'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '67700038'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '67870646'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '65491632'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '68023817'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '68367837'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '66364229'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '66586111'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '66284273'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '66319946'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '66095120'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '64007117'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '64267768'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '64590867'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '64631600'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '64333668'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '64649061'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '69799549'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '69613433'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '70044156'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '69557172'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '69590688'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '69966931'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '69374721'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '71401993'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '71677399'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '71805605'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '71187449'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '71404879'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '70994226'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '73425643'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '73644220'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '73598974'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '73322030'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '73749426'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '73454967'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '75248007'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '75511293'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '75456006'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '75637033'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '75669577'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '77629439'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '77480204'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '77380264'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '77295875'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '78668418'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '79539466'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '79291561'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '79517809'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '80991211'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '81014936'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '81379958'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '81596822'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '83051826'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '83069376'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '83439201'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '83614103'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '84640955'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '84680492'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '85301865'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '85556368'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '86907980'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '86668168'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '86955477'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '87681299'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '89282394'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '88560280'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '89155890'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '90161440'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '90910167'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '90947285'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '91645747'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '92650668'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '92231905'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '93146468'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '93921165'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '51036477'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '95588952'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '94755506'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '95246380'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '95999296'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '96632032'
update archive13F set
compid = '160383',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004541'
where entryId = '97582685'
End Function
The Script is complete, exiting....