Need Column Name with Longer than 30 Characters

Database
Enthusiast

Need Column Name with Longer than 30 Characters

I am using Teradata SQL (version 13.10)  in cominbation with a "Text to XLS" program to create an Excel File.

This excel file replicates a template used to upload data into another system.  I have no control over the layout of the excel file.  Furthermore, the column headings (generated in the SQL) must be a 100% match, or the import fails.  One of these column names is 33 characters long.  

The example of below generates the same error I'm receiving.  I know that this version of Teradata (13.10) has a max column length of 30 characters.  

I'm wondering if there is a way to "trick" the system into allowing me to have more than 30 characters show in a column name.

select a.column_name as "this is a required 33 char string" 
from dbc.databases
where databasename like '%calendar%'

Thank you!

Lee

Tags (2)
4 REPLIES
Enthusiast

Re: Need Column Name with Longer than 30 Characters

select DATABASENAME AS "this is a required 33 char string"
from    dbc.databases
where   databasename like '%calendar%'

Result:

this is a required 33 char string
Sys_Calendar                 

Use double quotes instead of single quotes, it will treat like title instead of alias, Titles doesnt have 30 character limit i suppose

Teradata Employee

Re: Need Column Name with Longer than 30 Characters

Titles of up to 60 characters are allowed in 13.10, but titles are not column names. There is no way around this. You need to use the 14.10 Extended Object Names feature.

-Dave

Enthusiast

Re: Need Column Name with Longer than 30 Characters

Dave is correct. You need to utilize EON which is supported by 14.10. There is a DBS control flag which needs to be set and database restart is must.

Enthusiast

Re: Need Column Name with Longer than 30 Characters

Ah, I was afraid of that.  Thanks!