cat > script <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
create table XX
	(name	char(3,1),
	amount integer);
select tab_name from sys_tables where tab_name = 'XX';
rename table XX to money;
select tab_name from sys_tables where tab_name = 'XX';
select tab_name from sys_tables where tab_name = 'money';
rename attribute money.name amount;
rename attr money.name to person;
rename attr money.name to people;
rename attr money.amount to money.money;
rename money.amount to money.money;
rename attr money.amount money;
rename money to XX;
select tab_name, attr_name from sys_attrs, sys_tables
	where sys_tables.tab_name = 'money'
	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-+-+-+-+-+'
* . . * tab_name

XX
* * tab_name

* tab_name

money
* 
*** Error: attribute 'amount' already exists
* * 
*** Error: attribute 'name' does not exist
* *** Syntax Error: extra characters after end of valid command
Error detected near the end of:
rename attr money.amount to money.m
* *** Syntax Error: expecting a table or table/attribute specification
Error detected near the end of:
rename money.
* * *** Syntax Error: expecting a table or table/attribute specification
Error detected near the end of:
rename money 
* . . . tab_name                          attr_name

money                             person
                                  money
* * 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout
cat > tag <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
Test for "rename" command
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 tag
cat > stdout.jp_euc <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
* . . * tab_name

XX
* * tab_name

* tab_name

money
* 
*** Error: ȥӥ塼 'amount' ϴ¸ߤޤ
* * 
*** Error: ȥӥ塼 'name' ¸ߤޤ
* *** Syntax Error: ޥɤθüʸޤޤƤޤ
顼ζ᤯ǵƤޤ:
rename attr money.amount to money.m
* *** Syntax Error: ơ֥ޤϥơ֥롿ȥӥ塼Ȥλ꤬ɬפǤ
顼ζ᤯ǵƤޤ:
rename money.
* * *** Syntax Error: ơ֥ޤϥơ֥롿ȥӥ塼Ȥλ꤬ɬפǤ
顼ζ᤯ǵƤޤ:
rename money 
* . . . tab_name                          attr_name

money                             person
                                  money
* * 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout.jp_euc
