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: : 151984
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '151984'
The Shares Amount is 1580000000
The cusip is 55315J102
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '55315J102'
Number of Rows :9
update current13Fpositions set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414' ,
percentOut = '0'
where entryId = '130010268'
update current13Fpositions set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414' ,
percentOut = '0.19'
where entryId = '131089383'
update current13Fpositions set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414' ,
percentOut = '0.49'
where entryId = '99366065'
update current13Fpositions set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414' ,
percentOut = '0.35'
where entryId = '132225972'
update current13Fpositions set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414' ,
percentOut = '0.23'
where entryId = '131061172'
update current13Fpositions set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414' ,
percentOut = '0.2'
where entryId = '118678011'
update current13Fpositions set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414' ,
percentOut = '0'
where entryId = '123599555'
update current13Fpositions set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414' ,
percentOut = '0'
where entryId = '132483284'
update current13Fpositions set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414' ,
percentOut = '0'
where entryId = '132490693'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '55315J102'
Number of Rows :318
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '67143706'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '68238098'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '68355572'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '66747529'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '67503353'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '67212813'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '67754629'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '67277687'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '67282491'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '66754196'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '66586653'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '66523507'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '67086312'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '66836400'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '67520505'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '66626240'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '65452288'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '65146369'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '65294656'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '65176892'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '65872552'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '65516012'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '65916634'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '65163619'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '65981960'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '63447436'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '63525818'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '63497783'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '63600777'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '63610623'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '63575776'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '63420108'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '63598391'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '64978678'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '64975285'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '64800569'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '64702950'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '64868659'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '68542488'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '69999694'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '68620097'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '68551039'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '68827233'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '69587201'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '69825287'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '69345407'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '69865102'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '69949290'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '69964485'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '70326696'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '70099017'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '70838105'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '70460424'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '70112942'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '70576910'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '71739209'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '71116046'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '71165644'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '71164986'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '70908536'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '71155562'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '72328947'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '72074373'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '72177744'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '72320726'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '72227022'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '72095693'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '72550112'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '73340012'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '73340217'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '73156247'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '73310681'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '73784402'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '74762999'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '74055599'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '73957906'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '74434295'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '74264978'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '74338840'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '74493483'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '75049249'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '75049055'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '74881464'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '75046193'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '75886417'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '75999020'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '76322792'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '76724206'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '76573033'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '76394956'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '75752177'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '76974311'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '77047718'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '77033497'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '76813771'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '78588508'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '77751053'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '78056081'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '78202882'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '78436768'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '78312185'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '77943098'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '78837174'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '78845849'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '79592143'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '79554857'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '80778389'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '79860207'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '79806220'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '80144519'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '80362103'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '79707613'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '80200170'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '80289559'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '81171883'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '80029994'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '81003013'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '81185635'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '81185813'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '81820831'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '81896366'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '81721168'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '81916163'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '81995560'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '82122960'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '83201423'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '83201561'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '82087578'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '82524019'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '81960776'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '82234207'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '82618745'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '83101363'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '83738195'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '83804456'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '83950716'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '83758759'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '83889023'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '83943593'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '84168367'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '84356578'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '84458346'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '84032826'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '84033001'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '84652944'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '85516114'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '84850082'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '83945019'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '85278882'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '85466172'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '85761078'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '85843138'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '87678335'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '87721027'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '86230025'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '86608877'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '85931498'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '86040279'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '86648065'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '87178474'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '87178646'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '85918893'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '86366241'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '86921296'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '86836947'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '87180723'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '85988836'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '87763816'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '87764701'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '87773345'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '87798866'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '88055302'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '88048166'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '88008770'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '88255266'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '89688903'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '87981394'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '88471533'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '87911276'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '88008944'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '89274356'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '89846919'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '88572190'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '88108097'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '89873389'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '89931370'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '91944519'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '90059184'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '90237931'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '90803543'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '90342119'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '91143463'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '90379313'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '91087061'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '90841526'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '91824626'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '90616830'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '91829464'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '91146028'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '90410207'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '92116712'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '92087295'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '92059251'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '92005336'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '92195401'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '92168123'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '92570969'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '92244305'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '92244515'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '93978822'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '93731562'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '93277694'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '93799674'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '93865358'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '94019499'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '94115277'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '94222624'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '94373702'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '94460183'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '94460397'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '95167547'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '93826627'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '94213233'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '94476111'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '94894803'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '95414080'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '96556891'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '96592574'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '96376435'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '96637229'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '96560574'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '96935898'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '96257799'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '96258057'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '97064652'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '97413708'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '96892735'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '97828879'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '98413207'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '98788140'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '98494910'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '98563589'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '98902271'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '99366237'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '99539095'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '99918647'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '100307520'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '100268725'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '100818061'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '100707511'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '101139043'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '101049315'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '101231805'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '101252931'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '101774895'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '102401674'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '102387561'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '101981167'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '103198050'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '102984477'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '103250165'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '103293115'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '103458474'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '103386553'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '104634565'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '103764404'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '103780930'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '104813088'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '104336706'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '104814150'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '105695286'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '105818000'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '106039697'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '106981690'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '106101477'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '106359960'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '106998784'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '107622297'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '108461632'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '108481769'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '108585867'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '109984580'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '105735644'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '109418500'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '109268069'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '108773393'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '112525630'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '110956076'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '111313269'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '112750702'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '112064744'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '112186404'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '113626165'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '114087281'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '113559846'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '114425535'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '114410303'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '115323383'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '116582083'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '117930585'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '117368641'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '117809566'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '119139162'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '121000955'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '120857737'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '122139314'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '122770147'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '123507109'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '121989992'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '126868573'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '125129056'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '124524672'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '126790987'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '126632555'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '128097024'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '128087142'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '129610762'
update archive13F set
compid = '151984',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '9000000414'
where entryId = '129618319'
End Function
The Script is complete, exiting....