cat > script <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
empsql $MSTESTDB < $MSTSRCMINOR/_msscpt2
empdbld -r reject $MSTESTDB $MSTSRCMINOR/_sp.ok2 $MSTSRCMINOR/_dt.ok2

cat reject
rm -f reject
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 755 script
cat > stdout <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
* * * 
*** Error: duplicate value for attribute 'listing', record 3 rejected

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

*** Error: duplicate value for attribute 'listing', 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   = 5
55556
 12
1200
01 MAR 86 12:00:00
   456
$10000
!PROPERTY 1!
Rhodnius Inc. 250 Bloor street East 1   
0123456789
C REC 3
 1 11986

77777
 12
1200
02 Apr 86 12:00:00
   456
$20000
!PROPERTY 2!
Rhodnius Inc. 250 Bloor street East 2   
0123456789
  REC 4
41011986

55555
 12
1200
02 Apr 86 12:00:00
   456
$20000
!PROPERTY 2!
Rhodnius Inc. 250 Bloor street East 2   
0123456789
  REC 5
01J11986

55555
 12
1200
01 Sup 86 12:00:00
   456
$20000
!PROPERTY 2!
Rhodnius Inc. 250 Bloor street East 2   
0123456789
  REC 6
 1 11986

     
 12
1200
01 Sup 86 12:00:00
   456
$20000
!PROPERTY 2!
Rhodnius Inc. 250 Bloor street East 2   
0123456789
  REC 7
 1 11986

*     listing     age          trans  date_listed         time_listed   area_id         price  description   address     prop_id

      55555      12   1.200000e+03     1 Jan 86   1 Jan 86 12:00:00   456.000   $*10,000.00  !PROPERTY 1!  Rhodnius I
                                                                                                           nc. 250 Bl
                                                                                                           oor street
                                                                                                            East 1
      55556      12   1.200000e+03     2 Feb 86   2 Feb 86 12:00:00   456.000   $*20,000.00  !PROPERTY 2!  Rhodnius I
                                                                                                           nc. 250 Bl
                                                                                                           oor street
                                                                                                            East 2
*  area_id          trans         date_listed                  time_listed  prop_id

 456.000   1.200000e-01  January    1, 1986  January    1, 1986 12:00:00
 456.000   1.200000e-01  February   2, 1986  February   2, 1986 12:00:00
* create table                   date listed  select

01 23 45 67 89                    19860201
01 23 45 67 89                    19860201
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout
cat > stdout.jp_euc <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
* * * 
*** Error: ȥӥ塼 'listing' ͤϴ¸ߤޤ,쥳 3 ϥꥸȤޤ

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

*** Error: ȥӥ塼 'listing' ͤϴ¸ߤޤ,쥳 5 ϥꥸȤޤ

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

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

      *** ά ***
  쥳ɹ = 7
   ꥸȿ  = 5
55556
 12
1200
01 MAR 86 12:00:00
   456
$10000
!PROPERTY 1!
Rhodnius Inc. 250 Bloor street East 1   
0123456789
C REC 3
 1 11986

77777
 12
1200
02 Apr 86 12:00:00
   456
$20000
!PROPERTY 2!
Rhodnius Inc. 250 Bloor street East 2   
0123456789
  REC 4
41011986

55555
 12
1200
02 Apr 86 12:00:00
   456
$20000
!PROPERTY 2!
Rhodnius Inc. 250 Bloor street East 2   
0123456789
  REC 5
01J11986

55555
 12
1200
01 Sup 86 12:00:00
   456
$20000
!PROPERTY 2!
Rhodnius Inc. 250 Bloor street East 2   
0123456789
  REC 6
 1 11986

     
 12
1200
01 Sup 86 12:00:00
   456
$20000
!PROPERTY 2!
Rhodnius Inc. 250 Bloor street East 2   
0123456789
  REC 7
 1 11986

*     listing     age          trans  date_listed         time_listed   area_id         price  description   address     prop_id

      55555      12   1.200000e+03     1 Jan 86   1 Jan 86 12:00:00   456.000   $*10,000.00  !PROPERTY 1!  Rhodnius I
                                                                                                           nc. 250 Bl
                                                                                                           oor street
                                                                                                            East 1
      55556      12   1.200000e+03     2 Feb 86   2 Feb 86 12:00:00   456.000   $*20,000.00  !PROPERTY 2!  Rhodnius I
                                                                                                           nc. 250 Bl
                                                                                                           oor street
                                                                                                            East 2
*  area_id          trans         date_listed                  time_listed  prop_id

 456.000   1.200000e-01  January    1, 1986  January    1, 1986 12:00:00
 456.000   1.200000e-01  February   2, 1986  February   2, 1986 12:00:00
* create table                   date listed  select

01 23 45 67 89                    19860201
01 23 45 67 89                    19860201
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout.jp_euc
cat > tag <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
Data base loader, with reject option 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 tag
