Qshow in UNIX

[Cheek Bob]

Jones,
Try doing:
PH_PRINTER="cat >/dev/null";export PH_PRINTER
Before you do your QSHOW.  That should stop the output from going to the   
printer.
After the qshow you then do unset PH_PRINTER.

Bob Cheek
Visibility Inc.
Cheek@visibility.com

 -----Original Message-----
From: Jones Allen (Van) [SMTP:allen.jones@artioslink.com]
Sent: Wednesday, March 11, 1998 10:19 PM
To: 'powerh-l@lists.swau.edu'
Subject: Qshow in Unix

I have the following code to get the instance name of an Oracle database   
out of the powerhouse dictionary as follows, where "vpe" is the   
powerhouse file name:
curdb="'echo show database vpe summary|qshow|grep ORACLE'"
curdb="'echo $curdb|cut -f3 -d\@|cut -f1 -d\/'"
>From the qshow output "VPE ORACLE ORACLE@dbuser@dev520m/dbpassword", it   
extracts "dev520m".
(Note that opening the oracle database this way does not use the   
ORACLE_SID environment variable.)
This works, except in off-line processing, I can't prevent qshow from   
sending a copy of it's output to the printer.  I've tried:
* "export qsholist=/dev/null" before the line that has qshow
* ... echo 'set noprint\nshow database ...
* ... echo 'set report device terminal\nshow database ...
* even the following:
rm -f qshow.disk
echo 'show database vpe summary'|qshow > qshow.disk
curdb="'grep ORACLE qshow.disk'"
curdb="'echo $curdb|cut -f3 -d\@|cut -f1 -d\/'"
rm -f qshow.disk
...nothing seems to stop the printed output.
I'm working on an aix version of unix.  The HP-UX operating system does   
not do this.
Any help would be appreciated.  Thanks

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.