cat > script <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
. $EMPRESSPATH/config/options

empsql $MSTESTDB < $MSTSRCMINOR/_msscpt2

:	' Note: datafile from stdin - only supported on unix '
:	'	on VMS or DOS use instead ... '
:	'  empdbld -c $MSTESTDB $MSTSRCMINOR/_sp.ok2 $MSTSRCMINOR/_dt.ok2 '

case $MSSYS_PLATFORM in
 SYS_OS_WIN32)
	empdbld -c $MSTESTDB $MSTSRCMINOR/_sp.ok2 $MSTSRCMINOR/_dt.ok2
	;;
 *)
	empdbld -c $MSTESTDB $MSTSRCMINOR/_sp.ok2 < $MSTSRCMINOR/_dt.ok2
	;;
esac

+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 755 script
cat > stdout <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
* * * 
*** 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-+-+-+-+-+'
* * * 
*** 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 check option and data from stdin 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 tag
