C Oracle Database for z/OS System Symbols

This appendix documents Oracle Database for z/OS system symbols for use in generating unique filenames.

C.1 System Symbols

Oracle Database for z/OS system symbols can be incorporated into SQL scripts and parameter files to guarantee that unique filenames are generated with values specific to the server instance or session.

Symbol	Description
&ORAPREFD	A high level (leftmost) dsname qualifier for use in database filenames. It is derived from the database region parameter DSN_PREFIX_DB or ORAPREFD For more information, refer to the description in chapter 3.
&ORASESST	A distinct session identifier for use in data set names. It is based on the OSDI pid (process id) in hexadecimal format. However, if the hexadecimal representation of the pid begins with 0-9, it is converted to G-P, respectively.
&ORASRVN	The OSDI service name without trailing blanks.