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: : 166930
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '166930'
The Shares Amount is 9000000
The cusip is 74347G507
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '74347G507'
Number of Rows :12
update current13Fpositions set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446' ,
percentOut = '0'
where entryId = '131567124'
update current13Fpositions set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446' ,
percentOut = '0'
where entryId = '130476304'
update current13Fpositions set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446' ,
percentOut = '0'
where entryId = '132609324'
update current13Fpositions set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446' ,
percentOut = '9.44'
where entryId = '131178259'
update current13Fpositions set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446' ,
percentOut = '0.2'
where entryId = '131239488'
update current13Fpositions set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446' ,
percentOut = '0.34'
where entryId = '111162917'
update current13Fpositions set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446' ,
percentOut = '21.74'
where entryId = '132243049'
update current13Fpositions set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446' ,
percentOut = '48.03'
where entryId = '132005469'
update current13Fpositions set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446' ,
percentOut = '0.08'
where entryId = '130608389'
update current13Fpositions set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446' ,
percentOut = '0.01'
where entryId = '131716799'
update current13Fpositions set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446' ,
percentOut = '6.38'
where entryId = '130242516'
update current13Fpositions set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446' ,
percentOut = '5.87'
where entryId = '132638456'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '74347G507'
Number of Rows :173
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '87985813'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '88046555'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '89290487'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '87944305'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '88428970'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '88835021'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '89080250'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '89172669'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '89604781'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '90012575'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '90253983'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '90169486'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '90816672'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '90706723'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '91542612'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '90971073'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '90953898'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '91518402'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '91584681'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '92080946'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '92571752'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '91471751'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '92129146'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '92125208'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '92682583'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '92239942'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '92669005'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '93018345'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '93152227'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '93629824'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '93558425'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '94374538'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '94555684'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '94583447'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '94993622'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '95277886'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '94780497'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '94870682'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '95294886'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '95504770'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '95527865'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '95886492'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '96460333'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '96425061'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '96561432'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '98212170'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '96226704'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '96419847'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '96794552'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '96886775'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '97342031'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '97381730'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '96767932'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '98008159'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '98516068'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '98789049'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '98713379'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '99991397'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '99281991'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '99672820'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '99259960'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '99390944'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '100163462'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '99850877'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '99062383'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '100477103'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '99878726'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '100819011'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '101173097'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '101440405'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '101111407'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '102143007'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '101582104'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '102872705'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '102118080'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '102188952'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '102809306'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '103220171'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '103293306'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '102153408'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '104631093'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '103908293'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '101840796'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '103067894'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '104054785'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '104082039'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '105373824'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '104589313'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '105473943'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '105014060'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '105511013'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '105925179'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '106020506'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '106325855'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '106453916'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '106471890'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '107845612'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '107179054'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '107465669'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '107883768'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '107138919'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '108528044'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '110825349'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '107203604'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '109084480'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '110632289'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '109135607'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '110588611'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '110269000'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '109118928'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '108889790'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '109680772'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '111896655'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '112443216'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '111946958'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '113364178'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '112053975'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '111929349'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '112466839'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '112558993'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '114886011'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '112357070'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '113891935'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '114334783'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '114404750'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '114767907'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '115679814'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '115830668'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '114616992'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '114755833'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '116955193'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '117135760'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '117163319'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '117368309'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '116822149'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '118579599'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '117245222'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '116781995'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '116501171'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '118783542'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '119772107'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '119908743'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '120712962'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '119177425'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '119667580'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '120326470'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '120430020'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '122460678'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '121840826'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '122478468'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '123256833'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '123781142'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '123277728'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '123811553'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '124035719'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '124498488'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '126927296'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '124467160'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '125042172'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '126292942'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '125449747'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '126338929'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '126468419'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '127197456'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '128191329'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '127865422'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '129424021'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '129287494'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '128368772'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '129320346'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '128448491'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '128484174'
update archive13F set
compid = '166930',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006446'
where entryId = '127978594'
End Function
The Script is complete, exiting....