cat > script <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
empsql $MSTESTDB < $MSTSRCMINOR/_msscpt2
empdbld -TESTMODE -d 2 $MSTESTDB $MSTSRCMINOR/_sp.ok2  $MSTSRCMINOR/_dt.ok2
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 755 script
cat > stdout <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
* * *     Loading into attribute 'DB':'properties'.'listing'
	value '55555'
    Loading into attribute 'DB':'properties'.'age'
	value ' 12'
    Loading into attribute 'DB':'properties'.'trans'
	value '1200'
    Loading into attribute 'DB':'properties'.'date_listed'
	value '01 Jan 86'
    Loading into attribute 'DB':'properties'.'time_listed'
	value '01 Jan 86 12:00:00'
    Loading into attribute 'DB':'properties'.'area_id'
	value '   456'
    Loading into attribute 'DB':'properties'.'price'
	value '$10000'
    Loading into attribute 'DB':'properties'.'description'
	value '!PROPERTY 1!'
    Loading into attribute 'DB':'properties'.'address'
	value 'Rhodnius Inc. 250 Bloor street East 1   '
    Loading into attribute 'DB':'prop owner'.'area_id'
	value '   456'
    Loading into attribute 'DB':'prop owner'.'trans'
	value '1200'
    Loading into attribute 'DB':'prop owner'.'time_listed'
	value '01 Jan 86 12:00:00'
    Loading into attribute 'DB':'prop owner'.'date_listed'
	value '01 Jan 86'
    Loading into attribute 'DB':'prop owner'.'prop_id'
	value '0123456789'
    Loading into attribute 'DB':'index'.'date listed'
	value ' 1 2  86'
    Loading into attribute 'DB':'index'.'select'
	value ' '
    Loading into attribute 'DB':'index'.'create table'
	value '0123456789'
    Loading into attribute '_db1':'properties'.'listing'
	value '55555'
    Loading into attribute '_db1':'properties'.'age'
	value ' 12'
    Loading into attribute '_db1':'properties'.'trans'
	value '1200'
    Loading into attribute '_db1':'properties'.'date_listed'
	value '01 Jan 86'
    Loading into attribute '_db1':'properties'.'time_listed'
	value '01 Jan 86 12:00:00'
    Loading into attribute '_db1':'properties'.'area_id'
	value '000456'
    Loading into attribute '_db1':'properties'.'price'
	value '$10000'
    Loading into attribute '_db1':'properties'.'description'
	value '!PROPERTY 1!'
    Loading into attribute '_db1':'properties'.'address'
	value 'Rhodnius Inc. 250 Bloor street East 1   '
    Loading into attribute '_db1':'properties'.'prop_id'
	value '0123456789'
    Loading into attribute '_db1':'prop owner'.'area_id'
	value '000456'
    Loading into attribute '_db1':'prop owner'.'trans'
	value '1200'
    Loading into attribute '_db1':'prop owner'.'time_listed'
	value '01 Jan 86 12:00:00'
    Loading into attribute '_db1':'prop owner'.'date_listed'
	value '01 Jan 86'
    Loading into attribute '_db1':'prop owner'.'prop_id'
	value '0123456789'
    Loading into attribute '_db1':'index'.'date listed'
	value ' 1 2  86'
    Loading into attribute '_db1':'index'.'select'
	value ' '
    Loading into attribute '_db1':'index'.'create table'
	value '0123456789'
    Loading into attribute 'DB':'properties'.'listing'
	value '55556'
    Loading into attribute 'DB':'properties'.'age'
	value ' 12'
    Loading into attribute 'DB':'properties'.'trans'
	value '1200'
    Loading into attribute 'DB':'properties'.'date_listed'
	value '02 Feb 86'
    Loading into attribute 'DB':'properties'.'time_listed'
	value '02 Feb 86 12:00:00'
    Loading into attribute 'DB':'properties'.'area_id'
	value '   456'
    Loading into attribute 'DB':'properties'.'price'
	value '$20000'
    Loading into attribute 'DB':'properties'.'description'
	value '!PROPERTY 2!'
    Loading into attribute 'DB':'properties'.'address'
	value 'Rhodnius Inc. 250 Bloor street East 2   '
    Loading into attribute 'DB':'prop owner'.'area_id'
	value '   456'
    Loading into attribute 'DB':'prop owner'.'trans'
	value '1200'
    Loading into attribute 'DB':'prop owner'.'time_listed'
	value '02 Feb 86 12:00:00'
    Loading into attribute 'DB':'prop owner'.'date_listed'
	value '02 Feb 86'
    Loading into attribute 'DB':'prop owner'.'prop_id'
	value '0123456789'
    Loading into attribute 'DB':'index'.'date listed'
	value ' 1 2  86'
    Loading into attribute 'DB':'index'.'select'
	value ' '
    Loading into attribute 'DB':'index'.'create table'
	value '0123456789'
    Loading into attribute '_db1':'properties'.'listing'
	value '55556'
    Loading into attribute '_db1':'properties'.'age'
	value ' 12'
    Loading into attribute '_db1':'properties'.'trans'
	value '1200'
    Loading into attribute '_db1':'properties'.'date_listed'
	value '02 Feb 86'
    Loading into attribute '_db1':'properties'.'time_listed'
	value '02 Feb 86 12:00:00'
    Loading into attribute '_db1':'properties'.'area_id'
	value '000456'
    Loading into attribute '_db1':'properties'.'price'
	value '$20000'
    Loading into attribute '_db1':'properties'.'description'
	value '!PROPERTY 2!'
    Loading into attribute '_db1':'properties'.'address'
	value 'Rhodnius Inc. 250 Bloor street East 2   '
    Loading into attribute '_db1':'properties'.'prop_id'
	value '0123456789'
    Loading into attribute '_db1':'prop owner'.'area_id'
	value '000456'
    Loading into attribute '_db1':'prop owner'.'trans'
	value '1200'
    Loading into attribute '_db1':'prop owner'.'time_listed'
	value '02 Feb 86 12:00:00'
    Loading into attribute '_db1':'prop owner'.'date_listed'
	value '02 Feb 86'
    Loading into attribute '_db1':'prop owner'.'prop_id'
	value '0123456789'
    Loading into attribute '_db1':'index'.'date listed'
	value ' 1 2  86'
    Loading into attribute '_db1':'index'.'select'
	value ' '
    Loading into attribute '_db1':'index'.'create table'
	value '0123456789'

