All Forums Database
teraforsk 11 posts Joined 05/12
30 Aug 2013
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

dnoeth 4628 posts Joined 11/04
30 Aug 2013

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

Dieter

M.Saeed Khurram 544 posts Joined 09/12
31 Aug 2013

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

teraforsk 11 posts Joined 05/12
31 Aug 2013

Thank you for the swift response gentlemen!

M.Saeed Khurram 544 posts Joined 09/12
04 Sep 2013

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

teraforsk 11 posts Joined 05/12
09 Sep 2013

No worries Khurram. I figured out by referring to the below post.
http://bloghick.blog.com/2013/09/09/title-stacking/

You must sign in to leave a comment.