Titile Stacking?

Database
Enthusiast

Titile Stacking?

Hello Experts,

Can some please explain what is meant by Title Stacking? I came acorss a question asking "Does the AS Clause allow title stacking'?

Thanks

5 REPLIES
Senior Apprentice

Re: Titile Stacking?

This is/was used for reports in BTEQ, two slashes in the TITLE result in a linebreak, you can do the same using AS:

select 'bla' as "long//column//title";

*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.

long
column
title
------
bla

Dieter

Enthusiast

Re: Titile Stacking?

Hi,

Dieter is very right. I would like to add that the same can be acheived using the same statement in both BTEQ & SQL Assistant as well.

Khurram

Khurram
Enthusiast

Re: Titile Stacking?

Thank you for the swift response gentlemen!

Enthusiast

Re: Titile Stacking?

My apologies, I just passed through a teradata documentation and came to know that Title Stacking occurs only in BTEQ. In SQL Assistant it occures only due to column width. If we expand the column width the heading come into a single line. The older observation was just a test.

Khurram
Enthusiast

Re: Titile Stacking?

No worries Khurram. I figured out by referring to the below post.

http://bloghick.blog.com/2013/09/09/title-stacking/