clear
set safety off
s = seconds()
*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for K-Line Electric Trains
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%K_LINE%" ;
                                                             ;
order by part_no ;
save to "data\temp_pkline"
 
*/
*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for LGB Trains
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LGB%" ;
                                                             ;
order by part_no ;
save to "data\temp_pllgb"
 
*/
*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Mike's Train House
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%MIKE%" ;
                                                             ;
order by part_no ;
save to "data\temp_pmth"
 
*/
*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Weaver Trains
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%WEAVER%" ;
                                                             ;
order by part_no ;
save to "data\temp_plwe"
 
*/
*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Williams Trains
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%WILLIAMS%" ;
                                                             ;
order by part_no ;
save to "data\temp_plwi"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for American Flyer Pre War (1906-1946)
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%AMERICAN%" ;
                                                             ;
order by part_no ;
save to "data\temp_pgafpre"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for American Flyer S Gauge (1946-1966)
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%AMERICAN%" ;
                                                             ;
order by part_no ;
save to "data\temp_pgafs"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for American Flyer Modern (1979-Current)
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%AMERICAN%" ;
                                                             ;
order by part_no ;
save to "data\temp_pgafmpcn"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for American Flyer Paper
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%AMERICAN%" ;
                                                             ;
order by part_no ;
save to "data\temp_pgafpap"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Marx Joy Line
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%MARX%" ;
                                                             ;
order by part_no ;
save to "data\temp_plmxjl"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Marx Engines
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%MARX%" ;
                                                             ;
order by part_no ;
save to "data\temp_plmxen"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Marx Passenger Cars
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%MARX%" ;
                                                             ;
order by part_no ;
save to "data\temp_plmxpa"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Marx 4 Wheel Rolling Stock
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%MARX%" ;
                                                             ;
order by part_no ;
save to "data\temp_plmxrsf"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Marx 8 Wheel Rolling Stock
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%MARX%" ;
                                                             ;
order by part_no ;
save to "data\temp_plmxrse"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Marx Accessories
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%MARX%" ;
                                                             ;
order by part_no ;
save to "data\temp_plmxac"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Marx Track & Supplies
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%MARX%" ;
                                                             ;
order by part_no ;
save to "data\temp_plmxts"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Marx Transformers
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%MARX%" ;
                                                             ;
order by part_no ;
save to "data\temp_plmxtr"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Marx Sets
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%MARX%" ;
                                                             ;
order by part_no ;
save to "data\temp_plmxst"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Marx HO Gauge
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%MARX%" ;
                                                             ;
order by part_no ;
save to "data\temp_plmxho"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Lionel Pre-War Standard Gauge
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LIONEL%" ;
                                                             ;
order by part_no ;
save to "data\temp_pllist"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Lionel Pre-War O Gauge
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LIONEL%" ;
                                                             ;
order by part_no ;
save to "data\temp_plpreo"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Lionel Post War Trains(1945-1969)
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LIONEL%" ;
                                                             ;
order by part_no ;
save to "data\temp_lionel_pos"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Lionel Accessories Post War
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LIONEL%" ;
                                                             ;
order by part_no ;
save to "data\temp_plliacp"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Lionel Diesel Engines
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LIONEL%" ;
                                                             ;
order by part_no ;
save to "data\temp_pllipwd"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Lionel Electric Locos
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LIONEL%" ;
                                                             ;
order by part_no ;
save to "data\temp_pllielp"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Lionel Motorized Units
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LIONEL%" ;
                                                             ;
order by part_no ;
save to "data\temp_pllimzp"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Lionel Steam Locomotives
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LIONEL%" ;
                                                             ;
order by part_no ;
save to "data\temp_pllipws"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Lonel Passenger Cars
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LIONEL%" ;
                                                             ;
order by part_no ;
save to "data\temp_pllipcp"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Lionel Rolling Stock
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LIONEL%" ;
                                                             ;
order by part_no ;
save to "data\temp_pllirsp"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Lionel Sets Post War
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LIONEL%" ;
                                                             ;
order by part_no ;
save to "data\temp_pllistp"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Lionel HO Gauge
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LIONEL%" ;
                                                             ;
order by part_no ;
save to "data\temp_lionel_ho"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Lionel Modern (1970 - Present)
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LIONEL%" ;
                                                             ;
order by part_no ;
save to "data\temp_lionel_mod"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Lionel Accessories Modern
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LIONEL%" ;
                                                             ;
order by part_no ;
save to "data\temp_plliacm"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Lionel Engines Modern Diesel
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LIONEL%" ;
                                                             ;
order by part_no ;
save to "data\temp_plliem"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Lionel Electric Locos
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LIONEL%" ;
                                                             ;
order by part_no ;
save to "data\temp_pllielm"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Lionel Motorized Units MPC
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LIONEL%" ;
                                                             ;
order by part_no ;
save to "data\temp_pllimzm"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Lionel Steam Engines (1901-19420
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LIONEL%" ;
                                                             ;
order by part_no ;
save to "data\temp_plliems"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Lionel Modern Passenger Cars
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LIONEL%" ;
                                                             ;
order by part_no ;
save to "data\temp_pllipcm"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Lionel Modern Rolling Stock
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LIONEL%" ;
                                                             ;
order by part_no ;
save to "data\temp_pllirsm"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Lionel Sets Modern
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LIONEL%" ;
                                                             ;
order by part_no ;
save to "data\temp_pllistm"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Lionel O Gauge Classics
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LIONEL%" ;
                                                             ;
order by part_no ;
save to "data\temp_plliocl"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Lionel Standard Gauge Classics
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LIONEL%" ;
                                                             ;
order by part_no ;
save to "data\temp_pllistcl"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Lionel Paper
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LIONEL%" ;
                                                             ;
order by part_no ;
save to "data\temp_plipap"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Lionel Track & Supplies
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LIONEL%" ;
                                                             ;
order by part_no ;
save to "data\temp_pllits"
 
*/
/*    Remove the leading / to uncomment this SQL statement
 
 // Create temp_table for Lionel Transformers
 
select part_no,title,grade,cast(extract(year from sdate) as int) yr,;
cast(asell as int) asell1 from 'data\master' ;
where asell > 0 and upper(mfg) like "%LIONEL%" ;
                                                             ;
order by part_no ;
save to "data\temp_pllitr"
 
*/
set safety on
? "Seconds", seconds() - s