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

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

Other related posts: