RE: spool to symbol in vms

From: Jesse, Rich <Rich.Jesse_at_qg.com>
Date: Fri, 8 Sep 2006 08:56:59 -0500
Message-ID: <FB5D3CCFCECC2948B5DCF4CABDBE6697A5217E@QTEX1.qg.com>

This might work with Oracle, but the redef of SYS$OUTPUT will most likely include extraneous text in the output, which would then have to be stripped in order for that output to be useful.  

Rich

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Reardon, Bruce
(CALBBAY)
Sent: Thursday, September 07, 2006 6:14 PM To: oracle-l_at_freelists.org
Subject: spool to symbol in vms

Barb,
I haven't got Oracle on VMS so can't test spool but how about doing this (which doesn't use spool but redefines standard output) - demonstrated with Rdb:
BBV013> tmp == "fred.txt"
BBV013> show sym tmp
  TMP == "fred.txt"

BBV013>
BBV013> define sys$output 'tmp
BBV013> sql
SQL> at 'f pas_batch_db';

SQL> select * from pot limit to 1 row;
SQL> Exit
BBV013> deass sys$output
BBV013> ty 'tmp
SQL> declare transaction read only;
SQL> SET NOVERIFY;
 POT_NUM POTLINE_NUM POT_PSTN
    2001 2 NULL
1 row selected
BBV013>   Hope this helps,
Bruce Reardon

	-----Original Message-----
	From: oracle-l-bounce_at_freelists.org


[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Reidy, Ron

	Sent: Friday, 8 September 2006 2:13 AM
	To: barb.baker_at_gmail.com; oracle-l_at_freelists.org
	Subject: RE: spool to symbol in vms
	
	

	Is this like Unix?  If so ...

	

	spool ${tmp}

	

	--

	Ron Reidy

	Lead DBA

	Array BioPharma, Inc.

	

	

	
________________________________


	From: oracle-l-bounce_at_freelists.org


[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Barbara Baker

	Sent: Thursday, September 07, 2006 10:06 AM
	To: oracle-l_at_freelists.org
	Subject: spool to symbol in vms

	

	OpenVMS 7.3-1
	Oracle 9.2.0.4
	
	Hi, all.
	Does anyone know how to spool to a symbol in vms?
	Here's my dcl.  I want to spool to the file identified by the
symbol tmp.  
	  $ val_sid = f$trnlnm("ora_sid")  
	  $!
	  $ sho sym val_sid
	  $   tmp = "tmp_"+"''val_sid'"+".txt"
	  $   sho sym tmp
	  $ sqlplus "/ as sysdba" 
	     spool 'tmp
	     select '$ STOP/IDENTIFICATION=' || p.spid proc_id from
v$session s, v$process
	. . . . .
	
	Thanks for any help!
	Barb

	

 

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Sep 08 2006 - 08:56:59 CDT