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: : 160389
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '160389'
The Shares Amount is 36690000
The cusip is 22542D290
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '22542D290'
Number of Rows :2
update current13Fpositions set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547' ,
percentOut = '17.47'
where entryId = '97978384'
update current13Fpositions set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547' ,
percentOut = '0.13'
where entryId = '89553488'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '22542D290'
Number of Rows :181
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '79832001'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '79842361'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '79909852'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '80072659'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '80850817'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '80851026'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '81097169'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '81128972'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '81363279'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '81588313'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '80553027'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '80803934'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '81015915'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '81038491'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '81333329'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '81345732'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '81380156'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '81921075'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '81597166'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '81725753'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '81759453'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '81726824'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '82695632'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '82736104'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '83529826'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '83559413'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '82941620'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '83545630'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '82970881'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '83070382'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '83094750'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '83570670'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '83205004'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '83604789'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '83391354'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '83396467'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '83439402'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '83614535'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '83592339'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '83778212'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '85270807'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '84681539'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '84736539'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '85494409'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '84861531'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '85521604'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '85229537'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '85540760'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '85240383'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '85302032'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '85366456'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '85405375'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '85654613'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '85272362'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '85768964'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '86254041'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '86740572'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '86220002'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '86655338'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '87737033'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '85970706'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '87198315'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '87673477'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '87516295'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '87642510'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '87688909'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '86956566'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '86995894'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '87012066'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '87152370'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '87446027'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '87459409'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '87682206'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '87776357'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '87933046'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '89283956'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '88086823'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '88437848'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '88558814'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '89765929'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '88955663'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '89043922'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '89081749'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '89157062'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '89192400'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '89333093'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '89441969'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '89539524'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '89547126'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '89547649'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '89655189'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '89717985'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '90353831'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '90649943'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '90662393'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '90338885'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '90568912'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '90645931'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '91544061'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '89994584'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '91387915'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '91494938'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '90948559'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '91500177'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '91518577'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '91803056'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '91875712'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '91019658'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '91490256'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '91208933'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '91607113'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '91907466'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '91646214'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '93549775'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '92568892'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '92265123'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '93967927'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '92548251'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '92996530'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '93674100'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '93703363'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '93870637'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '93075980'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '92233452'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '92790541'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '93019645'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '93147594'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '93877151'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '93541606'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '93872833'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '93460070'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '93485004'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '93528553'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '93535187'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '93540684'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '93558730'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '93874998'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '93921817'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '94001580'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '92526135'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '94404319'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '95230436'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '94411887'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '94371521'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '95589010'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '94729827'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '95246377'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '95224107'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '95218939'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '95241595'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '95180128'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '95583902'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '95587839'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '95475663'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '96001534'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '95985762'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '95999192'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '95980419'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '95982075'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '95986353'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '95988174'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '96026244'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '95985045'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '96558295'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '97600095'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '98148989'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '98785733'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '100815569'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '103290685'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '104529224'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '106648493'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '109997958'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '111620747'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '115955243'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '125143683'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '125144778'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '125145859'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '125146923'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '125147979'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '125149020'
update archive13F set
compid = '160389',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004547'
where entryId = '125362621'
End Function
The Script is complete, exiting....