Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Output file question

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Output file question
# 1  
Old 07-01-2009
Output file question
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  
Old 07-01-2009
can you post your shell script??
# 3  
Old 07-01-2009
Script
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).

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

Last edited by Yogesh Sawant; 07-05-2009 at 10:51 AM.. Reason: added code tags
# 4  
Old 07-01-2009
can you post your rec_dly_clms.txt content...
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

output redirection to existing file question

So I have a existing file that I used the uniq command on and I need to save the output to the same file without changing the file name. I have tried $ uniq filename > filename then when I cat the file it then becomes blank like there is nothing inside. any help would be much appreciated... (0 Replies)
Discussion started by: drew211
0 Replies

2. UNIX for Dummies Questions & Answers

My question is all "03" records move to output file without changing

This is my input file 01,011600033,011600033,110516,0834,2,90,,2/ 02,011600033,011103093,1,110317,0834,,2/ 03,105581,,015,+00000416418,,,901,+00000000148,,,922,+00000000354,,/ 49,+00000000000416920,00002/ 03,113806,,015,+00000559618,,,901,+00000000096,,,922,+00000000621,,/... (1 Reply)
Discussion started by: sgoud
1 Replies

3. Shell Programming and Scripting

Command Output Question

Hi everyone-- I'm new to these forums and shell scripting, and I'm trying to write a script that checks if a particular ip is pingable My idea was to check if the output of the command ping <some ip> -c 1 -w 1 had the string: "1 packet transmitted, 1 received"How would I go about doing this?... (2 Replies)
Discussion started by: Prodiga1
2 Replies

4. Shell Programming and Scripting

SED-Question - OR and Output in new file

Hi i want connect several sed-commands with an OR and get the output in a new file. I thought it works with sed ... | sed ... | sed ... > file , but it doesn`t work. Can anyone help me? regards alex (4 Replies)
Discussion started by: alexander_
4 Replies

5. Shell Programming and Scripting

Dynamic output file generation using a input text file with predefined output format

Hi, I have two files , one file with data file with attributes that need to be sent to another file to generate a predefined format. Example: File.txt AP|{SSHA}VEEg42CNCghUnGhCVg== APVG3|{SSHA}XK|"password" AP3|{SSHA}XK|"This is test" .... etc --------- test.sh has... (1 Reply)
Discussion started by: hudson03051nh
1 Replies

6. Solaris

Question on kstat output

I'm having a little trouble understanding the output I'm seeing from kstat for the "net" class. I'm seeing a lot of entries with "mac" as the name, like this. module: bge instance: 3 name: mac class: net ... (3 Replies)
Discussion started by: Midcain
3 Replies

7. Shell Programming and Scripting

Question about output to file

Hi, I am try to setup a FOR loop script to find out all the existing linux workstations in the network w/ ip address, hostname and linux version. I created a basic FOR loop script: for i in $(seq 1 254) do echo 10.72.169.$i >> result ssh -o ConnectTimeout=3 root@10.72.169.$i "hostname"... (1 Reply)
Discussion started by: beeloo
1 Replies

8. UNIX for Dummies Questions & Answers

wget output question

Hello there, İ want to ask a very simple question. I want to read the output messages of wget both in terminal and also put them into a text file. i know that by using -o flag, i can log the messages into a text file but then i won't be able to see them on terminal. I'd appreciate any help... (1 Reply)
Discussion started by: sertansenturk
1 Replies

9. Shell Programming and Scripting

display and output...question

Hi, I have a small question about the value cannot display correctly: MSG=log fruit=apple print "No $fruit in the store" > "$MSG/fruit_message.txt" output: No $fruit in the store should be: No apple in the store AND $MSG/fruit_message.txt ----------> cannot find the... (5 Replies)
Discussion started by: happyv
5 Replies

10. Programming

A question about output.

I am learning output the data to a file using "ofstream". I need to read data from a file and output the result to the other file in 2 different ways. To do that I have to provoke two functions, and they have to output the result to the same text file. My problem is: they are correct on the screen... (2 Replies)
Discussion started by: HOUSCOUS
2 Replies
Login or Register to Ask a Question