spool to symbol in vms

  • From: "Reardon, Bruce \(CALBBAY\)" <Bruce.Reardon@xxxxxxxxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 8 Sep 2006 09:13:57 +1000

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> 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;
    2001             2       NULL
1 row selected
Hope this helps,
Bruce Reardon

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On 
Behalf Of Reidy, Ron
Sent: Friday, 8 September 2006 2:13 AM
To: barb.baker@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Barbara Baker
Sent: Thursday, September 07, 2006 10:06 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: spool to symbol in vms


OpenVMS 7.3-1

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, 
. . . . .

Thanks for any help!


This electronic message transmission is a PRIVATE communication which contains 
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.

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.

Other related posts: