How to display all columns with betq command

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

How to display all columns with betq command

Rate Topic

Display Mode

Topic Options

Author

Message

floppy

Posted 4/27/2006 5:50:50 AM

Forum Newbie

Group: Forum Members
Last Login: 8/29/2008 9:02:15 AM
Posts: 1, Visits: 2

Hi,

i know the bteq command: .set width n (n=20~254) but if there a table has many columns and exceed the 254 character limit, how can i output all columns to the screen.

any help is appreciated.

thanks.

Post #4039

Jim Chapman

Posted 5/4/2006 10:46:05 AM

Supreme Being

Group: Forum Members
Last Login: Yesterday @ 7:10:35 PM
Posts: 224, Visits: 527

Use the ".set foldline on" command to allow BTEQ to fold a row across multiple lines. For a prettier format, also ".set sidetitles on".

Post #4112

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 1 ( 1 guest, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 8:18am