| >> |
| >>obey TEST072(clnup); |
| >>-------------------------------------------------------------------------- |
| >> |
| >>-- CLEANUP database |
| >>drop schema IF EXISTS t072sch_comment cascade; |
| |
| --- SQL operation complete. |
| >> |
| >>obey TEST072(compile_libs); |
| >>-------------------------------------------------------------------------- |
| >>log; |
| ------------------------------------------------------------------------------ |
| -- Compiling Java source files: TEST072.java |
| -- Executing: $javac -d $REGRRUNDIR $REGRTSTDIR/TEST072.java |
| -- $javac returned 0 |
| ------------------------------------------------------------------------------ |
| ------------------------------------------------------------------------------ |
| -- Archiving Java class files: |
| -- TEST072.class |
| -- Archive will be written to: TEST072.jar |
| -- Executing: $jar cMf TEST072.jar TEST072.class |
| -- $jar returned 0 |
| ------------------------------------------------------------------------------ |
| >> |
| >> |
| >>obey TEST072(ddl); |
| >>-------------------------------------------------------------------------- |
| >> |
| >>create schema t072sch_comment; |
| |
| --- SQL operation complete. |
| >> |
| >>create table t072sch_comment.t072t1 ( col1 int not null, col2 DECIMAL(10, 4) not null, col3 VARCHAR(50) not null, primary key (col1) ); |
| |
| --- SQL operation complete. |
| >> |
| >>create index t072idx1 on t072sch_comment.t072t1 (col1, col3); |
| |
| --- SQL operation complete. |
| >> |
| >>create view t072sch_comment.t072view1 as select * from t072sch_comment.t072t1; |
| |
| --- SQL operation complete. |
| >> |
| >>create library t072sch_comment.t072ddl file $$QUOTE$$ $$REGRRUNDIR$$/$$DLL$$ $$QUOTE$$; |
| |
| --- SQL operation complete. |
| >> |
| >>create library t072sch_comment.t072jar file $$QUOTE$$ $$REGRRUNDIR$$/$$SPJJAR$$ $$QUOTE$$; |
| |
| --- SQL operation complete. |
| >> |
| >> |
| >>create function t072sch_comment.t072func(int,int) returns (add2 int) |
| +> external name 'add2' library t072sch_comment.t072ddl |
| +> deterministic no sql no transaction required |
| +>; |
| |
| --- SQL operation complete. |
| >> |
| >>create procedure t072sch_comment.t072spj() |
| +> external name 'TEST072.testMoreResultSet' |
| +> library t072sch_comment.t072jar |
| +> language java |
| +> DYNAMIC RESULT SETS 5 |
| +> READS SQL DATA |
| +>; |
| |
| --- SQL operation complete. |
| >> |
| >>CREATE SEQUENCE t072sch_comment.t072seq |
| +> START WITH 1 |
| +> INCREMENT BY 1 |
| +> MAXVALUE 10000 |
| +> NO CYCLE |
| +> CACHE 20 |
| +> --UNSIGNED INTEGER |
| +>; |
| |
| --- SQL operation complete. |
| >> |
| >> |
| >> |
| >>obey TEST072(comment01); |
| >>-------------------------------------------------------------------------- |
| >> |
| >>--CREATE COMMENTS |
| >>comment on schema t072sch_comment is 'This is a new comment of SCHEMA.这是一个schema的注释。' ; |
| |
| --- SQL operation complete. |
| >>comment on table t072sch_comment.t072t1 is 'This is a new comment of TABLE.这个是一个中文的table的注释。》》、……' ; |
| |
| --- SQL operation complete. |
| >>comment on index TRAFODION.t072sch_comment.t072idx1 is 'This is a new comment of INDEX.' ; |
| |
| --- SQL operation complete. |
| >>comment on view TRAFODION.t072sch_comment.t072view1 is 'This is VIEW''s comment.' ; |
| |
| --- SQL operation complete. |
| >>comment on library TRAFODION.t072sch_comment.t072ddl is 'This is a new comment of C UDF library.' ; |
| |
| --- SQL operation complete. |
| >>comment on library t072sch_comment.t072jar is 'This is a new comment of Java SPJ library.' ; |
| |
| --- SQL operation complete. |
| >>comment on function t072sch_comment.t072func is 'This is a new comment of SCALAR UDF.' ; |
| |
| --- SQL operation complete. |
| >>comment on procedure t072sch_comment.t072spj is 'This is a new comment of SPJ.' ; |
| |
| --- SQL operation complete. |
| >>comment on sequence t072sch_comment.t072seq is 'This is a new comment of SEQUENCE.' ; |
| |
| --- SQL operation complete. |
| >> |
| >>comment on column t072sch_comment.t072t1.col1 is 'This is a T01 column new comment of table.' ; |
| |
| --- SQL operation complete. |
| >>comment on column t072sch_comment.t072t1.col2 is 'This is a T02 column new comment of table.' ; |
| |
| --- SQL operation complete. |
| >>comment on column t072sch_comment.t072t1.col3 is 'This is a T03 column new comment of table.' ; |
| |
| --- SQL operation complete. |
| >>comment on column t072sch_comment.t072view1.col1 is 'This is a V01 column new comment of view.' ; |
| |
| --- SQL operation complete. |
| >>comment on column t072sch_comment.t072view1.col2 is 'This is a V02 column new comment of view.' ; |
| |
| --- SQL operation complete. |
| >>comment on column t072sch_comment.t072view1.col3 is 'This is a V03 column new comment of view.大家好。' ; |
| |
| --- SQL operation complete. |
| >> |
| >> |
| >>obey TEST072(showcomment); |
| >>-------------------------------------------------------------------------- |
| >> |
| >>select * from "_MD_".OBJECT_COMMENT_VIEW where schema_name = UPPER('t072sch_comment'); |
| |
| CATALOG_NAME SCHEMA_NAME OBJECT_NAME COMMENT |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| |
| TRAFODION T072SCH_COMMENT __SCHEMA__ This is a new comment of SCHEMA.这是一个schema的注释。 |
| TRAFODION T072SCH_COMMENT T072T1 This is a new comment of TABLE.这个是一个中文的table的注释。》》、…… |
| TRAFODION T072SCH_COMMENT T072IDX1 This is a new comment of INDEX. |
| TRAFODION T072SCH_COMMENT T072VIEW1 This is VIEW's comment. |
| TRAFODION T072SCH_COMMENT T072DDL This is a new comment of C UDF library. |
| TRAFODION T072SCH_COMMENT T072JAR This is a new comment of Java SPJ library. |
| TRAFODION T072SCH_COMMENT T072FUNC This is a new comment of SCALAR UDF. |
| TRAFODION T072SCH_COMMENT T072SPJ This is a new comment of SPJ. |
| TRAFODION T072SCH_COMMENT T072SEQ This is a new comment of SEQUENCE. |
| |
| --- 9 row(s) selected. |
| >> |
| >>select * from "_MD_".COLUMN_COMMENT_VIEW where schema_name = UPPER('t072sch_comment'); |
| |
| CATALOG_NAME SCHEMA_NAME OBJECT_NAME COLUMN_NAME COMMENT |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| |
| TRAFODION T072SCH_COMMENT T072T1 COL1 This is a T01 column new comment of table. |
| TRAFODION T072SCH_COMMENT T072T1 COL2 This is a T02 column new comment of table. |
| TRAFODION T072SCH_COMMENT T072T1 COL3 This is a T03 column new comment of table. |
| TRAFODION T072SCH_COMMENT T072VIEW1 COL1 This is a V01 column new comment of view. |
| TRAFODION T072SCH_COMMENT T072VIEW1 COL2 This is a V02 column new comment of view. |
| TRAFODION T072SCH_COMMENT T072VIEW1 COL3 This is a V03 column new comment of view.大家好。 |
| |
| --- 6 row(s) selected. |
| >> |
| >> |
| >>obey TEST072(showddl1); |
| >>-------------------------------------------------------------------------- |
| >> |
| >>showddl schema t072sch_comment; |
| |
| CREATE PRIVATE SCHEMA "TRAFODION"."T072SCH_COMMENT" AUTHORIZATION "DB__ROOT"; |
| |
| COMMENT ON SCHEMA TRAFODION.T072SCH_COMMENT IS |
| 'This is a new comment of SCHEMA.这是一个schema的注释。' |
| ; |
| |
| --- SQL operation complete. |
| >>showddl table t072sch_comment.t072t1; |
| |
| CREATE TABLE TRAFODION.T072SCH_COMMENT.T072T1 |
| ( |
| COL1 INT NO DEFAULT NOT NULL NOT DROPPABLE |
| , COL2 DECIMAL(10, 4) NO DEFAULT NOT NULL NOT |
| DROPPABLE |
| , COL3 VARCHAR(50) CHARACTER SET ISO88591 COLLATE |
| DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE |
| , PRIMARY KEY (COL1 ASC) |
| ) |
| ATTRIBUTES ALIGNED FORMAT |
| ; |
| |
| CREATE INDEX T072IDX1 ON TRAFODION.T072SCH_COMMENT.T072T1 |
| ( |
| COL1 ASC |
| , COL3 ASC |
| ) |
| ; |
| |
| COMMENT ON TABLE TRAFODION.T072SCH_COMMENT.T072T1 IS |
| 'This is a new comment of TABLE.这个是一个中文的table的注释。》》、……' |
| ; |
| |
| COMMENT ON COLUMN TRAFODION.T072SCH_COMMENT.T072T1.COL1 IS |
| 'This is a T01 column new comment of table.' ; |
| COMMENT ON COLUMN TRAFODION.T072SCH_COMMENT.T072T1.COL2 IS |
| 'This is a T02 column new comment of table.' ; |
| COMMENT ON COLUMN TRAFODION.T072SCH_COMMENT.T072T1.COL3 IS |
| 'This is a T03 column new comment of table.' ; |
| |
| COMMENT ON INDEX TRAFODION.T072SCH_COMMENT.T072IDX1 IS |
| 'This is a new comment of INDEX.' ; |
| |
| --- SQL operation complete. |
| >>showddl table t072sch_comment.t072view1; |
| |
| CREATE VIEW TRAFODION.T072SCH_COMMENT.T072VIEW1 AS |
| SELECT TRAFODION.T072SCH_COMMENT.T072T1.COL1, |
| TRAFODION.T072SCH_COMMENT.T072T1.COL2, |
| TRAFODION.T072SCH_COMMENT.T072T1.COL3 FROM |
| TRAFODION.T072SCH_COMMENT.T072T1 ; |
| |
| COMMENT ON VIEW TRAFODION.T072SCH_COMMENT.T072VIEW1 IS |
| 'This is VIEW''s comment.' ; |
| |
| COMMENT ON COLUMN TRAFODION.T072SCH_COMMENT.T072VIEW1.COL1 IS |
| 'This is a V01 column new comment of view.' ; |
| COMMENT ON COLUMN TRAFODION.T072SCH_COMMENT.T072VIEW1.COL2 IS |
| 'This is a V02 column new comment of view.' ; |
| COMMENT ON COLUMN TRAFODION.T072SCH_COMMENT.T072VIEW1.COL3 IS |
| 'This is a V03 column new comment of view.大家好。' ; |
| |
| --- SQL operation complete. |
| >>showddl library t072sch_comment.t072ddl; |
| CREATE LIBRARY TRAFODION.T072SCH_COMMENT.T072DDL FILE '$rundir/compGeneral/TEST072.dll' |
| ; |
| |
| COMMENT ON LIBRARY TRAFODION.T072SCH_COMMENT.T072DDL IS |
| 'This is a new comment of C UDF library.' ; |
| |
| --- SQL operation complete. |
| >>showddl library t072sch_comment.t072jar; |
| CREATE LIBRARY TRAFODION.T072SCH_COMMENT.T072JAR FILE '$rundir/compGeneral/TEST072.jar' |
| ; |
| |
| COMMENT ON LIBRARY TRAFODION.T072SCH_COMMENT.T072JAR IS |
| 'This is a new comment of Java SPJ library.' ; |
| |
| --- SQL operation complete. |
| >>showddl function t072sch_comment.t072func; |
| |
| CREATE FUNCTION TRAFODION.T072SCH_COMMENT.T072FUNC |
| ( |
| IN INTEGER SIGNED |
| , IN INTEGER SIGNED |
| ) |
| RETURNS |
| ( |
| OUT ADD2 INTEGER SIGNED |
| ) |
| EXTERNAL NAME 'add2' |
| LIBRARY TRAFODION.T072SCH_COMMENT.T072DDL |
| LANGUAGE C |
| PARAMETER STYLE SQL |
| NO SQL |
| NO FINAL CALL |
| NO STATE AREA |
| ALLOW ANY PARALLELISM |
| DETERMINISTIC |
| SAFE EXECUTION MODE |
| ; |
| |
| COMMENT ON FUNCTION TRAFODION.T072SCH_COMMENT.T072FUNC IS |
| 'This is a new comment of SCALAR UDF.' ; |
| |
| --- SQL operation complete. |
| >>showddl procedure t072sch_comment.t072spj; |
| |
| CREATE PROCEDURE TRAFODION.T072SCH_COMMENT.T072SPJ |
| ( |
| ) |
| EXTERNAL NAME 'TEST072.testMoreResultSet (java.sql.ResultSet[],java.sql.ResultSet[],java.sql.ResultSet[],java.sql.ResultSet[],java.sql.ResultSet[])' |
| LIBRARY TRAFODION.T072SCH_COMMENT.T072JAR |
| EXTERNAL SECURITY INVOKER |
| LANGUAGE JAVA |
| PARAMETER STYLE JAVA |
| READS SQL DATA |
| DYNAMIC RESULT SETS 5 |
| TRANSACTION REQUIRED |
| ISOLATE |
| ; |
| |
| COMMENT ON PROCEDURE TRAFODION.T072SCH_COMMENT.T072SPJ IS |
| 'This is a new comment of SPJ.' ; |
| |
| --- SQL operation complete. |
| >>showddl sequence t072sch_comment.t072seq; |
| |
| CREATE SEQUENCE TRAFODION.T072SCH_COMMENT.T072SEQ |
| START WITH 1 /* NEXT AVAILABLE VALUE 1 */ |
| INCREMENT BY 1 |
| MAXVALUE 10000 |
| MINVALUE 1 |
| CACHE 20 |
| NO CYCLE |
| LARGEINT |
| ; |
| |
| COMMENT ON SEQUENCE TRAFODION.T072SCH_COMMENT.T072SEQ IS |
| 'This is a new comment of SEQUENCE.' ; |
| |
| --- SQL operation complete. |
| >> |
| >> |
| >> |
| >>obey TEST072(comment02); |
| >>-------------------------------------------------------------------------- |
| >> |
| >>--MODIFY COMMENTS |
| >>comment on schema t072sch_comment is 'This is a Modified comment: This is a comment of SCHEMA.这是一个schema的注释。' ; |
| |
| --- SQL operation complete. |
| >>comment on table t072sch_comment.t072t1 is 'This is a Modified comment: This is a comment of TABLE.这个是一个中文的table的注释。》》、……' ; |
| |
| --- SQL operation complete. |
| >>comment on index t072sch_comment.t072idx1 is '这个是修改过后的索引注释' ; |
| |
| --- SQL operation complete. |
| >>comment on view t072sch_comment.t072view1 is 'This is a Modified time 01: This is a comment of VIEW.你好' ; |
| |
| --- SQL operation complete. |
| >>comment on view t072sch_comment.t072view1 is 'This is a Modified time 02: This is a comment of VIEW.你好' ; |
| |
| --- SQL operation complete. |
| >>comment on view t072sch_comment.t072view1 is 'This is a Modified time 03: This is a comment of VIEW.你好' ; |
| |
| --- SQL operation complete. |
| >>comment on view t072sch_comment.t072view1 is 'This is a Modified time 04: This is a comment of VIEW.你好' ; |
| |
| --- SQL operation complete. |
| >>comment on library t072sch_comment.t072ddl is 'This is a Modified comment: This is a comment of C UDF library.' ; |
| |
| --- SQL operation complete. |
| >>comment on library t072sch_comment.t072jar is 'This is a Modified comment: This is a comment of Java SPJ library.' ; |
| |
| --- SQL operation complete. |
| >>--max comment length |
| >>comment on function t072sch_comment.t072func is 'This is a Modified big comment: nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnul' ; |
| |
| --- SQL operation complete. |
| >>comment on procedure t072sch_comment.t072spj is 'This is a Modified comment: This is a comment of SPJ.' ; |
| |
| --- SQL operation complete. |
| >>comment on sequence t072sch_comment.t072seq is 'This is a Modified comment: This is a comment of SEQUENCE.' ; |
| |
| --- SQL operation complete. |
| >> |
| >>comment on column t072sch_comment.t072t1.col3 is 'This is a Modified time 01: This is a T03 column comment of table.' ; |
| |
| --- SQL operation complete. |
| >>comment on column t072sch_comment.t072t1.col3 is 'This is a Modified time 02: This is a T03 column comment of table.' ; |
| |
| --- SQL operation complete. |
| >>comment on column t072sch_comment.t072t1.col1 is 'This is a Modified comment: This is a T01 column comment of table.' ; |
| |
| --- SQL operation complete. |
| >>comment on column TRAFODION.t072sch_comment.t072t1.col2 is 'This is a Modified comment: This is a T02 column comment of table.' ; |
| |
| --- SQL operation complete. |
| >>comment on column TRAFODION.t072sch_comment.t072t1.col3 is 'This is a Modified time 03: This is a T03 column comment of table.' ; |
| |
| --- SQL operation complete. |
| >>comment on column t072sch_comment.t072t1.col3 is 'This is a Modified time 04: This is a T03 column comment of table.' ; |
| |
| --- SQL operation complete. |
| >>comment on column t072sch_comment.t072t1.col3 is 'This is a Modified time 05: This is a T03 column comment of table.' ; |
| |
| --- SQL operation complete. |
| >>comment on column TRAFODION.t072sch_comment.t072t1.col2 is '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' ; |
| |
| --- SQL operation complete. |
| >> |
| >>comment on column t072sch_comment.t072view1.col1 is 'This is a Modified comment: This is a V01 column comment of view.' ; |
| |
| --- SQL operation complete. |
| >>comment on column t072sch_comment.t072view1.col2 is 'This is a Modified comment: This is a V02 column comment of view.' ; |
| |
| --- SQL operation complete. |
| >>comment on column t072sch_comment.t072view1.col3 is 'This is a Modified big comment: ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' ; |
| |
| --- SQL operation complete. |
| >> |
| >> |
| >> |
| >>obey TEST072(showcomment); |
| >>-------------------------------------------------------------------------- |
| >> |
| >>select * from "_MD_".OBJECT_COMMENT_VIEW where schema_name = UPPER('t072sch_comment'); |
| |
| CATALOG_NAME SCHEMA_NAME OBJECT_NAME COMMENT |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| |
| TRAFODION T072SCH_COMMENT __SCHEMA__ This is a Modified comment: This is a comment of SCHEMA.这是一个schema的注释。 |
| TRAFODION T072SCH_COMMENT T072T1 This is a Modified comment: This is a comment of TABLE.这个是一个中文的table的注释。》》、…… |
| TRAFODION T072SCH_COMMENT T072IDX1 这个是修改过后的索引注释 |
| TRAFODION T072SCH_COMMENT T072VIEW1 This is a Modified time 04: This is a comment of VIEW.你好 |
| TRAFODION T072SCH_COMMENT T072DDL This is a Modified comment: This is a comment of C UDF library. |
| TRAFODION T072SCH_COMMENT T072JAR This is a Modified comment: This is a comment of Java SPJ library. |
| TRAFODION T072SCH_COMMENT T072FUNC This is a Modified big comment: nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnul |
| TRAFODION T072SCH_COMMENT T072SPJ This is a Modified comment: This is a comment of SPJ. |
| TRAFODION T072SCH_COMMENT T072SEQ This is a Modified comment: This is a comment of SEQUENCE. |
| |
| --- 9 row(s) selected. |
| >> |
| >>select * from "_MD_".COLUMN_COMMENT_VIEW where schema_name = UPPER('t072sch_comment'); |
| |
| CATALOG_NAME SCHEMA_NAME OBJECT_NAME COLUMN_NAME COMMENT |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| |
| TRAFODION T072SCH_COMMENT T072T1 COL1 This is a Modified comment: This is a T01 column comment of table. |
| TRAFODION T072SCH_COMMENT T072T1 COL2 ''''''''''''''''''''''''''''''''' |
| TRAFODION T072SCH_COMMENT T072T1 COL3 This is a Modified time 05: This is a T03 column comment of table. |
| TRAFODION T072SCH_COMMENT T072VIEW1 COL1 This is a Modified comment: This is a V01 column comment of view. |
| TRAFODION T072SCH_COMMENT T072VIEW1 COL2 This is a Modified comment: This is a V02 column comment of view. |
| TRAFODION T072SCH_COMMENT T072VIEW1 COL3 This is a Modified big comment: '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' |
| |
| --- 6 row(s) selected. |
| >> |
| >> |
| >>obey TEST072(showddl1); |
| >>-------------------------------------------------------------------------- |
| >> |
| >>showddl schema t072sch_comment; |
| |
| CREATE PRIVATE SCHEMA "TRAFODION"."T072SCH_COMMENT" AUTHORIZATION "DB__ROOT"; |
| |
| COMMENT ON SCHEMA TRAFODION.T072SCH_COMMENT IS |
| 'This is a Modified comment: This is a comment of SCHEMA.这是一个schema的注释。' |
| ; |
| |
| --- SQL operation complete. |
| >>showddl table t072sch_comment.t072t1; |
| |
| CREATE TABLE TRAFODION.T072SCH_COMMENT.T072T1 |
| ( |
| COL1 INT NO DEFAULT NOT NULL NOT DROPPABLE |
| , COL2 DECIMAL(10, 4) NO DEFAULT NOT NULL NOT |
| DROPPABLE |
| , COL3 VARCHAR(50) CHARACTER SET ISO88591 COLLATE |
| DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE |
| , PRIMARY KEY (COL1 ASC) |
| ) |
| ATTRIBUTES ALIGNED FORMAT |
| ; |
| |
| CREATE INDEX T072IDX1 ON TRAFODION.T072SCH_COMMENT.T072T1 |
| ( |
| COL1 ASC |
| , COL3 ASC |
| ) |
| ; |
| |
| COMMENT ON TABLE TRAFODION.T072SCH_COMMENT.T072T1 IS |
| 'This is a Modified comment: This is a comment of TABLE.这个是一个中文的table的注释。》》、……' |
| ; |
| |
| COMMENT ON COLUMN TRAFODION.T072SCH_COMMENT.T072T1.COL1 IS |
| 'This is a Modified comment: This is a T01 column comment of table.' ; |
| COMMENT ON COLUMN TRAFODION.T072SCH_COMMENT.T072T1.COL2 IS |
| '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' ; |
| COMMENT ON COLUMN TRAFODION.T072SCH_COMMENT.T072T1.COL3 IS |
| 'This is a Modified time 05: This is a T03 column comment of table.' ; |
| |
| COMMENT ON INDEX TRAFODION.T072SCH_COMMENT.T072IDX1 IS |
| '这个是修改过后的索引注释' ; |
| |
| --- SQL operation complete. |
| >>showddl table t072sch_comment.t072view1; |
| |
| CREATE VIEW TRAFODION.T072SCH_COMMENT.T072VIEW1 AS |
| SELECT TRAFODION.T072SCH_COMMENT.T072T1.COL1, |
| TRAFODION.T072SCH_COMMENT.T072T1.COL2, |
| TRAFODION.T072SCH_COMMENT.T072T1.COL3 FROM |
| TRAFODION.T072SCH_COMMENT.T072T1 ; |
| |
| COMMENT ON VIEW TRAFODION.T072SCH_COMMENT.T072VIEW1 IS |
| 'This is a Modified time 04: This is a comment of VIEW.你好' ; |
| |
| COMMENT ON COLUMN TRAFODION.T072SCH_COMMENT.T072VIEW1.COL1 IS |
| 'This is a Modified comment: This is a V01 column comment of view.' ; |
| COMMENT ON COLUMN TRAFODION.T072SCH_COMMENT.T072VIEW1.COL2 IS |
| 'This is a Modified comment: This is a V02 column comment of view.' ; |
| COMMENT ON COLUMN TRAFODION.T072SCH_COMMENT.T072VIEW1.COL3 IS |
| 'This is a Modified big comment: ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' |
| ; |
| |
| --- SQL operation complete. |
| >>showddl library t072sch_comment.t072ddl; |
| CREATE LIBRARY TRAFODION.T072SCH_COMMENT.T072DDL FILE '$rundir/compGeneral/TEST072.dll' |
| ; |
| |
| COMMENT ON LIBRARY TRAFODION.T072SCH_COMMENT.T072DDL IS |
| 'This is a Modified comment: This is a comment of C UDF library.' ; |
| |
| --- SQL operation complete. |
| >>showddl library t072sch_comment.t072jar; |
| CREATE LIBRARY TRAFODION.T072SCH_COMMENT.T072JAR FILE '$rundir/compGeneral/TEST072.jar' |
| ; |
| |
| COMMENT ON LIBRARY TRAFODION.T072SCH_COMMENT.T072JAR IS |
| 'This is a Modified comment: This is a comment of Java SPJ library.' ; |
| |
| --- SQL operation complete. |
| >>showddl function t072sch_comment.t072func; |
| |
| CREATE FUNCTION TRAFODION.T072SCH_COMMENT.T072FUNC |
| ( |
| IN INTEGER SIGNED |
| , IN INTEGER SIGNED |
| ) |
| RETURNS |
| ( |
| OUT ADD2 INTEGER SIGNED |
| ) |
| EXTERNAL NAME 'add2' |
| LIBRARY TRAFODION.T072SCH_COMMENT.T072DDL |
| LANGUAGE C |
| PARAMETER STYLE SQL |
| NO SQL |
| NO FINAL CALL |
| NO STATE AREA |
| ALLOW ANY PARALLELISM |
| DETERMINISTIC |
| SAFE EXECUTION MODE |
| ; |
| |
| COMMENT ON FUNCTION TRAFODION.T072SCH_COMMENT.T072FUNC IS |
| 'This is a Modified big comment: nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnul' |
| ; |
| |
| --- SQL operation complete. |
| >>showddl procedure t072sch_comment.t072spj; |
| |
| CREATE PROCEDURE TRAFODION.T072SCH_COMMENT.T072SPJ |
| ( |
| ) |
| EXTERNAL NAME 'TEST072.testMoreResultSet (java.sql.ResultSet[],java.sql.ResultSet[],java.sql.ResultSet[],java.sql.ResultSet[],java.sql.ResultSet[])' |
| LIBRARY TRAFODION.T072SCH_COMMENT.T072JAR |
| EXTERNAL SECURITY INVOKER |
| LANGUAGE JAVA |
| PARAMETER STYLE JAVA |
| READS SQL DATA |
| DYNAMIC RESULT SETS 5 |
| TRANSACTION REQUIRED |
| ISOLATE |
| ; |
| |
| COMMENT ON PROCEDURE TRAFODION.T072SCH_COMMENT.T072SPJ IS |
| 'This is a Modified comment: This is a comment of SPJ.' ; |
| |
| --- SQL operation complete. |
| >>showddl sequence t072sch_comment.t072seq; |
| |
| CREATE SEQUENCE TRAFODION.T072SCH_COMMENT.T072SEQ |
| START WITH 1 /* NEXT AVAILABLE VALUE 1 */ |
| INCREMENT BY 1 |
| MAXVALUE 10000 |
| MINVALUE 1 |
| CACHE 20 |
| NO CYCLE |
| LARGEINT |
| ; |
| |
| COMMENT ON SEQUENCE TRAFODION.T072SCH_COMMENT.T072SEQ IS |
| 'This is a Modified comment: This is a comment of SEQUENCE.' ; |
| |
| --- SQL operation complete. |
| >> |
| >> |
| >> |
| >>obey TEST072(comment03); |
| >>-------------------------------------------------------------------------- |
| >> |
| >>--COMMENTS MAINTAIN WITH COLUMN ALTERED |
| >>alter table t072sch_comment.t072t1 add column col4 int ; |
| |
| --- SQL operation complete. |
| >>alter table t072sch_comment.t072t1 add column col5 int ; |
| |
| --- SQL operation complete. |
| >> |
| >>drop view t072sch_comment.t072view1; |
| |
| --- SQL operation complete. |
| >>comment on column t072sch_comment.t072t1.col5 is 'This is a new column added by alter cmd' ; |
| |
| --- SQL operation complete. |
| >> |
| >>alter table t072sch_comment.t072t1 drop column col2 ; |
| |
| --- SQL operation complete. |
| >> |
| >> |
| >> |
| >>obey TEST072(showcomment); |
| >>-------------------------------------------------------------------------- |
| >> |
| >>select * from "_MD_".OBJECT_COMMENT_VIEW where schema_name = UPPER('t072sch_comment'); |
| |
| CATALOG_NAME SCHEMA_NAME OBJECT_NAME COMMENT |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| |
| TRAFODION T072SCH_COMMENT __SCHEMA__ This is a Modified comment: This is a comment of SCHEMA.这是一个schema的注释。 |
| TRAFODION T072SCH_COMMENT T072T1 This is a Modified comment: This is a comment of TABLE.这个是一个中文的table的注释。》》、…… |
| TRAFODION T072SCH_COMMENT T072IDX1 这个是修改过后的索引注释 |
| TRAFODION T072SCH_COMMENT T072DDL This is a Modified comment: This is a comment of C UDF library. |
| TRAFODION T072SCH_COMMENT T072JAR This is a Modified comment: This is a comment of Java SPJ library. |
| TRAFODION T072SCH_COMMENT T072FUNC This is a Modified big comment: nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnul |
| TRAFODION T072SCH_COMMENT T072SPJ This is a Modified comment: This is a comment of SPJ. |
| TRAFODION T072SCH_COMMENT T072SEQ This is a Modified comment: This is a comment of SEQUENCE. |
| |
| --- 8 row(s) selected. |
| >> |
| >>select * from "_MD_".COLUMN_COMMENT_VIEW where schema_name = UPPER('t072sch_comment'); |
| |
| CATALOG_NAME SCHEMA_NAME OBJECT_NAME COLUMN_NAME COMMENT |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| |
| TRAFODION T072SCH_COMMENT T072T1 COL1 This is a Modified comment: This is a T01 column comment of table. |
| TRAFODION T072SCH_COMMENT T072T1 COL3 This is a Modified time 05: This is a T03 column comment of table. |
| TRAFODION T072SCH_COMMENT T072T1 COL5 This is a new column added by alter cmd |
| |
| --- 3 row(s) selected. |
| >> |
| >> |
| >>obey TEST072(showddl2); |
| >>-------------------------------------------------------------------------- |
| >> |
| >>showddl schema t072sch_comment; |
| |
| CREATE PRIVATE SCHEMA "TRAFODION"."T072SCH_COMMENT" AUTHORIZATION "DB__ROOT"; |
| |
| COMMENT ON SCHEMA TRAFODION.T072SCH_COMMENT IS |
| 'This is a Modified comment: This is a comment of SCHEMA.这是一个schema的注释。' |
| ; |
| |
| --- SQL operation complete. |
| >>showddl table t072sch_comment.t072t1; |
| |
| CREATE TABLE TRAFODION.T072SCH_COMMENT.T072T1 |
| ( |
| COL1 INT NO DEFAULT NOT NULL NOT DROPPABLE |
| , COL3 VARCHAR(50) CHARACTER SET ISO88591 COLLATE |
| DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE |
| , COL4 INT DEFAULT NULL /*added_col*/ |
| , COL5 INT DEFAULT NULL /*added_col*/ |
| , PRIMARY KEY (COL1 ASC) |
| ) |
| ATTRIBUTES ALIGNED FORMAT |
| ; |
| |
| CREATE INDEX T072IDX1 ON TRAFODION.T072SCH_COMMENT.T072T1 |
| ( |
| COL1 ASC |
| , COL3 ASC |
| ) |
| ; |
| |
| COMMENT ON TABLE TRAFODION.T072SCH_COMMENT.T072T1 IS |
| 'This is a Modified comment: This is a comment of TABLE.这个是一个中文的table的注释。》》、……' |
| ; |
| |
| COMMENT ON COLUMN TRAFODION.T072SCH_COMMENT.T072T1.COL1 IS |
| 'This is a Modified comment: This is a T01 column comment of table.' ; |
| COMMENT ON COLUMN TRAFODION.T072SCH_COMMENT.T072T1.COL3 IS |
| 'This is a Modified time 05: This is a T03 column comment of table.' ; |
| COMMENT ON COLUMN TRAFODION.T072SCH_COMMENT.T072T1.COL5 IS |
| 'This is a new column added by alter cmd' ; |
| |
| COMMENT ON INDEX TRAFODION.T072SCH_COMMENT.T072IDX1 IS |
| '这个是修改过后的索引注释' ; |
| |
| --- SQL operation complete. |
| >>showddl library t072sch_comment.t072ddl; |
| CREATE LIBRARY TRAFODION.T072SCH_COMMENT.T072DDL FILE '$rundir/compGeneral/TEST072.dll' |
| ; |
| |
| COMMENT ON LIBRARY TRAFODION.T072SCH_COMMENT.T072DDL IS |
| 'This is a Modified comment: This is a comment of C UDF library.' ; |
| |
| --- SQL operation complete. |
| >>showddl library t072sch_comment.t072jar; |
| CREATE LIBRARY TRAFODION.T072SCH_COMMENT.T072JAR FILE '$rundir/compGeneral/TEST072.jar' |
| ; |
| |
| COMMENT ON LIBRARY TRAFODION.T072SCH_COMMENT.T072JAR IS |
| 'This is a Modified comment: This is a comment of Java SPJ library.' ; |
| |
| --- SQL operation complete. |
| >>showddl function t072sch_comment.t072func; |
| |
| CREATE FUNCTION TRAFODION.T072SCH_COMMENT.T072FUNC |
| ( |
| IN INTEGER SIGNED |
| , IN INTEGER SIGNED |
| ) |
| RETURNS |
| ( |
| OUT ADD2 INTEGER SIGNED |
| ) |
| EXTERNAL NAME 'add2' |
| LIBRARY TRAFODION.T072SCH_COMMENT.T072DDL |
| LANGUAGE C |
| PARAMETER STYLE SQL |
| NO SQL |
| NO FINAL CALL |
| NO STATE AREA |
| ALLOW ANY PARALLELISM |
| DETERMINISTIC |
| SAFE EXECUTION MODE |
| ; |
| |
| COMMENT ON FUNCTION TRAFODION.T072SCH_COMMENT.T072FUNC IS |
| 'This is a Modified big comment: nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnul' |
| ; |
| |
| --- SQL operation complete. |
| >>showddl procedure t072sch_comment.t072spj; |
| |
| CREATE PROCEDURE TRAFODION.T072SCH_COMMENT.T072SPJ |
| ( |
| ) |
| EXTERNAL NAME 'TEST072.testMoreResultSet (java.sql.ResultSet[],java.sql.ResultSet[],java.sql.ResultSet[],java.sql.ResultSet[],java.sql.ResultSet[])' |
| LIBRARY TRAFODION.T072SCH_COMMENT.T072JAR |
| EXTERNAL SECURITY INVOKER |
| LANGUAGE JAVA |
| PARAMETER STYLE JAVA |
| READS SQL DATA |
| DYNAMIC RESULT SETS 5 |
| TRANSACTION REQUIRED |
| ISOLATE |
| ; |
| |
| COMMENT ON PROCEDURE TRAFODION.T072SCH_COMMENT.T072SPJ IS |
| 'This is a Modified comment: This is a comment of SPJ.' ; |
| |
| --- SQL operation complete. |
| >>showddl sequence t072sch_comment.t072seq; |
| |
| CREATE SEQUENCE TRAFODION.T072SCH_COMMENT.T072SEQ |
| START WITH 1 /* NEXT AVAILABLE VALUE 1 */ |
| INCREMENT BY 1 |
| MAXVALUE 10000 |
| MINVALUE 1 |
| CACHE 20 |
| NO CYCLE |
| LARGEINT |
| ; |
| |
| COMMENT ON SEQUENCE TRAFODION.T072SCH_COMMENT.T072SEQ IS |
| 'This is a Modified comment: This is a comment of SEQUENCE.' ; |
| |
| --- SQL operation complete. |
| >> |
| >> |
| >> |
| >>obey TEST072(comment04); |
| >>-------------------------------------------------------------------------- |
| >> |
| >>--DROP COMMENTS |
| >>comment on table t072sch_comment.t072t1 is '' ; |
| |
| --- SQL operation complete. |
| >>comment on index t072sch_comment.t072idx1 is '' ; |
| |
| --- SQL operation complete. |
| >>comment on library t072sch_comment.t072jar is '' ; |
| |
| --- SQL operation complete. |
| >>comment on function t072sch_comment.t072func is '' ; |
| |
| --- SQL operation complete. |
| >>comment on procedure t072sch_comment.t072spj is '' ; |
| |
| --- SQL operation complete. |
| >> |
| >>comment on column t072sch_comment.t072t1.col1 is '' ; |
| |
| --- SQL operation complete. |
| >> |
| >> |
| >> |
| >>obey TEST072(showcomment); |
| >>-------------------------------------------------------------------------- |
| >> |
| >>select * from "_MD_".OBJECT_COMMENT_VIEW where schema_name = UPPER('t072sch_comment'); |
| |
| CATALOG_NAME SCHEMA_NAME OBJECT_NAME COMMENT |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| |
| TRAFODION T072SCH_COMMENT __SCHEMA__ This is a Modified comment: This is a comment of SCHEMA.这是一个schema的注释。 |
| TRAFODION T072SCH_COMMENT T072DDL This is a Modified comment: This is a comment of C UDF library. |
| TRAFODION T072SCH_COMMENT T072SEQ This is a Modified comment: This is a comment of SEQUENCE. |
| |
| --- 3 row(s) selected. |
| >> |
| >>select * from "_MD_".COLUMN_COMMENT_VIEW where schema_name = UPPER('t072sch_comment'); |
| |
| CATALOG_NAME SCHEMA_NAME OBJECT_NAME COLUMN_NAME COMMENT |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| |
| TRAFODION T072SCH_COMMENT T072T1 COL3 This is a Modified time 05: This is a T03 column comment of table. |
| TRAFODION T072SCH_COMMENT T072T1 COL5 This is a new column added by alter cmd |
| |
| --- 2 row(s) selected. |
| >> |
| >> |
| >>obey TEST072(showddl2); |
| >>-------------------------------------------------------------------------- |
| >> |
| >>showddl schema t072sch_comment; |
| |
| CREATE PRIVATE SCHEMA "TRAFODION"."T072SCH_COMMENT" AUTHORIZATION "DB__ROOT"; |
| |
| COMMENT ON SCHEMA TRAFODION.T072SCH_COMMENT IS |
| 'This is a Modified comment: This is a comment of SCHEMA.这是一个schema的注释。' |
| ; |
| |
| --- SQL operation complete. |
| >>showddl table t072sch_comment.t072t1; |
| |
| CREATE TABLE TRAFODION.T072SCH_COMMENT.T072T1 |
| ( |
| COL1 INT NO DEFAULT NOT NULL NOT DROPPABLE |
| , COL3 VARCHAR(50) CHARACTER SET ISO88591 COLLATE |
| DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE |
| , COL4 INT DEFAULT NULL /*added_col*/ |
| , COL5 INT DEFAULT NULL /*added_col*/ |
| , PRIMARY KEY (COL1 ASC) |
| ) |
| ATTRIBUTES ALIGNED FORMAT |
| ; |
| |
| CREATE INDEX T072IDX1 ON TRAFODION.T072SCH_COMMENT.T072T1 |
| ( |
| COL1 ASC |
| , COL3 ASC |
| ) |
| ; |
| |
| COMMENT ON COLUMN TRAFODION.T072SCH_COMMENT.T072T1.COL3 IS |
| 'This is a Modified time 05: This is a T03 column comment of table.' ; |
| COMMENT ON COLUMN TRAFODION.T072SCH_COMMENT.T072T1.COL5 IS |
| 'This is a new column added by alter cmd' ; |
| |
| --- SQL operation complete. |
| >>showddl library t072sch_comment.t072ddl; |
| CREATE LIBRARY TRAFODION.T072SCH_COMMENT.T072DDL FILE '$rundir/compGeneral/TEST072.dll' |
| ; |
| |
| COMMENT ON LIBRARY TRAFODION.T072SCH_COMMENT.T072DDL IS |
| 'This is a Modified comment: This is a comment of C UDF library.' ; |
| |
| --- SQL operation complete. |
| >>showddl library t072sch_comment.t072jar; |
| CREATE LIBRARY TRAFODION.T072SCH_COMMENT.T072JAR FILE '$rundir/compGeneral/TEST072.jar' |
| ; |
| |
| --- SQL operation complete. |
| >>showddl function t072sch_comment.t072func; |
| |
| CREATE FUNCTION TRAFODION.T072SCH_COMMENT.T072FUNC |
| ( |
| IN INTEGER SIGNED |
| , IN INTEGER SIGNED |
| ) |
| RETURNS |
| ( |
| OUT ADD2 INTEGER SIGNED |
| ) |
| EXTERNAL NAME 'add2' |
| LIBRARY TRAFODION.T072SCH_COMMENT.T072DDL |
| LANGUAGE C |
| PARAMETER STYLE SQL |
| NO SQL |
| NO FINAL CALL |
| NO STATE AREA |
| ALLOW ANY PARALLELISM |
| DETERMINISTIC |
| SAFE EXECUTION MODE |
| ; |
| |
| --- SQL operation complete. |
| >>showddl procedure t072sch_comment.t072spj; |
| |
| CREATE PROCEDURE TRAFODION.T072SCH_COMMENT.T072SPJ |
| ( |
| ) |
| EXTERNAL NAME 'TEST072.testMoreResultSet (java.sql.ResultSet[],java.sql.ResultSet[],java.sql.ResultSet[],java.sql.ResultSet[],java.sql.ResultSet[])' |
| LIBRARY TRAFODION.T072SCH_COMMENT.T072JAR |
| EXTERNAL SECURITY INVOKER |
| LANGUAGE JAVA |
| PARAMETER STYLE JAVA |
| READS SQL DATA |
| DYNAMIC RESULT SETS 5 |
| TRANSACTION REQUIRED |
| ISOLATE |
| ; |
| |
| --- SQL operation complete. |
| >>showddl sequence t072sch_comment.t072seq; |
| |
| CREATE SEQUENCE TRAFODION.T072SCH_COMMENT.T072SEQ |
| START WITH 1 /* NEXT AVAILABLE VALUE 1 */ |
| INCREMENT BY 1 |
| MAXVALUE 10000 |
| MINVALUE 1 |
| CACHE 20 |
| NO CYCLE |
| LARGEINT |
| ; |
| |
| COMMENT ON SEQUENCE TRAFODION.T072SCH_COMMENT.T072SEQ IS |
| 'This is a Modified comment: This is a comment of SEQUENCE.' ; |
| |
| --- SQL operation complete. |
| >> |
| >> |
| >> |
| >>obey TEST072(comment05); |
| >>-------------------------------------------------------------------------- |
| >> |
| >>--COMMENT FAILURES |
| >>comment on schema non_existing is 'TEST' ; |
| |
| *** ERROR[1389] Object TRAFODION.NON_EXISTING."__SCHEMA__" does not exist in Trafodion. |
| |
| --- SQL operation failed with errors. |
| >>comment on table non_existing is 'TEST' ; |
| |
| *** ERROR[1389] Object TRAFODION.SCH.NON_EXISTING does not exist in Trafodion. |
| |
| --- SQL operation failed with errors. |
| >>comment on index non_existing is 'TEST' ; |
| |
| *** ERROR[1389] Object TRAFODION.SCH.NON_EXISTING does not exist in Trafodion. |
| |
| --- SQL operation failed with errors. |
| >>comment on view non_existing is 'TEST' ; |
| |
| *** ERROR[1389] Object TRAFODION.SCH.NON_EXISTING does not exist in Trafodion. |
| |
| --- SQL operation failed with errors. |
| >>comment on library non_existing is 'TEST' ; |
| |
| *** ERROR[1389] Object TRAFODION.SCH.NON_EXISTING does not exist in Trafodion. |
| |
| --- SQL operation failed with errors. |
| >>comment on function non_existing is 'TEST' ; |
| |
| *** ERROR[1389] Object TRAFODION.SCH.NON_EXISTING does not exist in Trafodion. |
| |
| --- SQL operation failed with errors. |
| >>comment on sequence non_exsiting is 'TEST' ; |
| |
| *** ERROR[1389] Object TRAFODION.SCH.NON_EXSITING does not exist in Trafodion. |
| |
| --- SQL operation failed with errors. |
| >>comment on column non_existing.col is 'TEST' ; |
| |
| *** ERROR[4082] Object TRAFODION.SCH.NON_EXISTING does not exist or is inaccessible. |
| |
| *** ERROR[4082] Object TRAFODION.SCH.NON_EXISTING does not exist or is inaccessible. |
| |
| --- SQL operation failed with errors. |
| >>comment on column t072sch_comment.t072t1.non_existing is 'TEST' ; |
| |
| *** ERROR[1009] Column NON_EXISTING does not exist in the specified table. |
| |
| --- SQL operation failed with errors. |
| >> |
| >>comment on table t072sch_comment.t072t1 is 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' ; |
| |
| *** ERROR[8402] A string overflow occurred during the evaluation of a character expression. |
| |
| --- SQL operation failed with errors. |
| >> --length 1001 |
| >> |
| >> |
| >> |
| >>obey TEST072(showcomment); |
| >>-------------------------------------------------------------------------- |
| >> |
| >>select * from "_MD_".OBJECT_COMMENT_VIEW where schema_name = UPPER('t072sch_comment'); |
| |
| CATALOG_NAME SCHEMA_NAME OBJECT_NAME COMMENT |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| |
| TRAFODION T072SCH_COMMENT __SCHEMA__ This is a Modified comment: This is a comment of SCHEMA.这是一个schema的注释。 |
| TRAFODION T072SCH_COMMENT T072DDL This is a Modified comment: This is a comment of C UDF library. |
| TRAFODION T072SCH_COMMENT T072SEQ This is a Modified comment: This is a comment of SEQUENCE. |
| |
| --- 3 row(s) selected. |
| >> |
| >>select * from "_MD_".COLUMN_COMMENT_VIEW where schema_name = UPPER('t072sch_comment'); |
| |
| CATALOG_NAME SCHEMA_NAME OBJECT_NAME COLUMN_NAME COMMENT |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| |
| TRAFODION T072SCH_COMMENT T072T1 COL3 This is a Modified time 05: This is a T03 column comment of table. |
| TRAFODION T072SCH_COMMENT T072T1 COL5 This is a new column added by alter cmd |
| |
| --- 2 row(s) selected. |
| >> |
| >> |
| >>obey TEST072(showddl2); |
| >>-------------------------------------------------------------------------- |
| >> |
| >>showddl schema t072sch_comment; |
| |
| CREATE PRIVATE SCHEMA "TRAFODION"."T072SCH_COMMENT" AUTHORIZATION "DB__ROOT"; |
| |
| COMMENT ON SCHEMA TRAFODION.T072SCH_COMMENT IS |
| 'This is a Modified comment: This is a comment of SCHEMA.这是一个schema的注释。' |
| ; |
| |
| --- SQL operation complete. |
| >>showddl table t072sch_comment.t072t1; |
| |
| CREATE TABLE TRAFODION.T072SCH_COMMENT.T072T1 |
| ( |
| COL1 INT NO DEFAULT NOT NULL NOT DROPPABLE |
| , COL3 VARCHAR(50) CHARACTER SET ISO88591 COLLATE |
| DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE |
| , COL4 INT DEFAULT NULL /*added_col*/ |
| , COL5 INT DEFAULT NULL /*added_col*/ |
| , PRIMARY KEY (COL1 ASC) |
| ) |
| ATTRIBUTES ALIGNED FORMAT |
| ; |
| |
| CREATE INDEX T072IDX1 ON TRAFODION.T072SCH_COMMENT.T072T1 |
| ( |
| COL1 ASC |
| , COL3 ASC |
| ) |
| ; |
| |
| COMMENT ON COLUMN TRAFODION.T072SCH_COMMENT.T072T1.COL3 IS |
| 'This is a Modified time 05: This is a T03 column comment of table.' ; |
| COMMENT ON COLUMN TRAFODION.T072SCH_COMMENT.T072T1.COL5 IS |
| 'This is a new column added by alter cmd' ; |
| |
| --- SQL operation complete. |
| >>showddl library t072sch_comment.t072ddl; |
| CREATE LIBRARY TRAFODION.T072SCH_COMMENT.T072DDL FILE '$rundir/compGeneral/TEST072.dll' |
| ; |
| |
| COMMENT ON LIBRARY TRAFODION.T072SCH_COMMENT.T072DDL IS |
| 'This is a Modified comment: This is a comment of C UDF library.' ; |
| |
| --- SQL operation complete. |
| >>showddl library t072sch_comment.t072jar; |
| CREATE LIBRARY TRAFODION.T072SCH_COMMENT.T072JAR FILE '$rundir/compGeneral/TEST072.jar' |
| ; |
| |
| --- SQL operation complete. |
| >>showddl function t072sch_comment.t072func; |
| |
| CREATE FUNCTION TRAFODION.T072SCH_COMMENT.T072FUNC |
| ( |
| IN INTEGER SIGNED |
| , IN INTEGER SIGNED |
| ) |
| RETURNS |
| ( |
| OUT ADD2 INTEGER SIGNED |
| ) |
| EXTERNAL NAME 'add2' |
| LIBRARY TRAFODION.T072SCH_COMMENT.T072DDL |
| LANGUAGE C |
| PARAMETER STYLE SQL |
| NO SQL |
| NO FINAL CALL |
| NO STATE AREA |
| ALLOW ANY PARALLELISM |
| DETERMINISTIC |
| SAFE EXECUTION MODE |
| ; |
| |
| --- SQL operation complete. |
| >>showddl procedure t072sch_comment.t072spj; |
| |
| CREATE PROCEDURE TRAFODION.T072SCH_COMMENT.T072SPJ |
| ( |
| ) |
| EXTERNAL NAME 'TEST072.testMoreResultSet (java.sql.ResultSet[],java.sql.ResultSet[],java.sql.ResultSet[],java.sql.ResultSet[],java.sql.ResultSet[])' |
| LIBRARY TRAFODION.T072SCH_COMMENT.T072JAR |
| EXTERNAL SECURITY INVOKER |
| LANGUAGE JAVA |
| PARAMETER STYLE JAVA |
| READS SQL DATA |
| DYNAMIC RESULT SETS 5 |
| TRANSACTION REQUIRED |
| ISOLATE |
| ; |
| |
| --- SQL operation complete. |
| >>showddl sequence t072sch_comment.t072seq; |
| |
| CREATE SEQUENCE TRAFODION.T072SCH_COMMENT.T072SEQ |
| START WITH 1 /* NEXT AVAILABLE VALUE 1 */ |
| INCREMENT BY 1 |
| MAXVALUE 10000 |
| MINVALUE 1 |
| CACHE 20 |
| NO CYCLE |
| LARGEINT |
| ; |
| |
| COMMENT ON SEQUENCE TRAFODION.T072SCH_COMMENT.T072SEQ IS |
| 'This is a Modified comment: This is a comment of SEQUENCE.' ; |
| |
| --- SQL operation complete. |
| >> |
| >> |
| >> |
| >>obey TEST072(clnup); |
| >>-------------------------------------------------------------------------- |
| >> |
| >>-- CLEANUP database |
| >>drop schema IF EXISTS t072sch_comment cascade; |
| |
| --- SQL operation complete. |
| >> |
| >>obey TEST072(showcomment); |
| >>-------------------------------------------------------------------------- |
| >> |
| >>select * from "_MD_".OBJECT_COMMENT_VIEW where schema_name = UPPER('t072sch_comment'); |
| |
| --- 0 row(s) selected. |
| >> |
| >>select * from "_MD_".COLUMN_COMMENT_VIEW where schema_name = UPPER('t072sch_comment'); |
| |
| --- 0 row(s) selected. |
| >> |
| >> |
| >> |
| >>exit; |
| |
| End of MXCI Session |
| |