cancel
Showing results for 
Search instead for 
Did you mean: 

Column Heading more than 30 char

Former Member
0 Kudos

Hi,

In query template I am getting the column names dynamically, I want to show Alias instead of column names but in Oracle, column Alias has a limit of 30 char.

How can I show the Alias with more than 30 char in Query Template? I need to export the output of Query to Excel and HTML.

Thanks,

Anil

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Anil,

You could use an inline transform by applying an XSL stylesheet. You could specify the long alias in the stylesheet itself.

Alternatively, you could use a Business Logic Transaction. It has a Column Alias Action Block. The output of the Column Alias Action Block would be linked to a Transaction Output Property.

The data flow will be as follows:

Datasource - Query Template 1 - Transaction with Column Alias Action Block - Query Template 2 - Excel/HTML

Query Template 1 will be of Type SQL.

Query Template 2 will be of Type Xacute.

Cheers,

Jai.

jcgood25
Active Contributor
0 Kudos

Or you could avoid the additional overhead and craziness entirely by abbreviating the column names to fit within the 30 character DB restriction. 30 characters seems reasonable to me.

Regards,

Jeremy