Login or Register to Ask a Question and Join Our Community


HP-UX

Compress while wrting to a file using a unix pipe

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems HP-UX Compress while wrting to a file using a unix pipe
# 1  
Old 10-25-2005
Compress while wrting to a file using a unix pipe
I would like to know if the following can be done.

route output from an sql select directly to a pipe and compress it at the same time.

regards
Albert
# 2  
Old 10-25-2005
Oracle example:

Code:
# file = sql.sh
sqlplus -s username/passwd <<EOF
select count(*) from uzrutrf;
exit
EOF

usage
Code:
sq.sh | compress > sql.Z

# 3  
Old 10-26-2005
Thanks Jim you are a star
Thanks Jim you are a star
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. HP-UX

HP-UNIX How to zip/compress files in a folder?

Environment: HP-Unix Operating System B.11.31 U ia64 I have a folder with around 2000 files. There are some files which sizes are more than 8 GB. I need to compress all the files in the folder into a single file, so that I can transfer the file. I tried with tar command, but the tar... (8 Replies)
Discussion started by: Siva SQL
8 Replies

2. Shell Programming and Scripting

UNIX/PERL script to convert XML file to pipe delimited format

Hello, I need to get few values from a XML file and output needs to be written in another file with pipe delimited format. The Header & Footer of the Pipe Delimited file will be constant. The below is my sample XML file. I need to pull the values in between the XML tags <Operator_info to... (15 Replies)
Discussion started by: karthi1305561
15 Replies

3. Shell Programming and Scripting

How to ignore Pipe in Pipe delimited file?

Hi guys, I need to know how i can ignore Pipe '|' if Pipe is coming as a column in Pipe delimited file for eg: file 1: xx|yy|"xyz|zzz"|zzz|12... using below awk command awk 'BEGIN {FS=OFS="|" } print $3 i would get xyz But i want as : xyz|zzz to consider as whole column... (13 Replies)
Discussion started by: rohit_shinez
13 Replies

4. UNIX for Advanced & Expert Users

UNIX: Command to compress folder and all files into a tar

I am trying to grab a folder and all the folders and files underneath it and send it from one computer to another. I basically want to compress the whole folder into a tar, tgz, or zip file so that it can be sent as one file. is there a command to compress a folder and all its contents into a tar... (7 Replies)
Discussion started by: kane4355
7 Replies

5. UNIX for Dummies Questions & Answers

Issue: Compress in unix server and FTP to windows and open the compress file using Winzip

Hi All ! We have to compress a big data file in unix server and transfer it to windows and uncompress it using winzip in windows. I have used the utility ZIP like the below. zip -e <newfilename> df2_test_extract.dat but when I compress files greater than 4 gb using zip utility, it... (4 Replies)
Discussion started by: sakthifire
4 Replies

6. Shell Programming and Scripting

unix script to takes the old data from a TXT file and compress them into new file

Hi, I am looking for the unix script which can takes the 2 month old data from a TXT file (there is one txt file in whiche messages are appended on daily basis) and compress them into new file.Please halp me out. (2 Replies)
Discussion started by: vpandey
2 Replies

7. Shell Programming and Scripting

splitting a pipe delimited file in unix

Could one of you shad some light on this: I need to split the file by determining the record count and than splitting it up into 4 files. Please note, this is not a fixed record length but rather a "|" delimited file. I am not sure as how to handle reminder/offset for the 4th file. For... (4 Replies)
Discussion started by: ddedic
4 Replies

8. UNIX for Dummies Questions & Answers

compress a file in unix

Hi, I want to compress a dmp file and ftp to another machine.pls tell me the steps to compress and uncompress the file in unix Thankyou (5 Replies)
Discussion started by: rujupriya
5 Replies

9. UNIX for Dummies Questions & Answers

Compress in Unix

I tried Compress ; gzip and bzip . And they don't always compress files to small . Can someone tell me if there is any compress tool better than those ? thanks (1 Reply)
Discussion started by: Sasuke
1 Replies

10. UNIX for Advanced & Expert Users

Unix compress-Wintel uncompress

Is it possible to compress a large Unix file (16GB), then FTP it to a Wintel machine running XP then uncompress? I have already attempted to FTP the 16GB file but it stops at 4GB because XP FAT32 formtted drives will only allow 4GB file sizes. The 16GB file in Unix(Solaris) compresses to... (3 Replies)
Discussion started by: rampart1
3 Replies
Login or Register to Ask a Question