VMS Help CONVERT, file, Qualifiers *Conan The Librarian (sorry for the slow response - running on an old VAX) |
1 - /APPEND
Controls whether converted records from an input file are appended to an existing sequential file. Format /APPEND /NOAPPEND (DEFAULT) The /APPEND qualifier is useful when you want to convert an existing file to the format of an existing output file and append the converted records to the existing output file. If you specify the /APPEND qualifier and the /CREATE qualifier, /APPEND overrides the /CREATE. You should use this option when you are loading records into a sequential file that already contains records, or when you are creating a new sequential file. When the output file is a direct access file (relative or indexed), the /APPEND qualifier is ignored.
2 - /CREATE
Determines whether the Convert utility creates a file or uses an existing file for output. Format /CREATE (DEFAULT) /NOCREATE The /CREATE qualifier causes the Convert utility to create an output file instead of using an existing file for output. If the output file is to have different characteristics from the input file, you must also specify the /FDL qualifier.
3 - /EXCEPTIONS_FILE
Specifies whether an exceptions file (file type .EXC) is to be generated during the conversion. Format /EXCEPTIONS_FILE [=filespec] /NOEXCEPTIONS_FILE (DEFAULT) Specifies the file in which the exception records are returned. If you specify /EXCEPTIONS_FILE but omit the filespec parameter, the exception records are displayed on the SYS$OUTPUT device.
4 - /EXIT
Controls whether the Convert utility exits when it encounters an exception record. By default, the Convert utility continues processing records when it encounters an exception record. Format /EXIT /NOEXIT (DEFAULT)
5 - /FAST_LOAD
Specifies whether the Convert utility uses a fast-loading algorithm for indexed files. Format /FAST_LOAD (DEFAULT) /NOFAST_LOAD By default, the Convert utility uses the fast-loading algorithm, but if CONVERT/FAST_LOAD is executed across a network, the Convert utility automatically changes from /FAST_LOAD to /NOFAST_LOAD.
6 - /FDL
Indicates that an FDL file is to be used in creating the output file. Format /FDL=fdl-filespec Specifies the FDL file to be used in creating the output file. The newly created output file will have the name specified by the fdl-filespec command parameter; this name overrides any file name specified in the FDL file. The default file type for the FDL file is .FDL.
7 - /FILL_BUCKETS
Controls whether to override the bucket fill percentage parameter associated with the output file. Format /FILL_BUCKETS /NOFILL_BUCKETS (DEFAULT) If you specify /FILL_BUCKETS, the Convert utility fills the output file buckets with as many records as possible. This option is valid only for indexed output files.
8 - /FIXED_CONTROL
Controls file conversions between files having variable-length with fixed-length control field (VFC) records and files having other record formats. Format /FIXED_CONTROL /NOFIXED_CONTROL (DEFAULT) This qualifier applies only to conversions where either the input or the output file, but not both, uses VFC records. This option is applicable only to sequential files. o If you specify /FIXED_CONTROL and the input file uses VFC records but the output file does not, the fixed-length control field from the input record is inserted into the output record as data. o If you specify /FIXED_CONTROL and the output file has VFC records but the input file does not, the leading part of the input record is used to fill the fixed-length control part of the output record. o If you specify /NOFIXED_CONTROL and the input file uses VFC records but the output file does not, the fixed-length control field from the input record is not included as data in the output record. o If you specify /NOFIXED_CONTROL and the output file has VFC records but the input file does not, the control field attached to the output record is set to null.
9 - /KEY
Directs the Convert utility to read records from an indexed file using a specified key of reference, such as the primary key, the first alternate key, or the second alternate key. Format /KEY=n A numeric value that specifies the key of reference that the Convert utility uses for reading records from the input indexed file. For example, you can specify the primary key as the key of reference by using the value 0 (/KEY=0), which is the default, or you can specify the first alternate key as the key of reference by using the value 1 (/KEY=1). The /KEY qualifier is valid for indexed input files only. If you use the /KEY qualifier, you must specify a key value (/KEY=0, /KEY=1, and so on). If you do not specify the /KEY qualifier, the default is the primary key (/KEY=0).
10 - /MERGE
Specifies that records are to be inserted into their proper position in an existing indexed file. Format /MERGE /NOMERGE (DEFAULT) The /MERGE qualifier is useful when your input records are not sorted and you do not want them to be sorted as they are loaded into an output file. If you specify both /MERGE and /CREATE, /MERGE overrides the /CREATE qualifier.
11 - /PAD
Determines whether short records are to be padded. Format /PAD [=[%b]x] /NOPAD (DEFAULT) Specifies that the short records are to be padded with either ASCII characters (A through Z, a through z, or 0 through 9) or numeric values. To specify x as a numeric value, you must specify the numeric base using the percent symbol (%) followed by one of the following characters: D Indicates that x is a decimal number. O Indicates that x is an octal number. X Indicates that x is a hexadecimal number. The numeric value can be any number from 0 to 255.
12 - /PROLOG
Specifies the prolog version number of the output indexed file. Format /PROLOG=n Specifies the prolog number 1, 2, or 3. If you specify 2 for n, the output file will be either a Prolog 1 or a Prolog 2 file. If you specify 3, the Convert utility creates a Prolog 3 file for output. Prolog 3 files accept multiple keys (or alternate keys), all data types, and segmented keys. The only restriction to using a Prolog 3 file applies to files containing overlapping key segments for the primary key. In this case, you would have to use a Prolog 2 file. If you do not specify the /PROLOG qualifier, the Convert utility uses the prolog version of the first input file. If the input file is not indexed, the utility uses the RMS default. To see what this default is on your system, enter the DCL command SHOW RMS_DEFAULT. The /PROLOG qualifier overrides the value given with the FDL attribute KEY PROLOG.
13 - /READ_CHECK
Specifies whether each input record is to be read from the file a second time and compared to the record originally read. Format /READ_CHECK /NOREAD_CHECK (DEFAULT)
14 - /SECONDARY
Increases the Convert utility's performance by reducing the number of required passes through the input data. This is accomplished by placing alternate key information into the CONVWORK file. Format /SECONDARY=n Qualifier Value n Specifies the number of alternate keys that will be loaded to the CONVWORK file with each pass through the input data. This qualifier is valid when you are fast-loading a file with more than one alternate key. This option allows CONVERT to use more disk space for its work file than would be used by default. The default number of alternate keys written to the CONVWORK file is 1.
15 - /SHARE
Specifies whether the input file is to be opened for sharing with other processes during the conversion. Format /SHARE /NOSHARE (DEFAULT) You can use the /SHARE option to generate a rough backup of a file that is always opened for sharing by some applications. However, another process can alter the records during the Convert utility operations. As a result, the consistency of the output file cannot be guaranteed.
16 - /SORT
Specifies whether the input file is to be sorted before being loaded into an indexed file. The sort is done according to the primary key of the output file. Format /SORT (DEFAULT) /NOSORT Two procedures can improve the sort performance: o Increasing the size of the working set for the duration of the sort. o Placing the input file, the output file, and the temporary work files on separate disk devices.
17 - /STATISTICS
Determines whether statistics about the file conversion are to be displayed. Format /STATISTICS[=keyword] /NOSTATISTICS (DEFAULT) Keyword Meaning BRIEF Displays a summary of the file conversion at the completion of the operation. FULL Displays summary information at the completion of each key load containing Sort and Load statistics for the key. A summary of the file conversion is also displayed at the completion of the operation. If you specify the /STATISTICS qualifier without specifying a keyword, CONVERT defaults to /STATISTICS=BRIEF. The statistics produced by the Convert utility upon completion are as follows: o Number of files processed o Total records processed o Total exception records o Total valid records o Elapsed time o Buffered I/O count o Direct I/O count o Page faults o CPU time
18 - /TRUNCATE
Specifies whether records that exceed the maximum record length for variable-length records, or records that exceed the specified record length for fixed-length records, are to be truncated. Format /TRUNCATE /NOTRUNCATE (DEFAULT) If you specify /NOTRUNCATE and a long record is encountered, the record is not written to the output file. If you specify the /EXCEPTIONS_FILE qualifier, the entire record is written to the exceptions file.
19 - /WORK_FILES
Specifies the number of temporary work files to be used during the sort process. Format /WORK_FILES=n Specifies the number of work files you want. You can specify 0 or any value from 1 through 10. The default number of work files used during a sort is 2. This qualifier is valid when you are fast-loading a file with multiple keys or when you specify the /SORT qualifier. For more information about sorting, see both the /SORT and the /FAST_LOAD qualifiers.
20 - /WRITE_CHECK
Specifies whether all writes are to be checked by comparing the new disk records with the original records in memory. Format /WRITE_CHECK /NOWRITE_CHECK (DEFAULT) If you use this switch, each new record on the disk is read and then compared with the original record in memory.
|