Table Of Contents

Executing createtables.sql

Executing createtables.sql

---

You can create tables in CEPM database by executing createtables.sql file in the following manner:

For Oracle -

You can find this script in CEPM-V3.3.0.0\db\scripts\oracle folder. While executing this script in Oracle, the process prompts you to enter the necessary parameters such as <DNAME>, <DBNAME>, <URL>, <INSTNAME>, <INSTPASSWD> etc. On entering the correct values, the script is executed successfully which yields in creation of the required tables.

For MSSQL -

You can find createtables.sql file in CEPM-V3.3.0.0\db\scripts\mssql folder. Following steps must be taken before executing this script in MSSQL:

- Open createtables.sql file.

- Update the EXEC INSERT_PR procedure by passing the input parameters in the following pattern:

EXEC INSERT_PR <DNAME>,<DBNAME>,<URL>,<INSTNAME>,<INSTPASSWD> ;

Where,

<DNAME> refers to domain (entitlement repository) name to be created for which the tables are created.

<DBNAME> refers to the name of the DB instance.

<URL> refers to the IP address and port number of the machine where MSSQL DB is running.

<INSTNAME> refers to the user ID to access the DB.

<INSTPASSWD> refers to the encrypted password.

Following is a sample EXEC INSERT_PR procedure -

EXEC INSERT_PR 'Default Domain','testcepm','64.103.170.29','testcepm','adgf@#$' ;

- Save and close the file.

- Execute it.

For DB2 -

You can find createtables.sql file in CEPM-V3.3.0.0\db\scripts\db2 folder. Following steps must be taken before execution of this script in DB2:

- Open the createtables.sql file.

- Update the CALL INSERT_PR procedure by passing the input parameters in the following pattern:

CALL INSERT_PR <DNAME>,<DBNAME>,<URL>,<INSTNAME>,<INSTPASSWD> ;

Where,

<DNAME> refers to the domain (entitlement repository) name to be created for which the tables are created.

<DBNAME> refers to the name of the DB instance.

<URL> refers to the IP address and port number of the machine where DB2 database is running.

<INSTNAME> refers to the user ID to access the DB.

<INSTPASSWD> refers to the encrypted password.

Following is a sample EXEC INSERT_PR procedure -

CALL INSERT_PR ( 'Default Domain','testcepm','64.103.170.29','testcepm','adgf@#$' );

- Save and close the file.

- Execute it.

---