cat > script <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
create range check on personnel.sint set <= 15, > 20;
insert into personnel set sint to 18;
create range personnel.name (!smatch '*John*');
create check personnel.date1 set between '01 01 1984' inclusive and\
	'01 07 1984' exclusive;
create range check personnel.date1 set between '01 01 1984' inclusive and\
	'01 07 1984' exclusive;
create range personnel.date2 '06/06/91';
insert into personnel set date2 to 'June 6, 1991';
insert into personnel set date2 to '06/06/91';
select date2 from personnel where date2 match '*91*';
create range check on personnel.credit_limit range 300.00 to 400.00;
create range on personnel.char2 (!match 'a*z', like 'z*a');
create range personnel.char3 != 25;
create range personnel.char3 match 'Mosca';
create range personnel.char3;
select tab_name, attr_name, attr_range from sys_attrs, sys_tables
	where sys_tables.tab_name = 'personnel'
	and sys_tables.tab_number = sys_attrs.attr_tabnum
	group by sys_tables.tab_name order by 1;
drop range on personnel.sint;
drop range personnel.sint;
drop check on personnel.name;
drop range check on personnel.name;
drop range check personnel.date1;
drop range check personnel.date2;
drop range check on personnel.credit_limit;
drop range personnel.char2;
select tab_name, attr_name, attr_range from sys_attrs, sys_tables
	where sys_tables.tab_name = 'personnel'
	and sys_tables.tab_number = sys_attrs.attr_tabnum
	group by sys_tables.tab_name order by 1;
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 755 script
cat > stdout <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
* * 
*** Error: conversion error for attribute 'sint': value '18'
out of range
* * *** Syntax Error: expecting a table specification
Error detected near the end of:
create check 
* * * * *              date2

June       6, 1991
June       6, 1991
* * * * * *** Syntax Error: expecting a constant
Error detected near the end of:
create range personnel.char3;
* . . . tab_name                          attr_name                         attr_range

personnel                         name                              !smatch '*John*'
                                  char2                             !match 'a*z'
                                                                    like 'z*a'
                                  char3                             match 'Mosca'
                                  sint                              <= '15'
                                                                    > '20'
                                  number
                                  phone
                                  date1                             range '19840101' i '
                                                                    19840701' e
                                  date2                             = '19910606'
                                  date3
                                  date4
                                  date5
                                  date6
                                  date7
                                  date8
                                  credit_limit                      range '300.00' i '40
                                                                    0.00' i
                                  dollar2
* * * *** Syntax Error: expecting a table specification
Error detected near the end of:
drop check 
* * * * * * . . . tab_name                          attr_name                         attr_range

personnel                         name
                                  char2
                                  char3                             match 'Mosca'
                                  sint
                                  number
                                  phone
                                  date1
                                  date2
                                  date3
                                  date4
                                  date5
                                  date6
                                  date7
                                  date8
                                  credit_limit
                                  dollar2
* 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout
cat > stdout.jp_euc <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
* * 
*** Error: Ѵ顼 ȥӥ塼 'sint':  '18' 
ϰϤۤƤޤ
* * *** Syntax Error: ơ֥꤬ɬפǤ
顼ζ᤯ǵƤޤ:
create check 
* * * * *              date2

June       6, 1991
June       6, 1991
* * * * * *** Syntax Error: ɬפǤ
顼ζ᤯ǵƤޤ:
create range personnel.char3;
* . . . tab_name                          attr_name                         attr_range

personnel                         name                              !smatch '*John*'
                                  char2                             !match 'a*z'
                                                                    like 'z*a'
                                  char3                             match 'Mosca'
                                  sint                              <= '15'
                                                                    > '20'
                                  number
                                  phone
                                  date1                             range '19840101' i '
                                                                    19840701' e
                                  date2                             = '19910606'
                                  date3
                                  date4
                                  date5
                                  date6
                                  date7
                                  date8
                                  credit_limit                      range '300.00' i '40
                                                                    0.00' i
                                  dollar2
* * * *** Syntax Error: ơ֥꤬ɬפǤ
顼ζ᤯ǵƤޤ:
drop check 
* * * * * * . . . tab_name                          attr_name                         attr_range

personnel                         name
                                  char2
                                  char3                             match 'Mosca'
                                  sint
                                  number
                                  phone
                                  date1
                                  date2
                                  date3
                                  date4
                                  date5
                                  date6
                                  date7
                                  date8
                                  credit_limit
                                  dollar2
* 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout.jp_euc
cat > tag <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
Test for "create range check" and "drop range check" commands
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 tag
