Output file question

Shell Programming and Scripting
1

I am running a shell script which executes a bteq script and the output of the BTEQ script is dumped in the standard output file. The output of the bteq execution is a table with 30 columns and the width of the output would be about 800 characters for each record.

My current output only shows 3 columns and i do not see the remaining 27 columns (I guess because the length of the record is above the limit). How do i increase the width of the output file so that i see all the columns in a record?

Thanks in advance.

2

can you post your shell script??

3

The script is very simple....I am running a sql script rec_dly_clms.txt on bteq and the standard output is captured in rec_out file. My output has long fields with 30 columns. This data does not fit in my output file and the data I see in my output file is truncated (only 3 columns, instead of 30).

echo "Script On"
bteq < rec_dly_clms.txt  > rec_out 
.set errorout STDOUT
.set width 600$
4

can you post your rec_dly_clms.txt content...