File Utility Programming (FUP) Reference Manual

FUP Commands
File Utility Program (FUP) Reference Manual—523323-015
2-131
LISTOPENS Listing Format
name
is a device name made up of alphabetic characters, wild-card characters (* or
?), or a combination of both.
number
is a temporary file name made up of numbers, wild-card characters (* or ?), or
a combination of both. If $device is not specified, it defaults to the current
volume.
ansiname-list
ansiname-list = ‘ansiname’ [ , ‘ansiname’ ]...
identifies SQL/MX ANSI Name catalogs, schemas, tables, indexes, partitions of
tables and indexes, and any combination of these objects. A single quote ( ' ) is
required to precede and delimit each ansiname. The ANSI names syntax is in
accordance with Unified Syntax Proposal. The syntax is:
SCRATCH scratch-filename
names a file or volume to be used for temporary storage during the sorting phase.
If you omit this option, LISTOPENS uses a temporary file on the default volume.
LISTOPENS Listing Format
Example 2-11 shows the format the FUP LISTOPENS command uses to display file
information. The first line of the display lists the file name specified in the LISTOPENS
command.
s
is the network node number of the node running the process that has the specified
file open in the command.
c,p
is the processor number and process number of the process.
-p or -b
indicates that this is the primary or backup process (respectively) of a process pair.
Note. For more description about ansiname-list, see ansiname-list on page 2-124.
Example 2-11. FUP LISTOPENS Listing Format
[ \node.]$volume.subvolume.file-id
PID MODE USERID SD MYTERM PROGRAM FILE NAME
s,c,p -pa -e g,u sd term prog-name
-b