ReadVitamin

How To View/Display More Columns in BTEQ.

Written by admin in Tuesday, July 24th 2007 under IT

If you are using BTEQ for the first time and your table or view does have many columns, there is a possibility that you might not see all the columns present in your output/result set. The reason is simple; BTEQ has its default formatting for widths (75 characters by default) and that causes to limit the output. So how to capture all the columns into your output file? First increase the length or width of the default output by the following command.

.width <numeric figure>;

For example,.width 180; /* Note that this numeric value has to be in between 20 and 655321(both inclusive)*/

Next, use the TRIM function to take out the unwanted spaces from character fields. It is always a good practice to put a column heading/alias after you use any TRIM function. Your BTEQ script would look like the following;

.logon server name/username, password;

DATABASE <database name>;

.width 655321;

SELECT TRIM (column_1) alias_name1,

TRIM (column_2) alias_name2,

TRIM (column_3) alias_name3,

TRIM (column_4) alias_name4

FROM <database name>.<table name>

WHERE condition1

AND condition2

AND condition3;

.QUIT ERRORCODE;

If you would not use the column alias then you would see a lengthier display because TRIM function would add its description to the heading like; TRIM (BOTH FROM <COLUMN NAME>).

Popularity: 2% [?]