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: : 167072
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '167072'
The Shares Amount is 14380000
The cusip is 69375F207
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '69375F207'
Number of Rows :0
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '69375F207'
Number of Rows :84
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '95277929'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '95023490'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '94459891'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '94514084'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '94649553'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '94870800'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '95034464'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '95474120'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '95486135'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '95789904'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '95875620'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '94824450'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '95386535'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '95476389'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '95531955'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '95812602'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '95813533'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '95816545'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '95823218'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '95860525'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '95939105'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '95959791'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '95478348'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '97574743'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '96226747'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '96870514'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '96886883'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '97076538'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '97256119'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '97277133'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '97579358'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '97612449'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '98138991'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '98144652'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '98247551'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '98239541'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '98469189'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '97620846'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '98166159'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '97931211'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '97932428'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '97939241'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '98172714'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '97995992'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '98000535'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '98061383'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '98118088'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '98131336'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '98149614'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '99719446'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '99562590'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '99493896'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '99796052'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '99260019'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '99391015'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '100076997'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '99477352'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '99760081'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '100098592'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '100657183'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '100637966'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '100638344'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '100639589'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '100466872'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '100477151'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '100543987'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '103961854'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '100600451'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '102439711'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '102068568'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '102077581'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '102143078'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '102189057'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '102432550'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '102797981'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '102808976'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '103012079'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '101307987'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '100986112'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '104803726'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '105475205'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '105510206'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '105511251'
update archive13F set
compid = '167072',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001797099'
where entryId = '105757885'
End Function
The Script is complete, exiting....