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: : 131010
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '131010'
The Shares Amount is 30554000
The cusip is 74973W107
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '74973W107'
Number of Rows :155
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '4.32'
where entryId = '1265351'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '7.49'
where entryId = '2828100'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '9.1'
where entryId = '3733234'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '21.57'
where entryId = '5780947'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '48.6'
where entryId = '9329149'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '13.33'
where entryId = '9342209'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0.77'
where entryId = '9756764'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '1.64'
where entryId = '10023540'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '125.54'
where entryId = '10246912'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0'
where entryId = '10547172'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '6.25'
where entryId = '10835313'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0'
where entryId = '10874108'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '1.64'
where entryId = '10984495'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '1.15'
where entryId = '11077479'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '18.69'
where entryId = '11103586'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '1.18'
where entryId = '11195117'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '32.73'
where entryId = '11208781'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '16345.16'
where entryId = '11217633'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '1.01'
where entryId = '11225937'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '3.31'
where entryId = '11271728'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '11.91'
where entryId = '11369436'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '3.59'
where entryId = '11450096'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '14.49'
where entryId = '11894097'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0.99'
where entryId = '12170785'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '26.64'
where entryId = '12228754'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '7.69'
where entryId = '12288495'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '1.11'
where entryId = '12301230'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0'
where entryId = '12327406'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0.02'
where entryId = '12424380'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0.98'
where entryId = '12449077'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0'
where entryId = '12562130'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '5.2'
where entryId = '12627131'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '221.89'
where entryId = '12811342'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '12.75'
where entryId = '12924731'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '14.73'
where entryId = '12926767'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '81.82'
where entryId = '12969676'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '75.55'
where entryId = '13021021'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '1.7'
where entryId = '13451422'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '3.31'
where entryId = '13455035'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0.17'
where entryId = '13468785'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '11.78'
where entryId = '13644376'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '2.13'
where entryId = '13647904'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0'
where entryId = '13678708'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0'
where entryId = '13818458'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '6.57'
where entryId = '13825715'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '6.57'
where entryId = '13871326'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0.66'
where entryId = '13900431'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0.98'
where entryId = '13928681'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '398.35'
where entryId = '14052557'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '225.63'
where entryId = '14218941'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '2.72'
where entryId = '14333086'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '28.1'
where entryId = '14581446'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '1.56'
where entryId = '14601287'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '736.4'
where entryId = '14629274'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0.17'
where entryId = '14661803'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '75.65'
where entryId = '14676846'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0'
where entryId = '14826443'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '36.24'
where entryId = '14877553'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '14.6'
where entryId = '15070466'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '1.61'
where entryId = '15199041'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '2.13'
where entryId = '15216323'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0'
where entryId = '15262495'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '17.67'
where entryId = '15323029'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '3.85'
where entryId = '15450484'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '419.16'
where entryId = '15787055'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0.52'
where entryId = '15803368'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '224.87'
where entryId = '16000592'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '3.28'
where entryId = '16028026'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '11.34'
where entryId = '16104029'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0.06'
where entryId = '16118000'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '74.9'
where entryId = '16192568'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0'
where entryId = '16287899'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0'
where entryId = '16615849'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '1.54'
where entryId = '16673161'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0.52'
where entryId = '16727139'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '1.54'
where entryId = '16800201'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '3.8'
where entryId = '16835657'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0'
where entryId = '16955324'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '14.3'
where entryId = '17005518'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0.6'
where entryId = '17016205'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '126.43'
where entryId = '17022252'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0.07'
where entryId = '17051776'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0'
where entryId = '17105275'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '86.45'
where entryId = '17191379'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '32.47'
where entryId = '17205175'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '3.28'
where entryId = '17447137'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '66.9'
where entryId = '17458859'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '2.12'
where entryId = '17468673'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '17.04'
where entryId = '17527632'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0.06'
where entryId = '17541276'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '5.6'
where entryId = '17560671'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0'
where entryId = '17674648'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0.13'
where entryId = '18252890'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0'
where entryId = '18274280'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '3.96'
where entryId = '18298822'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0.17'
where entryId = '18356191'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '2.51'
where entryId = '18572913'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '31.91'
where entryId = '18625537'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0'
where entryId = '18659093'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '84.81'
where entryId = '18695746'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0'
where entryId = '18825897'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '17.04'
where entryId = '18833921'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0'
where entryId = '19027111'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '7'
where entryId = '19078650'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '13.34'
where entryId = '19092671'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '3.99'
where entryId = '19116214'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '9.01'
where entryId = '20168839'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '7'
where entryId = '21940869'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '2.98'
where entryId = '23176899'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0.85'
where entryId = '24138771'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0'
where entryId = '24522194'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0'
where entryId = '24911433'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0'
where entryId = '24929095'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0'
where entryId = '29689212'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '4.18'
where entryId = '31800093'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '3.39'
where entryId = '32167282'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '6.73'
where entryId = '32908524'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '664.93'
where entryId = '36283457'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0.24'
where entryId = '36745043'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '2.45'
where entryId = '38324992'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '22.92'
where entryId = '40851348'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '4.74'
where entryId = '41652112'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '2.87'
where entryId = '41675336'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '2.3'
where entryId = '42065226'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '19.35'
where entryId = '42083647'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '17.87'
where entryId = '42107113'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '2.48'
where entryId = '42115230'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '4.97'
where entryId = '42138093'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '3.88'
where entryId = '42144567'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '6.79'
where entryId = '42146791'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '1.92'
where entryId = '42158749'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0.01'
where entryId = '42169629'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '3.8'
where entryId = '42170014'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '7.59'
where entryId = '42175061'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0.16'
where entryId = '42181961'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '8.18'
where entryId = '42186014'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0.03'
where entryId = '42193133'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0'
where entryId = '42202195'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '139.35'
where entryId = '42215710'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '3.37'
where entryId = '42222295'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '8.25'
where entryId = '42225623'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0.13'
where entryId = '42230464'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '1067.84'
where entryId = '42231402'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0.34'
where entryId = '43979119'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '1.37'
where entryId = '44020560'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '8.97'
where entryId = '46539989'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '6.32'
where entryId = '47281193'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '98.19'
where entryId = '48062352'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0'
where entryId = '50907838'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '11.67'
where entryId = '51215934'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '13.09'
where entryId = '51524628'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '36.26'
where entryId = '56366408'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0'
where entryId = '57363179'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0'
where entryId = '58106232'
update current13Fpositions set
compid = '131010',
sectorNum = '703004',
sectorDes = 'Industrial Metals & Minerals',
issuerCik = '0001068717' ,
percentOut = '0'
where entryId = '58400291'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '74973W107'
Number of Rows :0
End Function
The Script is complete, exiting....