SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
F-33
FUP Command
For more information, see the entry for a specific function.
FUP Command
FUP is an SQLCI command that executes File Utility Program (FUP) commands. FUP
commands perform operations such as creating, purging, and displaying files. (For a
complete description of FUP commands, see the File Utility Program (FUP) Reference
Manual.)
run-option-list
is one or more run options of the TACL RUN command, described in the TACL
Reference Manual. If you do not specify IN in-file or OUT out-file, the
SQLCI IN file and OUT file are used. If the current SQLCI OUT file is a disk file,
you must close the file by entering OUT before you use the FUP command. SQLCI
cannot redirect FUP output to a disk file.
fup-command-line
is a FUP command up to 132 characters long. To continue a command on the next
line, press Return. The SQLCI command continuation prompt (+>) appears.
If you specify fup-command-line, FUP returns you to SQLCI after the command
finishes. If you omit fup-command-line, FUP prompts you for each command and
returns you to SQLCI when you enter the EXIT command.
FUP Commands and SQL Objects
FUP commands work on SQL-compiled object program files but generally do not work
on other SQL objects. Some SQLCI commands perform the same or similar operations
on SQL objects. For example, you can use FILEINFO or FUP INFO with either SQL
objects or Enscribe files, but you must use SQLCI's COPY, DUP, LOAD, PURGE, or
SECURE to operate on SQL objects.
Table F-3
on page 34 lists the FUP commands that perform operations on files and
indicates whether the commands work with objects other than SQL object programs.
For FUP commands that do not work with SQL objects, Table F-3 on page F-34 lists
the SQL command or SQL utility that performs the equivalent function if one exists.
MIN Function Returns a minimum value for a column or set of values
PAGE_NUMBER
Function
Returns the page number of the current page in a report
SETSCALE Function Specifies the scale of a host variable
SUM Function Computes the sum of a set of numbers
UPSHIFT Function Upshifts single-byte characters
FUP [ /run-option-list/ ] [fup-command-line] ;