spool to symbol in vms

From: Reardon, Bruce \(CALBBAY\) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Fri, 8 Sep 2006 09:13:57 +1000
Message-ID: <B1C87DCFE2040D41B6F46ADF9F8E4D9C3F6D0D@CALBBEX01.cal.riotinto.org>

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



  _____  

This electronic message transmission is a PRIVATE communication which contains information 
which may be confidential or privileged. The information is intended to be for the use of the individual 
or entity named above. If you are not the intended recipient, please be aware that any disclosure, 
copying, distribution or use of the contents of this information is prohibited. Please notify the sender 
of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), 
and then delete it from your system.


NOTICE
This e-mail and any attachments are private and confidential and may contain privileged information. If you are not an authorised recipient, the copying or distribution of this e-mail and any attachments is prohibited and you must not read, print or act in reliance on this e-mail or attachments.
This notice should not be removed.

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

Received on Thu Sep 07 2006 - 18:13:57 CDT