D.3 Points to be considered when setting up SQL script file
Following are the points to be considered when setting up SQL script file. If the following points are violated, operation is not guaranteed.
-
You cannot change column names, data type and constraint keys of all tables, as shown below. You cannot change the order of columns.
- (Example)
-
Column name: CSC_SERVER_NAME, CSC_SERVER_STATUS, etc.
Data type: VARCHAR2(8), NUMBER(10,0), etc.
Constraint key: NOT NULL specification, UNIQUE specification, etc.
-
You cannot change the order of table or index creation.
-
You cannot delete the indexes, view table and tables defined in template. If you delete or if you wrongly replace <individualname>, error occurs at the time of setting up HCSC server.
-
You can add column in view table only when you use the horizontal split function. Also, make sure that the definition contents of the column to be added match with "Appendix C.1 Table information about process instance execution log management.
-
The contents mentioned between "/*" and "*/" are considered as comments and are deleted at the time of issuing SQL.
-
You cannot use simple comment (comment starting with "--". If you use such comments, normal operation is not guaranteed.
-
You cannot use quotation marks (" and '). If you use quotation marks, operation is not guaranteed.