Using Siebel Tools > Using Workspaces in Siebel Tools > Workspaces Administration >

Publishing Tables

Tables can also be published into the S_RR_TABLE table using the same concept by which other metadata objects are published into the report repository table. A table maintains a different version number and it is tracked from the S_RR_OBJ_ITEM.TBL_VER column.

However, table versioning is different from other metadata versioning because a table is not workspace-enabled. While performing the Full Publish process, the table version is always 0 (zero), irrespective of the workspace version.

A table can be published in two ways using Siebel Tools in a Windows environment:

• Using the Apply/DDL button.
• Using the siebdev.exe utility.

Publishing Table in the Source-to-Target Migration

In the source environment, a table needs to be published either by using the Apply/DDL button or by running the siebdev.exe utility command.

In the target environment, publishing a table is generated by the Incremental/Full source-to-target runtime repository migration. Hence, a table should not be published explicitly in the target environment.

To publish a table using the Apply/DDL button in Siebel Tools

1. In Siebel Tools, update the required table schema changes as needed.
2. Search for the table that you want to publish.

   Siebel Tools now displays a list of table row records.

   This example shows the Siebel Tools window displaying the table row records after you perform the table search. The Apply/DDL button is available after the table header.
3. Click the Apply/DDL button.

   The Choose Option window appears enabling you to select the action to either apply the schema changes to the database or create the DDL file.

4. Select either the Apply or the Generate DDL option, and click the OK button to return to Siebel Tools.
   • If you select the Apply option, then the Apply Schema window appears, enabling you to specify the details of table, database, and DDL. After you click the OK button, the schema is applied to the tables and the tables are republished with the next version number. The table compiled-object definitions are present in the S_RR_TABLE table in the next table version, and the list of effected tables is present in the S_RR_OBJ_ITEM table.
   • If you select the Generate DDL option and click the OK button, the table will not be published but it will generate the DDL in the specified location.

To publish a table using the siebdev.exe utility in Siebel Tools

1. Open the Command Prompt window from your computer by clicking the Start button and then selecting the Run option.
2. In the Run window, enter the value CMD in the Open field.
3. In the Command Prompt window, run the following siebdev.exe utility command:

   siebdev /c tools.cfg /l <LANG> /d <odbcdatasource> /u <username> /p <password> /IncrementalTablePublish <FileName>

   The contents of <FileName> can be <TableName>:<Operation> where the operation can be Insert, Update, or Delete. These are the examples of the ddl_TableSchema.txt:

   • S_RR_OBJ_VER:Update
   • S_RR_TEST1:Insert
   • S_RR_TEST2:Delete

NOTE:  The ddl_TableSchema.txt file is always auto-generated when the schema is applied using DDLIMP. This file is generated in the same location as the log file under the file name <log_File_Name>_TableSchema.txt. The name of the generated file cannot be changed.