Retrieving UDC Descriptions

You can add information to the end of the connection string that enables the JDBC driver to retrieve the UDC description for table columns that have an associated UDC. (Each table column is based on a data dictionary item, which could have a UDC assigned to it.)

The UDC description is retrieved in the language of the user who is building the query in BI Publisher. Without the UDC description, the report developer must know which table columns have UDCs associated with them. The report developer can override the column name while designing the report.

To display UDC descriptions, add UDSC=1 to the connection string. If the value is 0 or the UDSC tag is not in the connection string, UDC descriptions will not be retrieved from the database.

Note: Use a semicolon between tags when appending them to the connection string. For example, the following connection string shows the appended information for retrieving the table description, column description, and UDC description: jdbc:oracle:enterpriseone://JDV920;TDSC=1;CDSC=1;UDSC=1;