cat > script <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
empdbld $MSTESTDB $MSTSRCMINOR/_sp.sp1 $MSTSRCMINOR/_dt.ok1
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 755 script
cat > stdout <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
*** Specification Error *** 
	database 'DB' -- table 'no_table' does not exist
*** Specification Error *** 
	database 'no_db' -- 'no_db' is not a valid database
*** Specification Error *** 
	table 'DB':'properties', listed twice
*** Specification Error *** 
	attribute 'prop owner'.'area_id', listed twice
*** Specification Error *** 
	table 'prop owner' -- attribute 'ktrans' does not exist
*** Specification Error *** 
	attribute 'prop owner'.'date_listed', string length mismatch in nullif
*** Specification Error *** 
	non-null attribute 'index'.'select', not listed or includes nullif
*     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 > tag <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
Data base loader, test invalid spec file 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 tag
cat > stdout.jp_euc <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
*** ҥ顼 *** 
        ǡ١ 'DB' -- ơ֥ 'no_table' ¸ߤޤ
*** ҥ顼 *** 
        ǡ١ 'no_db' -- 'no_db' ̵ʥǡ١Ǥ
*** ҥ顼 *** 
        ơ֥ 'DB':'properties' ٻꤵƤޤ
*** ҥ顼 *** 
        ȥӥ塼 'prop owner'.'area_id' ϣٻꤵƤޤ
*** ҥ顼 *** 
        ơ֥ 'prop owner' -- ȥӥ塼 'ktrans' ¸ߤޤ
*** ҥ顼 *** 
        ȥӥ塼 'prop owner'.'date_listed'  NULLIF ʸĹŬڤǤ
*** ҥ顼 *** 
        NULL ͤʤȥӥ塼 'index'.'select'  NULLIF ꤷƤʤޤǤޤ
*     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
