1. Database Upgrade Guide for DB2 for z/OS
  2. Fixing Column Alignment for Custom Objects

Fixing Column Alignment for Custom Objects

The Fixing Column Alignment for Custom Objects Utility sets the standard for list column header and data alignment based on type of fields they are mapped to across all Siebel applications.

The Fixing Column Alignment for Custom Objects Utility does the following:

  • List columns mapped to the Currency field type are aligned right (to the far edge of the column).

  • List columns having icon maps mapped to them are center aligned.

  • List columns mapped to a Numeric field type are center aligned

  • List columns mapped to a Boolean field (or CHAR(1)) type are center aligned.

  • List columns mapped to any other field type are left aligned (to the near edge of the column).

  • List columns data alignment will be same as its header alignment.

Left alignment is the default value for the data and header in list columns. HTML Width for list columns mapped to Date field type will be 185 by default.

The Fixing Column Alignment for Custom Objects Utility runs as part of the upgrade process. Use the procedures in this topic to manually run the Fixing Column Alignment for Custom Objects Utility.

Running the Fixing Column Alignment for Custom Objects Utility

  1. Navigate to the following directory:

    Windows: $DbsrvrRoot\common folder

    UNIX: $DbsrvrRoot\common folder

  2. Run the following command:

    java -jar alignapplet.jar /s [Siebel Tool/Server Path, one folder up BIN directory]
/c [DSN] /d [Database Type - Oracle, DB2UDB, MSSQL or DB2390 ] /u [Database User]
/p [Database Password]  /o [Log directory] /t [Table Owner] /v "Prior
Customer Repository" /r "New Siebel Repository" /x "New Customer Repository"

  3. Review the AllignApplet log and verify that AlignApplet ran without errors.

    Windows: $SiebelLogDir\AlignApplet.log

    UNIX: $SiebelLogDir/AlignApplet.log

  4. Review the AllignApplet reports to see the modified objects.

    • AlignApplet.log. A log of all the steps executed in this program.

    • AlignAppelt.html. A report detailing the modified objects.

    • AlignAppletLog.log. A folder that contains all the SQL logs executed during the column alignment process.