Kbase 19417: VMS Progress PROUTIL commands
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/01/2000 |
|
VMS Progress PROUTIL commands
-----------------------------
The following is a comparison between the Unix version of the Progress
Utility (PROUTIL) commmands and their VMS equivalents.
Notes:
1.) Under VMS, commands and their modifiers can be abbreviated to
the least recognizable substring. Example: PROGRESS/CREATE can
be abbreviated to PROG/CRE provided there are no other commands
that start with "PROG".
2.) Unlike Unix, VMS is not case-sensitive.
3.) Unix references environmental variables by preceding them with
a dollar-sign (i.e. $DLC/sports). VMS references logical names
by ending them with a colon (i.e. DLC:sports).
4.) Unix searches for executables and command scripts along the
directories listed in the PATH environmental variable. Under VMS,
commands must be either loaded into a command table (using the
SET COMMAND function), or created as a symbol (by equating a local
command to the path to the executable).
5.) To capture the output of a VMS command (i.e. DBANALYS, TABANALYS),
use the following commands:
DEFINE SYS$OUTPUT results.txt
PROGRESS/UTILITIES=DBANALYS testdb
DEASSIGN SYS$OUTPUT
PROUTIL two-phase commands
--------------------------
Unix: proutil db-name -C 2phase begin
VMS: PROGRESS/UTILITIES=2PHASE_BEGIN db-name
Command modifiers
-----------------
Unix VMS
---- ---
-crd /COORDINATOR
-tp nickname /NICKNAME=nickname
Unix: proutil db-name -C 2phase commit tr-number
VMS: PROGRESS/UTILITIES=2PHASE_COMMIT ts-number db-name
Unix: proutil db-name -C 2phase modify
VMS: PROGRESS/UTILITIES=2PHASE_MODIFY db-name
Command modifiers
-----------------
Unix VMS
---- ---
-crd /COORDINATOR
-tp nickname /NICKNAME=nickname
Unix: proutil db-name -C 2phase new
VMS: PROUTIL/UTILITIES=2PHASE_NEW db-name
Unix: proutil db-name -C 2phase recover
VMS: PROUTIL/UTILITIES=2PHASE_RECOVER db-name
PROUTIL analysis commands
-------------------------
Unix: proutil db-name -C chanalys
VMS: PROGRESS/UTILITIES=CHANALYS db-name
Unix: proutil db-name -C dbanalys
VMS: PROGRESS/UTILITIES=DBANALYS db-name
Unix: proutil db-name -C tabanalys
VMS: PROGRESS/UTILITIES=TABANALYS db-name
Unix: proutil db-name -C ixanalys
VMS: PROGRESS/UTILITIES=IXANALYS db-name
Other PROUTIL commands
----------------------
Unix: proutil db-name -C bulkload fd-file
VMS: PROGRESS/UTILITIES=BULKLOAD/DESCRIPTION=fd-file db-name
Unix: proutil db-name -C busy
VMS: PROGRESS/UTILITIES=BUSY db-name
Note: If you check the return code ($STATUS on VMS), it will
have one of three possible values:
1.) Database free - %X00000001
2.) Database in multi-user mode - %X08018043
3.) Database in single-user mode - %X0801803B
Unix: proutil -C codepage-compiler inputfile outputfile
VMS: PROGRESS/UTILITIES=CODEPAGE_COMPILER inputfile outputfile
Unix: proutil db-name -C collation-compiler language-source-file
VMS: PROGRESS/UTILITIES=COLLATION/INPUT_FILE=language-source-file db-name
Unix: proutil db-name -C conv78
VMS: PROGRESS/UTILITIES=CONV78 db-name
Unix: proutil db-name -C convchar function codepage
VMS: PROGRESS/UTILITIES=CONVCHAR db-name function codepage
Unix: proutil db-name -C dbauthkey old-key new-key
VMS: PROGRESS/UTILITIES=DBAUTHKEY old-key new-key
Unix: proutil -C dbipcs
VMS: No VMS equivalent
Unix: proutil db-name -C holder
VMS: PROGRESS/UTILITIES=HOLDER db-name
Note: If you check the return code ($STATUS on VMS), it will
have one of three possible values:
1.) Database free - %X00000001
2.) Database in multi-user mode - %X08018043
3.) Database in single-user mode - %X0801803B
Unix: proutil db-name -C idxbuild
VMS: PROGRESS/UTILITIES=IDXBUILD db-name
Command modifiers
-----------------
Unix VMS
---- ---
-TB blocksize /TBLOCKS=blocksize
-TM n /MERGE_NUM=n
Unix: proutil db-name -C idxbuild all
VMS: PROGRESS/UTILITIES=IDXBUILD_ALL db-name
Command modifiers
-----------------
Unix VMS
---- ---
-TB blocksize /TBLOCKS=blocksize
-TM n /MERGE_NUM=n
Unix: proutil db-name -C idxcheck
VMS: PROGRESS/UTILITIES=IDXCHECK db-name
Unix: proutil db-name -C rcodekey old-key new-key files...
VMS: PROGRESS/UTILITIES=RCODEKEY db-name old-key new-key files...
Unix: proutil db-name -C truncate bi
VMS: PROGRESS/UTILITIES=TRUNCATE_BI db-name