SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
F-35
Considerations—FUP
You can also use ALLOW, CTRL-Y, EXIT, FC, HELP, RESET, SET, SHOW, SYSTEM,
and VOLUME to perform operations on files. When you return to SQLCI, the default
system and volume are those that were in effect when you invoked FUP.
If a table or view is encountered during the processing of a FUP command that does
not support SQL objects, the table or view is skipped and a warning message is
issued.
Considerations—FUP

If you use FUP DUP to duplicate an object program, the SQL SENSITIVE and SQL
VALID flags in the file label of the new file are turned off, and you receive a warning
message that the file must be compiled by SQL.

If you apply the FUP LICENSE command to an SQL object program file, the file is
licensed. This method is the only way to license an SQL object program file.

You can display information about Enscribe files and SQL objects by using either
the FUP INFO command or the SQL FILEINFO utility. The only significant
difference between the two utilities is that the fileset-list parameter of FUP
INFO does not support the FROM CATALOG option and does not handle wild-card
characters in the same way as the qualified-fileset-list parameter of the
SQL FILEINFO utility.
Examples—FUP

This example displays the files on the current subvolume:
>> FUP FILES;
$VOL1.DFLT
A1 A2 A3 A4

This example lists processes that currently have files and objects open on
subvolume ZYQ00001:
>> FUP LISTOPENS ZYQ00001.*;
$OSS000.ZYQ00001.Z00000T6
PID MODE USERID SD MYTERM PROGRAM FILE NAME
000,00,0000 W -S 104,2 00 $ZTN.#PTY03 $VOL1.S.PROG
$OSS000.ZYQ00001.Z00005NM
PID MODE USERID SD MYTERM PROGRAM FILE NAME
175,02,0111 R -S 104,11 01 $ST.#PTY04
$COBOL.COBOL.COBOL
>>

This example lists detailed information about an OSS file:
>> FUP INFO $OSS001.ZYQ00002.Z00000A1,DETAIL
$OSS001.ZYQ00002.Z00000A1
OSS