Compress while wrting to a file using a unix pipe - HP-UX

booyena1 · #1 (**permalink**) 10-25-2005

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

jim mcnamara · #2 (**permalink**) 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

booyena1 · #3 (**permalink**) 10-25-2005

Thanks Jim you are a star

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
unix script to takes the old data from a TXT file and compress them into new file	vpandey	Shell Programming and Scripting	2	03-05-2008 07:10 AM
splitting a pipe delimited file in unix	ddedic	Shell Programming and Scripting	4	03-19-2007 09:16 PM
compress a file in unix	rujupriya	UNIX for Dummies Questions & Answers	5	05-24-2006 05:05 AM
Compress in Unix	Sasuke	UNIX for Dummies Questions & Answers	1	10-10-2003 04:18 AM
Unix compress-Wintel uncompress	rampart1	UNIX for Advanced & Expert Users	3	09-07-2003 01:33 AM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode