cat > script <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
create comment on table personnel set "Joe's Garage Employees";
comment table loans null;
create comment attr personnel.name "Last Name";
comment attr personnel.credit_limit is "xxx";
comment attribute personnel.credit_limit is "yyy";
select tab_name, tab_comment from sys_tables where tab_name !match 'sys_*';
select tab_name, attr_name, attr_comment 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 sort by 1;
select tab_name, attr_name, attr_comment from sys_attrs, sys_tables
	where sys_tables.tab_name = 'loans'
	and sys_tables.tab_number = sys_attrs.attr_tabnum
	group by sys_tables.tab_name sort by 1;
create comment on personnel set null;
create comment on table personnel set null;
comment on table personnel is null;
drop comment attr personnel.name;
comment attribute personnel.credit_limit "";
select tab_name, tab_comment from sys_tables where tab_name !match 'sys_*';
select tab_name, attr_name, attr_comment 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 sort by 1;
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 755 script
cat > stdout <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
* * * * * * tab_name                          tab_comment

IX
IX2
T
loans
personnel                         Joe's Garage Employe
                                  es
t1_test
t64
* . . . tab_name                          attr_name                         attr_comment

personnel                         name                              Last Name
                                  char2
                                  char3
                                  sint
                                  number
                                  phone
                                  date1
                                  date2
                                  date3
                                  date4
                                  date5
                                  date6
                                  date7
                                  date8
                                  credit_limit                      yyy
                                  dollar2
* . . . tab_name                          attr_name                         attr_comment

loans                             name
                                  date
                                  amount
* *** Syntax Error: expecting an object(table, attribute, trigger, module or routine) specification
Error detected near the end of:
create comment on personnel 
* *** Syntax Error: expecting a comment
Error detected near the end of:
create comment on table personnel set null;
* * * * tab_name                          tab_comment

IX
IX2
T
loans
personnel
t1_test
t64
* . . . tab_name                          attr_name                         attr_comment

personnel                         name
                                  char2
                                  char3
                                  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-+-+-+-+-+'
* * * * * * tab_name                          tab_comment

IX
IX2
T
loans
personnel                         Joe's Garage Employe
                                  es
t1_test
t64
* . . . tab_name                          attr_name                         attr_comment

personnel                         name                              Last Name
                                  char2
                                  char3
                                  sint
                                  number
                                  phone
                                  date1
                                  date2
                                  date3
                                  date4
                                  date5
                                  date6
                                  date7
                                  date8
                                  credit_limit                      yyy
                                  dollar2
* . . . tab_name                          attr_name                         attr_comment

loans                             name
                                  date
                                  amount
* *** Syntax Error: ֥(ơ֥, ȥӥ塼, ȥꥬ, ⥸塼,롼ƥ) ꤬ɬפǤ
顼ζ᤯ǵƤޤ:
create comment on personnel 
* *** Syntax Error: ȤɬפǤ
顼ζ᤯ǵƤޤ:
create comment on table personnel set null;
* * * * tab_name                          tab_comment

IX
IX2
T
loans
personnel
t1_test
t64
* . . . tab_name                          attr_name                         attr_comment

personnel                         name
                                  char2
                                  char3
                                  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 "comment", "create comment" and "drop comment" commands
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 tag
