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: : 168327
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168327'
The Shares Amount is 0
The cusip is 379582208
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '379582208'
Number of Rows :0
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '379582208'
Number of Rows :119
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '96191387'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '96285796'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '96870411'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '96882162'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '96942939'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '97152879'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '97190582'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '97277076'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '97386190'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '97836694'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '98239021'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '98469422'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '96764664'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '97283573'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '97830863'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '97868157'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '97891726'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '97930916'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '97932007'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '97939176'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '97944874'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '97967660'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '97995540'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '98002515'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '98017073'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '98046730'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '98050912'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '98063832'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '98107820'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '98118009'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '97823106'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '98514617'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '98832191'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '99331033'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100078464'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '99458770'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100130482'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100655894'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100844717'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '99256344'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '99386065'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100077133'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '99477032'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '99636230'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100093430'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100098644'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '99814743'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100159829'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100657074'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100128127'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100626674'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100630238'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100632400'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100394616'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100395896'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100411014'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100419426'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100643642'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100466266'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100474169'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100648921'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100649597'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100650563'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100546841'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100468873'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100177887'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '100464896'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '102290412'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '102067551'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '101210968'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '102383687'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '102139187'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '102184036'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '102432573'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '102734696'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '102736212'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '102998688'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '102757701'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '102797317'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '102806593'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '103075001'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '103087830'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '103121628'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '103012561'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '102449671'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '104115132'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '104050849'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '104432616'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '104795332'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '104932764'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '105007963'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '105161834'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '105505737'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '105293373'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '105305693'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '105159811'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '106842573'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '106125035'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '106449790'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '107224759'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '107379483'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '107839187'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '107458914'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '108099025'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '107821348'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '108281174'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '108735067'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '109189831'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '110537618'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '110262465'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '109114720'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '110026888'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '109676095'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '111434506'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '111802740'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '113439105'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '112777550'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '112790338'
update archive13F set
compid = '168327',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823383'
where entryId = '112776040'
End Function
The Script is complete, exiting....