*** Error: conversion error for attribute 'listing': value '77777'
out of range, record 4 rejected

*** Error: Invalid month in date format for attribute 'index'.'date listed', record 5 rejected

*** Error: conversion error for attribute 'date_listed': value '01 Sup 86'
invalid month, record 6 rejected

*** Error: conversion error for attribute 'listing': value '     '
no digits, record 7 rejected

      *** Summary ***
  No. records read = 7
  No.   rejected   = 4
*     listing     age          trans  date_listed         time_listed   area_id         price  description   address     prop_id

*  area_id          trans         date_listed                  time_listed  prop_id

* create table                   date listed  select

+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout
cat > stdout.jp_euc <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
* * *     ȥӥ塼 'DB':'properties'.'listing'
         '55555' ǥ
    ȥӥ塼 'DB':'properties'.'age'
         ' 12' ǥ
    ȥӥ塼 'DB':'properties'.'trans'
         '1200' ǥ
    ȥӥ塼 'DB':'properties'.'date_listed'
         '01 Jan 86' ǥ
    ȥӥ塼 'DB':'properties'.'time_listed'
         '01 Jan 86 12:00:00' ǥ
    ȥӥ塼 'DB':'properties'.'area_id'
         '   456' ǥ
    ȥӥ塼 'DB':'properties'.'price'
         '$10000' ǥ
    ȥӥ塼 'DB':'properties'.'description'
         '!PROPERTY 1!' ǥ
    ȥӥ塼 'DB':'properties'.'address'
         'Rhodnius Inc. 250 Bloor street East 1   ' ǥ
    ȥӥ塼 'DB':'prop owner'.'area_id'
         '   456' ǥ
    ȥӥ塼 'DB':'prop owner'.'trans'
         '1200' ǥ
    ȥӥ塼 'DB':'prop owner'.'time_listed'
         '01 Jan 86 12:00:00' ǥ
    ȥӥ塼 'DB':'prop owner'.'date_listed'
         '01 Jan 86' ǥ
    ȥӥ塼 'DB':'prop owner'.'prop_id'
         '0123456789' ǥ
    ȥӥ塼 'DB':'index'.'date listed'
         ' 1 2  86' ǥ
    ȥӥ塼 'DB':'index'.'select'
         ' ' ǥ
    ȥӥ塼 'DB':'index'.'create table'
         '0123456789' ǥ
    ȥӥ塼 '_db1':'properties'.'listing'
         '55555' ǥ
    ȥӥ塼 '_db1':'properties'.'age'
         ' 12' ǥ
    ȥӥ塼 '_db1':'properties'.'trans'
         '1200' ǥ
    ȥӥ塼 '_db1':'properties'.'date_listed'
         '01 Jan 86' ǥ
    ȥӥ塼 '_db1':'properties'.'time_listed'
         '01 Jan 86 12:00:00' ǥ
    ȥӥ塼 '_db1':'properties'.'area_id'
         '000456' ǥ
    ȥӥ塼 '_db1':'properties'.'price'
         '$10000' ǥ
    ȥӥ塼 '_db1':'properties'.'description'
         '!PROPERTY 1!' ǥ
    ȥӥ塼 '_db1':'properties'.'address'
         'Rhodnius Inc. 250 Bloor street East 1   ' ǥ
    ȥӥ塼 '_db1':'properties'.'prop_id'
         '0123456789' ǥ
    ȥӥ塼 '_db1':'prop owner'.'area_id'
         '000456' ǥ
    ȥӥ塼 '_db1':'prop owner'.'trans'
         '1200' ǥ
    ȥӥ塼 '_db1':'prop owner'.'time_listed'
         '01 Jan 86 12:00:00' ǥ
    ȥӥ塼 '_db1':'prop owner'.'date_listed'
         '01 Jan 86' ǥ
    ȥӥ塼 '_db1':'prop owner'.'prop_id'
         '0123456789' ǥ
    ȥӥ塼 '_db1':'index'.'date listed'
         ' 1 2  86' ǥ
    ȥӥ塼 '_db1':'index'.'select'
         ' ' ǥ
    ȥӥ塼 '_db1':'index'.'create table'
         '0123456789' ǥ
    ȥӥ塼 'DB':'properties'.'listing'
         '55556' ǥ
    ȥӥ塼 'DB':'properties'.'age'
         ' 12' ǥ
    ȥӥ塼 'DB':'properties'.'trans'
         '1200' ǥ
    ȥӥ塼 'DB':'properties'.'date_listed'
         '02 Feb 86' ǥ
    ȥӥ塼 'DB':'properties'.'time_listed'
         '02 Feb 86 12:00:00' ǥ
    ȥӥ塼 'DB':'properties'.'area_id'
         '   456' ǥ
    ȥӥ塼 'DB':'properties'.'price'
         '$20000' ǥ
    ȥӥ塼 'DB':'properties'.'description'
         '!PROPERTY 2!' ǥ
    ȥӥ塼 'DB':'properties'.'address'
         'Rhodnius Inc. 250 Bloor street East 2   ' ǥ
    ȥӥ塼 'DB':'prop owner'.'area_id'
         '   456' ǥ
    ȥӥ塼 'DB':'prop owner'.'trans'
         '1200' ǥ
    ȥӥ塼 'DB':'prop owner'.'time_listed'
         '02 Feb 86 12:00:00' ǥ
    ȥӥ塼 'DB':'prop owner'.'date_listed'
         '02 Feb 86' ǥ
    ȥӥ塼 'DB':'prop owner'.'prop_id'
         '0123456789' ǥ
    ȥӥ塼 'DB':'index'.'date listed'
         ' 1 2  86' ǥ
    ȥӥ塼 'DB':'index'.'select'
         ' ' ǥ
    ȥӥ塼 'DB':'index'.'create table'
         '0123456789' ǥ
    ȥӥ塼 '_db1':'properties'.'listing'
         '55556' ǥ
    ȥӥ塼 '_db1':'properties'.'age'
         ' 12' ǥ
    ȥӥ塼 '_db1':'properties'.'trans'
         '1200' ǥ
    ȥӥ塼 '_db1':'properties'.'date_listed'
         '02 Feb 86' ǥ
    ȥӥ塼 '_db1':'properties'.'time_listed'
         '02 Feb 86 12:00:00' ǥ
    ȥӥ塼 '_db1':'properties'.'area_id'
         '000456' ǥ
    ȥӥ塼 '_db1':'properties'.'price'
         '$20000' ǥ
    ȥӥ塼 '_db1':'properties'.'description'
         '!PROPERTY 2!' ǥ
    ȥӥ塼 '_db1':'properties'.'address'
         'Rhodnius Inc. 250 Bloor street East 2   ' ǥ
    ȥӥ塼 '_db1':'properties'.'prop_id'
         '0123456789' ǥ
    ȥӥ塼 '_db1':'prop owner'.'area_id'
         '000456' ǥ
    ȥӥ塼 '_db1':'prop owner'.'trans'
         '1200' ǥ
    ȥӥ塼 '_db1':'prop owner'.'time_listed'
         '02 Feb 86 12:00:00' ǥ
    ȥӥ塼 '_db1':'prop owner'.'date_listed'
         '02 Feb 86' ǥ
    ȥӥ塼 '_db1':'prop owner'.'prop_id'
         '0123456789' ǥ
    ȥӥ塼 '_db1':'index'.'date listed'
         ' 1 2  86' ǥ
    ȥӥ塼 '_db1':'index'.'select'
         ' ' ǥ
    ȥӥ塼 '_db1':'index'.'create table'
         '0123456789' ǥ

*** Error: Ѵ顼 ȥӥ塼 'listing':  '77777' 
ϰϤۤƤޤ,쥳 4 ϥꥸȤޤ

*** Error: month  եեޥåȤŬڤǤ ȥӥ塼 'index'.'date listed' Ф 5 쥳ɤꥸȤޤ

*** Error: Ѵ顼 ȥӥ塼 'date_listed':  '01 Sup 86' 
աʷˤλ꤬㤤ޤ,쥳 6 ϥꥸȤޤ

*** Error: Ѵ顼 ȥӥ塼 'listing':  '     ' 
ǤϤޤ,쥳 7 ϥꥸȤޤ

      *** ά ***
  쥳ɹ = 7
   ꥸȿ  = 4
*     listing     age          trans  date_listed         time_listed   area_id         price  description   address     prop_id

*  area_id          trans         date_listed                  time_listed  prop_id

* create table                   date listed  select

+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout.jp_euc
cat > tag <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
Data base loader, with display option and TESTMODE
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 tag
